Fields to SQL Query - Report Writer Feature

johnwilly

One of the features I find useful with the Report Writer is once you select all the fields we can view the SQL query.

This was useful when we want to build advanced reports so that we can refer to the correct table. Now that Report Writer is gone is there any way we can do this from the Web console?

bobmarley

Yes that was a very nice feature to have. I would suggest loading up SWQL studio and spending some time learning where the data is located, most of it is under Orion.Nodes and then learning how to do 'joins' in SWQL. Once you get that working you will find it much easier to write your reports, widgets, etc in SWQL than using the web based tools.