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)?