search

VolkovLabs / business-table

The Business Table panel is a Grafana plugin that allows to summarize large amounts of data from various data sources.
https://docs.volkovlabs.io
Apache License 2.0
10 stars 0 forks source link

Data links in business table completely reload dashboard #126

Open gdemin opened 1 week ago

gdemin commented 1 week ago

I have a data link in the column of the table in the form  of  d/${__dashboard.uid}?var-number=${__data.fields.a}.  This link sets the variable number to some number. With the usual Grafana table it works almost instantly. With Business table clicking on such a link completely reloads the dashboard.  Reproducible example in the attached JSON.

JSON ```json { "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "type": "dashboard" } ] }, "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": 64, "links": [], "panels": [ { "datasource": { "default": true, "type": "grafana-clickhouse-datasource", "uid": "ddf31v6u22hogf" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "cellOptions": { "type": "auto" }, "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "a" }, "properties": [ { "id": "links", "value": [ { "title": "", "url": "d/${__dashboard.uid}?var-number=${__data.fields.a}" } ] } ] } ] }, "gridPos": { "h": 8, "w": 12, "x": 0, "y": 0 }, "id": 1, "options": { "cellHeight": "sm", "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true }, "pluginVersion": "11.2.0", "targets": [ { "datasource": { "type": "grafana-clickhouse-datasource", "uid": "ddf31v6u22hogf" }, "editorType": "sql", "format": 1, "meta": { "builderOptions": { "columns": [], "database": "", "limit": 1000, "mode": "list", "queryType": "table", "table": "" } }, "pluginVersion": "4.5.0", "queryType": "table", "rawSql": "select a \nfrom (\nselect 1 as a \nunion all select 2\nunion all select 3\nunion all select 4\nunion all select 5\nunion all select 6\nunion all select 7\nunion all select 8\nunion all select 9\nunion all select 10\nunion all select 11\nunion all select 12\n)\norder by a", "refId": "A" } ], "title": "Grafana table with links", "type": "table" }, { "datasource": { "default": true, "type": "grafana-clickhouse-datasource", "uid": "ddf31v6u22hogf" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "a" }, "properties": [ { "id": "links", "value": [ { "title": "", "url": "d/${__dashboard.uid}?var-number=${__data.fields.a}" } ] } ] } ] }, "gridPos": { "h": 8, "w": 12, "x": 12, "y": 0 }, "id": 2, "options": { "nestedObjects": [], "tables": [ { "items": [ { "aggregation": "none", "appearance": { "alignment": "start", "background": { "applyToRow": false }, "width": { "auto": true, "min": 20, "value": 100 }, "wrap": true }, "edit": { "editor": { "type": "string" }, "enabled": false, "permission": { "mode": "", "userRole": [] } }, "enabled": true, "field": { "name": "a", "source": "A" }, "filter": { "enabled": false, "mode": "client", "variable": "" }, "footer": [], "group": false, "label": "", "objectId": "", "pin": "", "sort": { "descFirst": false, "enabled": false }, "type": "auto" } ], "name": "table", "pagination": { "enabled": false, "mode": "client" }, "update": { "datasource": "", "payload": {} } } ], "toolbar": { "export": false } }, "pluginVersion": "1.5.0", "targets": [ { "datasource": { "type": "grafana-clickhouse-datasource", "uid": "ddf31v6u22hogf" }, "editorType": "sql", "format": 1, "meta": { "builderOptions": { "columns": [], "database": "", "limit": 1000, "mode": "list", "queryType": "table", "table": "" } }, "pluginVersion": "4.5.0", "queryType": "table", "rawSql": "select a \nfrom (\nselect 1 as a \nunion all select 2\nunion all select 3\nunion all select 4\nunion all select 5\nunion all select 6\nunion all select 7\nunion all select 8\nunion all select 9\nunion all select 10\nunion all select 11\nunion all select 12\n)\norder by a", "refId": "A" } ], "title": "Business table with links", "type": "volkovlabs-table-panel" } ], "schemaVersion": 39, "tags": [], "templating": { "list": [ { "current": { "selected": false, "text": "5", "value": "5" }, "hide": 0, "includeAll": false, "multi": false, "name": "number", "options": [ { "selected": false, "text": "1", "value": "1" }, { "selected": false, "text": "2", "value": "2" }, { "selected": false, "text": "3", "value": "3" }, { "selected": false, "text": "4", "value": "4" }, { "selected": true, "text": "5", "value": "5" }, { "selected": false, "text": "6", "value": "6" }, { "selected": false, "text": "7", "value": "7" }, { "selected": false, "text": "8", "value": "8" }, { "selected": false, "text": "9", "value": "9" }, { "selected": false, "text": "10", "value": "10" }, { "selected": false, "text": "11", "value": "11" }, { "selected": false, "text": "12", "value": "12" } ], "query": "1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12", "queryValue": "", "skipUrlSync": false, "type": "custom" } ] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": {}, "timezone": "browser", "title": "business table data links", "uid": "ee1jo0na37hmod", "version": 5, "weekStart": "" } ```
mikhail-vl commented 1 week ago

@gdemin Thank you for providing details. We will look into it.