Skip to main content

Create or open queries

Perform multiple queries in separate tabs

A query fetches qualifying items of a design/interface and displays their attribute values.

You can perform any number of queries in the Data Explorer app. The results of each query are displayed in separate tabs, which you can switch between to compare multiple sets of items.

A screenshot showing 4 query tabs in the app bar, which are also shown in the open Query Tabs popover

New query

To create a new query:

  1. Select Add query in the top-left corner and choose From design or interface.

  2. In the Search window, choose the design you want to query. Alternatively, choose an interface to query all the designs that implement it. Scroll the list or use the search box to find the one you want.

    Advanced search

    To refine your search results, select Advanced search beside the search box. You can use these settings to filter the resulting designs and interfaces in various ways.

    Only show designs and interfaces which:

    • Child design or interface - have a Link attribute that points to the selected design, or a design that implements the selected interface.

    • Implements interface - implement the selected interface.

    • User group - are accessible to the selected group.


    Select Apply to filter the results according to your settings. To clear these settings (but not the search box), select Reset.

  3. Select the attributes you want to see data for. Each attribute will appear as a column in the table, displaying the values stored in each item.

  4. Refine your query by filtering and sorting its results.

The Search window showing designs and interfaces that match the term - street lights. The Advanced search panel is visible, with the Implements Interface setting set to - Assets

Open a saved query

To open a previously saved query:

  1. Select Add query in the top-left corner and choose From saved query:

  2. In the Search window, choose the saved query you want to open. Scroll the list or use the search box to find the one you want.

    The Search window listing available saved queries
  3. If the chosen query has any AQS parameters, enter values for them when prompted. Some may have a default value. This lets you customise the query for your current session (parameters aren't saved). To change these inputs when the query is open, select AQS parameters in the bottom toolbar.

    The AQS Parameters window with fields for Operational Area, Start Date and End Date

Load from code

To load an AQS query written in JSON code format:

  1. Select Add query in the top-left corner and choose either option.

  2. In the Search window, choose any design/interface or saved query temporarily, and then select Filter with AQS in the bottom toolbar.

  3. In the AQS Builder, select Open JSON Editor in the bottom-right corner. Paste your code into the editor and select Done.

  4. Select Done again to return to the Data Explorer and see the results of your query.

Entering JSON code into the Advanced Query Editor in the AQS Builder