filterCAML converted to filterREST

[MikeS]

Alexander,

I’d like to transition a CAML filter to a filterREST (for speed reasons) but am having problems with the syntax.

CAML example of multiple OR statements:

<Where><In><FieldRef Name='Field1'/><Values><Value Type = 'Text'>Draft</Value><Value Type = 'Text'>In Work</Value><Value Type = 'Text'>Completed</Value></Values><In></Where>

How could that be expressed as a filterREST statement while also adding an AND to the three OR statements? For example, if Field2 = “No” AND (Field 1 = Draft OR Field 1 = In Work OR Field 1 = Completed)?

Thanks for your help.
MikeS

[Alexander Bautz]

Try it like this:

Field2 eq 'No' and (Field1 eq 'Draft' or Field1 eq 'In Work' or Field1 eq 'Completed')

If Field2 is boolean you must write it like this:

Field2 eq 0 and (Field1 eq 'Draft' or Field1 eq 'In Work' or Field1 eq 'Completed')

Alexander

[MikeS]

Works great. Thanks!

MikeS

[Author]

Posts