Filter multiple values in script

[Anonymous]

Hi All,

I am looking filter multiple values in script, i tried using Where [Employment Status]='Permanent' and 'Contract'

Where [Employment Status]='Permanent'and  [Employment Status]='Contract'

Where [Employment Status] in (Permanent','Contract')

Where match( [Employment Status] , Permanent','Contract')

what will be the correct syntax?

Thanks,

Krishna

[Kushal_Chawda]

Where match( [Employment Status] , 'Permanent','Contract')

Filter values are case sensitive so make sure that Filter Values matching with actual data

[MK_QSL · Accepted solution]

Where Match(FieldName,'FirstValue', 'SecondValue', 'ThirdValue');

[Kushal_Chawda]

krishna4bo‌  was that not working which I have suggested?

[MK_QSL]

krishna4bo‌ You should have marked kush141087‌'s answer correct and my answer as helpful. He has replied before me.