InspiRD Query Language (IQL)
IQL can be used to perform complex queries across all InspiRD applications. IQL is used filters, dashboards, widgets and reports. IQL syntax is described below:
Simple: @ColumnName CONDITION Value
Compound: @ColumnName CONDITION Value AND @ColumnName CONDITION Value OR @ColumnName CONDITION Value ORDER BY @ColumnName Type
Target Field / Column Name
@ColumnName specifies the column for the query. Type the @ character followed by first few characters of the column name. Column names are available in the grid view of any tab. The application will display applicable column names in a small drop down. Use up and down arrows to select the correct column and press the tab key. Or use the mouse to click the field name.
Conditions
- Numerical Conditions: “=”, “<=”, “<“, “>”, “>=”
- Applicable to non text fields
- e.g. @LaborBudget < “100”
- Range Condition: BETWEEN (“Value 1”, “Value 2”)
- Applicable to non text fields.
- e.g. @LaborBudget BETWEEN (“100”, “200”)
- Text Condition: LIKE “*Text~”
- Applicable to text type fields. e.g. @Title LIKE “Program*”
- Use * and ~ and wild cards as described above
- Selection condition: CONTAINS (“Value 1”, “Value 2″, Value 3”, …)
- Applicable to all types of fields
- e.g @Description CONTAINS “Program” or @Description CONTAINS (“Program”, “Product”)
- Selection condition: IN(“Value 1”, “Value 2”, “Value 3”, …)
Complex conditions
- Multiple conditions can be combined using AND or OR operators
- e.g @Title CONTAINS “Program” AND @DeliveryDate < “2019-12-31” OR @StartDate > “2019-01-01”
Values
- All values need to be enclosed in quotes
- Dates need to be specified as yyyy-mm-dd and enclose dates in quotes “2019-01-02”
- For drop down and multi-select fields, specify numerical values for the choice. e.g @ProjectPhase < “5”.
Operators
- ORDER BY @ColumnName Type
- Orders results by type Ascending or Descending
- e.g. @LaborBudget < “100” ORDER BY @Title ASCE