I have a query that I've written like this:
<Where> <Or> <Neq><FieldRef Name='Status'></FieldRef><Value Type='Text'>Created</Neq> <Neq><FieldRef Name='Status'></FieldRef><Value Type='Text'>Updated</Neq> </Or> </Where>
Just 1 Neq works (outside of an OR) - but when I do both in an OR - I'm getting back more results than I would expect and some where status is "Updated" (as per value above).
What I am trying to do is:
Get all items where status is not Created or Updated.
Is my logic correct? Is my CAML correct? Thanks in advance!