Exporting SQL Expressions
The Open Data Export Centre allows data to be exported from InfoAsset Manager to a variety of formats.
In addition to exporting InfoAsset Manager 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:
- Perform arithmetic e.g. x+y
- Perform logical tests e.g. x>15500
- Perform string manipulation e.g. x+”:”+y
- Generate strings based on values using iif e.g. iif(x<15000,'red',iif(x>15500,'green','amber'))
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:
