multi Filter in collections

[PeterLíška]

Dear friends, I have a problem. I want to filter more items in one column. I used action "Filtr Collection". I choosed column but I simply dont know how to write a code to filter more items under one column. I want to Filter "USA" "China" and "Italy" See uploaded excel sheet. Can you help me?

[John__Carter]

Try something like this [Country] IN {'USA', 'China', 'Italy'}

[RekhaMurari]

This didn't work, is there anything like ""[Country] = '""&[USA]&""' Or '""&[China]&""'

[RekhaR]

I tried this ""[Country] = '""&[USA]&""' Or '""&[Italy]&""'"", this is not throwing any error , but the output collection is still empty the expression is evaluating to  USA Or Italy

[NikhilSaini]

Hi, I tried all above syntex but no one is working. Could any one help with correct syntex for multiple selection in filter.

[Denis__Dennehy]

Looking at the code stage in the VBO I can see it is using the datarow.select .NET function.  My recommendation would be to do some simple internet searching to find out what is possible and how to use that .NET function.

[Hitesh__Mhatre]

Try ""[Country] IN ('USA', 'China', 'Italy')""   This works for me.

[NikhilSaini]

We aThanks Dennis. We looked for syntax and after some hit and trial, below one is workign for us. ""[Country] = 'USA' or [Country] = 'Italy'""