Viewing a SQL grid

InfoWorks WS Pro implements its own subset of SQL (Structured Query Language) for selecting and updating network objects using specified criteria.

The results of a SQL query can be viewed on a grid. The contents of the grid can also be saved in a CSV file.

To view a SQL grid:

  1. Create and run the SQL query.
  2. Click the SQL Grid tab and choose the fields to include on the grid.
  3. Check the Open selection in grid view box.
  4. Click Run.

SQL and stored queries