SQL Query View

SQL queries are used for selecting objects of the network according to a set of criteria. The SQL Query view displays a grid showing the results of running a query.

Each row on the grid shows the details of one object of the network that satisfies the SQL query conditions. The columns that are displayed are those selected in the Grid tab of the SQL dialog.

You can change the width of columns by dragging the column dividers and the height of rows by dragging any row divider.

Exporting the grid to a CSV file

You can export the contents of the grid to a comma separated variable file (for example, to load values into an Excel spreadsheet):

1. To select the whole grid, click on the square at the top left-hand corner of the grid (underneath the title bar).
2. Select Export to file from the Edit menu.
3. Choose whether or not you want to export the column headings, as well as the data values.
4. Enter a name for the CSV file.

For further information on setting up the SQL Query view, see the SQL Grid tab.

For information on selecting network objects using SQL queries, see SQL Dialog.