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

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

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?

Any help @Joe_Fleming @Catherine_Liu

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.