Creating a Query on-the-Fly
  • 27 Nov 2023
  • 1 Minute to read
  • Dark
    Light
  • PDF

Creating a Query on-the-Fly

  • Dark
    Light
  • PDF

Article Summary

When selecting the asset module in chart configuration, instead of selecting an existing saved query, you can create a query on-the-fly using filters. Once you have the filters how you want them, use the Asset Preview to save the filters as a new saved query.

On-the-fly query is available on all charts that have the filter option.

To create an on-the-fly query:

  1. In the chart configuration pane, for each query, select an asset module type. Once this is selected, the Filter becomes enabled for that query.
    Query-on-the-fly-3.png

  2. Leave the query selection empty and click the Filter icon.
    Query-on-the-fly-4.png

  3. In the filter box, set the filter parameters. Click + to add more lines.
    Query-on-the-fly-5.png

    See Creating Queries with the Query Wizard for more about the options in this box.

  4. Click Close to close the Filter box and apply the filter to the chart. A red dot on the Filter icon indicates that a filter has been applied.
    Query-on-the-fly-6.png

  5. To save this filter as a new saved query, click the chart section that represents that filter. Then, in the Asset Preview, click Save As, and in the Save as a New Query window, fill in the options you want and click Save. The filter is now a saved query and can be found in the Queries page.
    Query-on-the-fly-7.png



Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.