The CAML query below didn't work for me. Any help?
$viewQuery = "<Where><And><Eq><FieldRef Name='PP'/><Value Type='Integer'><UserID Type='Integer'/></Value></Eq><And><Eq><FieldRef Name='Org' /><Value Type='Choice'>Rules</Value></Eq><Eq><FieldRef Name='Completed' /><Value Type='Boolean'>0</Value></Eq></And><And><Geq><FieldRef Name='Created' /><Value IncludeTimeValue='FALSE' Type='DateTime'>$FDate</Value></Geq><Leq><FieldRef Name='Created' /><Value IncludeTimeValue='FALSE' Type='DateTime'>$ToDate</Value></Leq></And></And></Where>";
The above query works fine if I remove the first condition. when I add the fifth 'And' condition it is throwing error.
PS: I cant install a CAML query builder.