Grafana：表格，下拉菜单，映射

映射

这个问题真的是找了一点时间，感觉百度搜不出来，bing也搜不出来，github、官网文档也搜不出来。
深刻总结：我已经不会搜索了。。。

key/value pairs

SELECT 'txt1' AS __text, 'value1' AS __value UNION SELECT 'txt2' AS __text, 'value2' AS __value

省略

case when len(a.content)>30 then SUBSTRING(replace(a.content, ' ', ''),0,30)+'...' else replace(a.content, ' ', '') end

参考：

• https://community.grafana.com/t/key-value-style-for-custom-template-variable-configuration-and-usage/3109/11
• https://stackoverflow.com/questions/53880113/how-to-nest-variables-in-grafana