Topics in this section describe the Structured Query Language (SQL) used by InfoWorks WS Pro, and the database objects (stored queries) that can be used to save and reuse SQL queries.
- What's New in InfoWorks WS Pro
- Release Notes
- InfoWorks WS Pro Help
- Key concepts
- Getting started
- Product licenses
- Autodesk InfoWorks WS Pro Viewer
- Acknowledgements
- Tutorial
- The workspace
- Import Network Data
- Managing your data
- Database objects
- Working with database objects
- Database object list
- About networks
- About controls (control data)
- About live data
- About alternative demand
- About baselines
- Digitisation templates
- About the GeoExplorer
- Custom reports
- Creating and updating demand diagrams
- About demand scaling
- About electricity tariffs
- Energy CO2 Factors Data
- Working with engineering validation
- Export style
- About Fire Flow Data objects
- About flushing schedules
- Generalised Multi Run Configuration dialog
- Working with saved graphs
- Ground Model
- IWLive Switch Controller
- Inference
- Working with GeoPlan labels
- About layer lists
- About runs
- Using selection lists
- About solute data objects
- SQL and stored queries
- About SQL in InfoWorks WS Pro
- About stored queries
- Creating SQL queries
- Saving SQL queries as stored queries
- Viewing a SQL grid
- Selecting objects using a query
- Exporting SQL expressions
- Exporting SQL query results to a CSV file
- Exporting SQL Queries to Event files
- Importing SQL Queries from Event files
- SQL for selecting objects
- SQL for updating data
- SQL syntax
- SQL and connected objects
- SQL and array data
- SQL and spatial searches
- SQL examples
- SQL dialog
- Results grid window (SQL query results)
- Themes
- About user programmable control (UPC)
- Warning Templates
- Workspaces
- dialogs
- About demand
- About graphing
- Results
- About Administrator operations
- Contact Us
- Glossary
- Latin and Greek character reference
- Technical Notes and References
- InfoWorks Exchange