Collection Manipulation - Filter Collection

[JordanGreen]

Just a quick question to anyone who has used the Filter Collection object, which is part of the standard Collection Manipulation Utility.   How does the syntax for the filter Input work. I have tried to just send variable, as the aim is to get all rows that contain this variable into a separate collection without tampering with the original collection and filtering seemed like an good solution, but without knowing how I filter, it's a bit of a non-starter.   Any help very much appreciated.   Thanks, Jordan Green

[Anonymous]

harjyot.malik, as John already noted in the second post, you can use logical operators. Yours would be: ""fund = 'ABC' OR fund = 'XYZ'"" Tested and worked. PS: I don't see why you would want to use the & to concatenate a String (only if you want to use data-items)

[Milena_Martinel]

Hi, does anyone knows if you can user lower and upper case in the query?

[Prem_kumarR]

Can we filter all the distinct values in a column ?