- Comments not supported by sql language parser #95
- Ad Hoc Filters small adjustments for numeric values
- UI optimizations within Metric builder
- Ad Hoc Filters improvements for complex usage
- Compatibility fix to support grafana 6.4.x
- Ad Hoc Filters fix
- $conditionalTest ALL value option fix
- Add macro
conditionalTest
(thx to @TH-HA) #122 - Add support for connect to Yandex.Cloud ClickHouse (thx to @negasus) #106
- 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
- Add
timeFilterByColumn
macro (thx to @simPod) #68
- 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
- new $perSecond and $perSecondColumns macros (thx to @simPod) #78 #80
- Date column is now optional #48
- 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
- provide $adhoc macros for using ad-hoc filters in inner queries (thx to @vavrusa)
- allow to set custom query for ad-hoc filter via
adhoc_query_filter
variable - provide new
Round
value$step
for auto-rounding according to graph resolution changes
- annotations support (txh to @atsirin)
- allow to use
$from
and$to
macroses in variable queries - provisioning config example in README
- optimize memory use for range time series (thx to @vavrusa)
- apply ad-hoc filters on inner subqueries (thx to @vavrusa)
- new datasource setting -
default database
. If set it will be prefilled in the query builder, and used to make ad-hoc filters more convenient (thx to @vavrusa) - support wildcard ad-hoc filters for dashboards using multiple tables (thx to @vavrusa)
- parse dimensions from GROUP BY to simplify querying (see piechart and worldmap examples) (thx to @vavrusa)
$timeCol
to$dateCol
renamed to be more clear with column types (thx to @simPod)
- fix broken AST when using nested
SELECT
withoutFROM
statement (#45) - strict statement matching (#44)
- rebuild queries from AST only if adhoc filters were applied
- support
UNION ALL
statements - proper format for
LIMIT N,M
construction (thx to @shankerwangmiao) - update
Show Help
section with $unescape description
- $unescape - unescapes variable value by removing single quotes. Used for multiple-value string variables: "SELECT $unescape($column) FROM requests WHERE $unescape($column) = 5"
- labmda-operator
->
no more breaks while reformatting query
Ad-hoc filters support:
- If there is an Ad-hoc variable, plugin will fetch all columns of all tables of all databases (except system database) as tags.
So in dropdown menu will be options like
database.table.column
- If there are ENUM columns, plugin will fetch their options and use them as tag values
- Plugin will apply Ad-hoc filters to all queries on the dashboard if their settings
$database
and$table
are the same as Ad-hoc'sdatabase.table
- There are no option to apply OR operator for multiple Ad-hoc filters - see grafana/grafana#10918
- There are no option to use IN operator for Ad-hoc filters due to Grafana limitations
- support array indexing int AST
- columns autocompletion in ace-editor
- properly format query with reserved names
- fix #31
- allow rounding with
round
option both time filters: $from and $to
- apply proper value formatting for table format
- commit generated files
- fix error with absent
getCollapsedText
#24 - suppress errors while parsing AST #24
- show generated SQL in textarea #24
- do not round timestamp after converting #25
- increase max-height of query editor
- Ace editor
- ClickHouse function completion (thx to https://github.com/smi2/tabix.ui)