Create Queries and Rules

A query is a condition statement that is answered with a "True" or "False" output.

For example, "Risk grade equals Extreme" or "Structural Peak Score is greater than 4".

A rule is the logic created to build the query.

To build a query:

1. Click on add (+) Query
2. At the top of the panel, enter a name that reflects the condition statement. This name is that will be displayed on the tree. For example, "Is risk grade extreme?".
3. Click on Add Rule to build the query logic.
4. Select a Record Type (see below for more details), Field, Operator and Value. The options available will vary depending on what you select.
   For example:

   • Record Type: Inspection
   • Field: Risk Has_Inspection
   • Operator: Boolean
   • Value: Yes
5. Click Save.
6. Add more rules or filters if you want a more complex query. See examples below.
7. When you have finished building your rules, click Add to Tree.

Record types

• Inspection: This data comes from the latest inspection associated to the asset.
• Asset Attributes: This comes from the asset GIS data that was imported.

  The "Calculated_Buried_Depth" and "Calculated_Gradient" are calculated from the imported data.

• Risk: You can choose which published risk model you want to use in your decision tree. The risk data comes from the latest run of the risk model you select.

  You can query total risk scores as well as individual CoF and LoF component scores.

• Condition: This data comes from the condition scores from the latest inspection associated to the asset.
• Custom Tables: Any custom table data you have uploaded. The fields available are those you mapped during the import process.
• Task: You can choose from the task types you have uploaded and the fields you mapped during the import process. The data used is from the most recently completed task (for the selected task type).

Queries with more than one rule

You can create more complex queries by adding And/Or operators and additional rules.

For example, this query has two sets of grouped rules and will find assets that have inspections from before 2012 OR that don't have any inspections and have an Extreme risk grade.

Queries with filters

For certain fields, it is possible to add a filter to query specific characteristics of that field. For example, if you add a rule with the Defect Count field, you can add a filter for specific defect codes.

The Open Filters option will appear when you create a rule with fields that support filters.