Variable Queries¶

Query Methods¶

DQL Query

PromQL Query

Data Type Query

External Data Source

Custom

Value Range¶

There are two ways to determine the value range of view variables:

• Follow the dashboard linkage, that is, list the data of the variable query according to the time range selected by the dashboard's time widget.
• Do not follow the dashboard linkage, that is, list all the data of the variable query, regardless of the time range selected by the dashboard's time widget.

Description of the value range of variable queries from different data sources:

DQL Query¶

DQL query supports manual statement writing, allows setting time range and enabling Cascade Query, and returns the required data immediately.

Click Learn more about DQL definitions and syntax.

Query Example:

Add Time Range¶

When using DQL statements for view variable queries, you can add the data query time range in the format of [xx:xx:xx]:

• If the time range is added in the DQL query, the time range in the DQL query will be used first.
• If the time range is not added in the DQL query, the time range selected by the dashboard time widget will be used by default.

Query Example:

# Query the list of container hosts in the last 10 minutes 
O::docker_containers:(distinct(`host`)) [10m]

Show Function Query¶

When using DQL queries, you can use the Show function to query and return the corresponding data values. The Show function does not support adding time range filtering.

Click Learn more about DQL function descriptions.

Query Example:

PromQL Query¶

PromQL query supports manual query statement writing, uses the time selected by the dashboard time widget by default for query and returns data.

For PromQL query related information, refer to PromQL Quick Start.

Data Type Query¶

Supports selecting the following data sources: Metrics, Basic Objects, Resource Catalog, Logs, APM, RUM.

In this mode, you cannot add time range or configure Cascade Query.

External Data Source¶

Integrate MySQL and other external data sources, directly call native query statements, and obtain data in real time.

1. Select the data source.
2. Enter the query statement.
3. Select the sorting method.

For more details, refer to External Data Source.

Custom Query¶

Directly define a set of values for view variables, without obtaining values through query statements. Each option is separated by an English comma ,. This query method does not support adding time range and configuring cascade query.

Cascade Query¶

When configuring multiple view variables and the second variable needs to be dynamically filtered based on the results of the first variable, the cascade query should be enabled.

The following takes the cascade query configuration of view variables in the Web Application Overview of RUM as an example, based on service, environment and version for linkage query:

You need to configure three variable query statements in the dashboard, and the second and third query statements use the #{Variable Name} configured in the first query:

• Variable 1 (Service): Query all application lists:

T::re(`.*`):(distinct(service))

• Variable 2 (Environment): Query all application lists, and the environment list selected in Variable 1:

T::re(`.*`):(distinct(env)) { service = '#{service}'}

• Variable 3 (Version): Query all application lists, and the version list selected in Variable 2:

T::re(`.*`):(distinct(version)) {service = '#{service}'}

Use Case Examples¶

Associate view variables with charts to implement linkage filtering

1. In the chart query, when filtering fields, select the variable in the value field.

2. Switch the variable value in the scenario view, and the chart will be filtered and displayed according to the variable label.

Chart reverse addition to achieve global linkage

1. Click on a specific time series or data point in the chart.
2. Select Apply to View Variable.
3. The system automatically fills in the query.