I am trying to build a CAML query to add to 'Content Structure and Reports' where users can check all PDF documents that do not have anything in the "TRIMReference" field.
<Where><AND><IsNull><FieldRef Name="TrimReference" /></IsNull><Eq><FieldRef Name="File_x0020_Type"/><Value Type="Text">pdf</Value></Eq></AND></Where>
but it doesn't return anything.
I know that the following works (i.e. returns everything with nothing in the TrimReference field) but I just can't seem to work out how to only return PDFs with nothing in the TrimReference field.
<Where><IsNull><FieldRef Name="TrimReference" /></IsNull></Where>
Any help would be hugely appreciated.
This should work by replacing
'AND' with 'And' (CAML is Case Sensitive!)