2.0.2

Enhancements:

• add alerts support for Windows and MacOSX
• improve ad-hoc filters for query field values as SELECT DISTINCT field AS value FROM db.table LIMIT 300, #222
• add the ability to multiple JOIN parsing #206
• multiple improvements for docker-compose environments, add automatic dashboards and data source provisions which help to reproduce most of the corner cases which happens in Grafana + ClickHouse

Fixes:

• apply a workaround for UTC timezone for Date and DateTime columns in grafana dashboards #117
• clear documentation about timestamp term for $from and $to #115
• fix AST parsing corner case in WHERE [test, 'test'] "," was skipped, fix ah-doc AST FROM recursive parsing #99
• fix corner cases for table functions parsing when Adhoc filter applied #130
• fix multiple grammar issues in README.md
• fix convert rules for Float, Decimal columns from Clickhouse to Grafana Table plugin #199
• fix corner cases when Grafana Template variable value represented as an array of strings #169
• fix AST parsing corner cases for $macroFunctions correct position for FROM statement #187

2.0.1

Fixes:

• fix golang alerts for $columns, $perSecond, $perSecondColumns macros #200

2.0.0

Enhancements:

• compatibility with grafana 7.x, please use environment variable GF_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=vertamedia-clickhouse-datasource or allow_loading_unsigned_plugins=vertamedia-clickhouse-datasource in plugins section of grafana.ini #192
• add grafana 7.x alerting support thanks to Brian Thai https://github.com/bmanth60
• add alias support to $perSecondColumns macro #193
• Support custom variable type and empty values for $conditionalTest macro #178
• add docker-compose.yaml to improve local development

Fixes:

• fix AST for corner case when quotes escaped inside quotes #123, #195
• fix #179, add "Extrapolation" checkbox to Query Editor

1.9.5

Fixes:

• Comments not supported by sql language parser #95

1.9.4

Fixes:

• Ad Hoc Filters small adjustments for numeric values
• UI optimizations within Metric builder

1.9.3

Fixes:

• Ad Hoc Filters improvments

1.9.2

Fixes:

• Compatibility fix to support grafana 6.4.x
• Ad Hoc Filters fix
• $conditionalTest ALL value option fix

v1.9.0

New features:

• Add macro conditionalTest (thx to @TH-HA) #122
• Add support for connect to Yandex.Cloud ClickHouse (thx to @negasus) #106

Fixes:

• Fix identifier back quoting when there is a function call
• Fix AST parser errors for quotes (thx to @Fiery-Fenix) #128
• Added default database to all requests from datasource options (thx to @Fiery-Fenix) #126
• Drop lodash fcn composition (thx to @simPod) #110
• Cleanup build (thx to @simPod) #112

v1.8.1

New features:

• Add timeFilterByColumn macro (thx to @simPod) #68

Fixes:

• add requestId to queries so that abandoned one are cancelled (thx to @nvartolomei)
• bug with parentheses in $unescape macros #90
• bug with treating string as numbers in table view #97

v1.8.0

New features:

• new $perSecond macros #78
• new $perSecondColumns macros see #80
• Date column is now optional #48

Fixes:

• extend queried timerange for queries with round option to provide a graph without gaps in the rightmost and leftmost points #84
• adhocs: check whether it is possibly to apply filters by comparing with parsed query or query builder settings #86