Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Data links in business table completely reload dashboard #126

Open
gdemin opened this issue Oct 21, 2024 · 1 comment
Open

Data links in business table completely reload dashboard #126

gdemin opened this issue Oct 21, 2024 · 1 comment
Assignees
Labels
question Further information is requested

Comments

@gdemin
Copy link

gdemin commented Oct 21, 2024

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
{
  "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": ""
}
@gdemin gdemin changed the title Data links in business table are very slow Data links in business table completely reload dashboard Oct 21, 2024
@mikhail-vl mikhail-vl added the question Further information is requested label Oct 22, 2024
@mikhail-vl mikhail-vl moved this to Ready in Business Suite Oct 22, 2024
@mikhail-vl
Copy link
Member

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
Status: Ready
Development

No branches or pull requests

3 participants