Forum Discussion
filter on multiple values using parameter, in the query editor
I have exactly the same question :manfrustrated:: how to use the WHOLE list as the filter?
I understand how to use the Paremeter list to filter on ONE value, but I'd like to use it to overcome a query Folding issue (filters and transformations are done on Server rather your laptop, so you odn't need to download 8M rows first..), by applying something like a "where IN" SQL statement to the filter/query.
Maybe the Paremeter is not the way to go here? The need to limit a set of results based on "return only the following few items from the big database" seems like a fairly basic requirement; I do it in SQL all the time using [where xx IN ('abc', 'abd', etc)].
Did you find a solution to this?
It seems odd that you can provided a list of values to use as a parameter but you can only select (manually) one at a time and not load up all of the list.
Please tell me I am missing something obvious on how to use the "List of values" option.
Thanks
Hello,
no i have not found any solution to date.