...
Both types of inputs can be used as variable elements for widgets. To do this, it is necessary to introduce specific functions both in the widget and input data sources. Remember that you need to activate the edit mode for this.
The widget's query must reference the required input through a script placed in the part of the query you want to substitute with the input values. This script consists of the input ID, a dot, and the word value (
InputID.value
), and can be accompanied by an operator depending on the function the input values fulfill inside the query.The input data source must reference the required functions that will translate into options to substitute the widget query with.
Info |
---|
About IDs All widget and input ID values are assigned automatically when created and can be read in the Data settings of the widget or input element. |
...
Depending on the data to be entered in the input and their function inside the widget query, you can use the following types of expressions and operators :described below.
In the widget | In the input |
---|---|
| |
Use this expression in the widget query as a placeholder for whole queries. | Enter the required query in the input and the widget will display the query results. |
Example
| Example
|
| |
Use the | Enter the required filtering options in the input and the widget will display the result of the filter operation. |
Example
| Example
|
| |
Use the | Enter the required query part or field in the input and the widget will display the results. |
Example
| Example
|
...
Expand | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Use the following query in a table widget to create a dynamic table that allows you to specify the source data table, the grouping period, and the grouping key.
The table is linked to three different Select-type inputs populated with the values shown below.
The following capture shows the table after selecting |
Expand | ||||||
---|---|---|---|---|---|---|
| ||||||
Use the following query to feed a column widget to display the count of methods with response times greater than a specified value and grouped by a period selected from a list of values.
The inputs are populated with the values shown below.
The following capture shows the column widget after selecting 15m in the select input as grouping period and entering 500 in the free-text input as filtering value, so that only methods with response times greater than 500 are shown in each five-minute. You must select the count field as the y-axis value and add the method field as a series in the Visual settings of the column widget. |
...