topic Re: dynamic filter in WHERE statement in Dashboards & Visualizations

dynamic filter in WHERE statement

alessj — Thu, 30 Jan 2020 14:06:29 GMT

Hello,

I would like to use a dynamic filter. I have a dropdown($pool$) which select only one value from a list. I want to add a static value "all" that take all the values in the list.

How should i modify the code ? Adding an IF statement with the WHERE ?

Thanks you

Re: dynamic filter in WHERE statement

skoelpin — Thu, 30 Jan 2020 18:38:24 GMT

Have you tried changing where to search?

Re: dynamic filter in WHERE statement

wmyersas — Thu, 30 Jan 2020 20:00:36 GMT

First, as @skoelpin suggested, change from where to search

Second, create a static drop-down option named "All" with a value of "*"

Then when the | search poolname="$pool$" date>="$time$" runs, if you've selected "All" for the $pool$ dropdown, it will fill-in | search poolname="*" date>="$time$"

Re: dynamic filter in WHERE statement

alessj — Fri, 31 Jan 2020 09:39:16 GMT

i wasn't aware of search function

Re: dynamic filter in WHERE statement

skoelpin — Fri, 31 Jan 2020 14:53:10 GMT

where is used to compare fields and search is used to compare a field to a value. You can only evaluate one function with the where. You can do multiple with a search

Your token is rendered a value before getting passed to that search filter so you are comparing a field to a value.

Re: dynamic filter in WHERE statement

wmyersas — Fri, 31 Jan 2020 18:42:37 GMT

Now you are =D

Re: dynamic filter in WHERE statement

wmyersas — Fri, 31 Jan 2020 18:44:13 GMT

where is used to compare fields and search is used to compare a field to a value. You can only evaluate one function with the where. You can do multiple with a search

That's not true. You can use multiple conditions in a where clause. You can do | where like(field,"%value%") AND field2<$token$ AND match(field3,"<regex>")...