handling NULL values in Query-based variable PostgreSQL query 變數空值處理 WHERE "my_field" IN (${my_variable}) 當變數出現空值時 Templating Template variables could not be initialized: pq: syntax error at or near ")" 變數格式改用 pipe WHERE "my_field" ~ ('${my_variable:pipe}') 解決~ key/value pairs as template variables on grafana 寫法 SELECT hostname AS __text, id AS __value FROM host https://grafana.com/docs/grafana/latest/datasources/postgres/ LDAP - Active Directory server setup 公司環境再設定綁定不希望設定檔上出現帳密 調整設定如下: [註:]內部Ldap 查詢功能會不能使用 bind_dn = "CORP\\%s" # or "%s@corp.local" search_filter = "(sAMAccountName=%s)" search_base_dns = ["dc=corp,dc=local"] # 註解group mappings # [[servers.group_mappings]] https://grafana.com/docs/grafana/latest/auth/ldap/