Skip to main content

AQS Query node

Description​

The AQS Query root node fetches items of a single design/interface and their attribute data.

alt text

Usage​

All queries start with a root node. Its icon matches the design/interface being queried.

alt text

To filter the items fetched by the root node, select to add one or more child nodes.

Configuration​

Select the node to set the following properties:

  • AQS type - change to a different root node type.

  • Design or interface - items from this design/interface will be queried.

  • Collection - items from these collections will be queried. By default, only Live is selected.

  • Sort order - choose to sort in Ascending or Descending order.

  • Sort attribute - if set, items will be sorted according to the chosen attribute.

  • Sort item property - if set, items will be sorted according to the chosen property.

  • Attributes - select the item attributes that you want to see data for.

alt text
Note

The more attributes you select, the more data is returned. Therefore, for optimal performance, only include attributes that are meaningful to your query.

Example​

Fetch all bollards within this area, sorted by unit number

In full detail:

Fetch items of the Bollards design where their Geometry attribute is within a defined area, sorted by their Unit Number attribute in Ascending order

To see this example built step-by-step, see Example 2 - Geographic.

alt text
See JSON code

This code may reference designs, interfaces, attributes or items that don't exist in your Alloy database.

{
  "type": "Query",
  "properties": {
    "collectionCode": "Live",
    "dodiCode": "designInterfaces_defects"
  },
  "children": [
    {
      "type": "Equals",
      "children": [
        {
          "type": "Attribute",
          "properties": {
            "attributeCode": "attributes_defectsStatus"
          }
        },
        {
          "type": "AlloyId",
          "properties": {
            "value": ["5c8bdfb58ae862230019dc1f"]
          }
        }
      ]
    }
  ]
}