...
You can use the rtvquery plugin to assign a list of values to a dashboard variable from a single column in a cache table. This The variables can be useful for filtering queries on panel objects, as described above.
Click the dasboard settings (gear) icon, then select the Variables tab, then add a new variable or select an existing one. In the General section, set Type = Query. Then in the Query Options section, select an rtvquery instance from the Data Source dropdown. Set Refresh = On Dashboard Load, so that the query is run each time the dashboard is loaded.
...
If you want to apply a filter to the column so that only certain values from the column are used, add a " filter " field with to specify column name:value pairs. For example, this query gets values from the Plant column in the plants cache, but only from rows where Status = online and On Schedule = the value in the Status column is "online" and the value in the On Schedule column is true:
| Code Block |
|---|
{
"cache": "plants",
"column": "Plant",
"filter": {"Status": "online", "On Schedule": true}
} |
...