Grafana offers an elegant way to create dashboard variables where user sees/selects from friendly “__text”, but queries operate on the non-displayed “__value” - Githubissues

vertica / vertica-grafana-datasource

Official Vertica datasource plugin for Grafana.

https://grafana.com/grafana/plugins/vertica-grafana-datasource/

Apache License 2.0

3 stars 9 forks source link

Grafana offers an elegant way to create dashboard variables where user sees/selects from friendly “text”, but queries operate on the non-displayed “value” #13

Closed tanvipise closed 1 year ago

tanvipise commented 2 years ago

Customer reported:

Example dashboard variable from query: select clientname as text, clientid as value from CLIENT
Yields key:value pairs like GUS:001, PHREAD:003, … XXX:nnn
User sees GUS, PHREADE, … XXX (in dropdown selector and when the variable is referenced in panel titles)
Vertica query would reference 001, 003, …. Nnn
Your unsigned plugin supported this, but signed version errors with Error [22V02] invalid input syntax for integer: GUS – rather than use 001

bryanherger commented 2 years ago

Please see commit https://github.com/bryanherger/vertica-grafana-datasource/commit/7a374861932c4c94e87e2363f2ed94ed797c3349 for a way to fix this issue. I can submit a new PR after my previous is merged.

tanvipise commented 1 year ago

Thanks Bryan!

nicolaerosia commented 1 year ago

Is this fixed?

tanvipise commented 1 year ago

Yes, it is fixed.