Exporting SQL Expressions

The Open Data Export Centre allows data to be exported from InfoWorks ICM to a variety of formats.

In addition to exporting InfoWorks ICM data field values, the results of an SQL Expression can also be exported.

Any field available in the fields list is available to SQL, along with the normal SQL functions.

SQL Expressions can be used to:

To export the result of an SQL Expression using the Open Data Export Centre, select a Field Type of SQL and enter the SQL Expression in the Internal Field (or other data) column in the Field Mappings Grid:

Open Data Export Centre

Open Data Export Centre Dialog

SQL Syntax