Canvas : Need to parse the values of 2 filters to the essql

Elastic Stack Kibana
1

The filter values needs to be parsed to the sql

Example:

  SELECT url , version, COUNT(*) AS K FROM "table_*"  WHERE version='9.0.3.9' or version='9.0.3.10' GROUP BY url, version HAVING 
    K <2 ORDER BY url
     DESC

==============================
essql

SELECT url , version, COUNT(*) AS K FROM "table_*"  WHERE version='$**version**' or version='$**version**' GROUP BY url, version HAVING 
K <2 ORDER BY url
 DESC

@Catherine_Liu

image
image.png1268×285 18.6 KB

2

Adding two dropdown filters will automatically filter your essql but with an AND between those filters.

@Catherine_Liu or @Joe_Fleming knows better if we can we "disable" that filtering behaviour and use the filter values inside the essql expression?

3

Any help @Joe_Fleming @Catherine_Liu

4

I left a reply here that I think applies to this question as well: Canvas : is it possible to send varaibles to esql, edocs query argument or is it a limitation in canvas