Table of Contents

Creating a GQI query

The "Queries" data item allows you to construct a query in order to tap into the wealth of data available in your DataMiner System using the Generic Query Interface.

Tip

See also: Building Queries with DataMiner Generic Query Interface (GQI) Video

Creating a query

  1. In edit mode, select the dashboard component for which you want to use a query as a data input.

  2. In the data pane, select Queries and click the + icon to add a new query.

  3. Specify a name for the query.

    Note

    From DataMiner 10.2.0 [CU2]/10.2.5 onwards, a query must have a unique name. If you edit an existing query that has no name, you will need to specify a unique name for it. Prior to this, starting from DataMiner 10.1.0/10.1.1, a query name is optional but highly recommended.

  4. In the drop-down box below this, select the data source you want to use. For a detailed overview of all available data sources, see Query data sources.

    Important

    It is also possible to configure an ad hoc data source in a query. For more information, see Configuring an ad hoc data source in a query.

  5. Select an operator. This step is optional; if you do not select an operator, the data set will be returned untouched. See Query operators.

  6. Drag the configured query to the component in order to use it.

Note
  • From DataMiner 10.1.4 onwards, you can import a query from a different dashboard in the DMS. For more information, see Importing a query
  • Using the Data Aggregator module, you can schedule GQI queries to run periodically at fixed times, dates, or intervals. For more information, see Data Aggregator.

Duplicating a query

From DataMiner 10.3.0 [CU10]/10.4.1 onwards, you can duplicate a query. To do so, click the "..." button next to the query in the data pane and then select Duplicate.

Notes on GQI queries

Please note the following regarding query data input:

  • When a query has been created, the columns from the table that results from the query are available as individual data items in the data pane, so that you can use them to filter or group a component.

  • It is not possible to retrieve data from a stopped element.

  • From DataMiner 10.1.0/10.1.3 onwards, dynamic units will automatically be used when applicable for the retrieved data if this is enabled in the dashboard settings. This means that parameter units will change dynamically based on their value and protocol definition. You can override the behavior configured for the dashboard in the settings for the component.

  • From DataMiner 10.2.0/10.1.4 onwards, if a row is selected in a table component that uses a query data source, any view, service, or element linked to that row is also exposed as a data source. In practice, this means that a data source will be available in the Components or Feeds section of the data pane (depending on your DataMiner version) that will change based on the selection in the table.

    Selected rows
    Data tab in DataMiner 10.4.12

  • From DataMiner 10.2.0/10.1.5 onwards, you can link GQI nodes that require a time range selection to a time range component by selecting the From data checkbox. Prior to DataMiner 10.3.0 [CU21]/10.4.0 [CU9]/10.4.12, this setting is called "From feed".

  • From DataMiner 10.3.0 [CU9]/10.3.12 onwards, the culture used in your GQI query matches the client culture of the web app. Prior to DataMiner 10.3.0 [CU9]/10.3.12, the invariant culture is used.

  • From DataMiner 10.3.0 [CU18]/10.4.0 [CU6]/10.4.9 onwards, a maximum of 30 GQI queries can be added to a dashboard, and a maximum of 200 GQI queries can be added to a low-code app. Once this limit has been reached, no additional GQI queries can be added, imported, or duplicated until one or multiple queries have been removed.

Propose changes