Filter collection based on variable value stored in data item

[agroenek]

Hi,

Is it possible to filter a collection based on a variable value stored in a data item? The data item is populated from given paremeters (1..6) on startup.
In below example the data item which holds the value is [filter_wet].

View attachment 1550573723327.png

 

[sivagelli]

Yes, it is possible, use "Wet = " & [Dataitem]

 

[agroenek]

Thanks, the given code resulted in an error:
View attachment 1550578298108.png

The value of the data item was taken for a column. The code put me on the right track though, the following code works like a charm:

View attachment 1550578392152.png

Thanks again

 

[sivagelli]

Yes! I should have mentioned it. You have to use single quotes around the data item of text type. If the data item is number, you can can write the query as i suggested above.