0

I want to create a list view inside sharepoint on-premises team site. the list view need to show items which are under any of the 18 customers + that are not Expired..

so i wrote the following CAML query :-

<Where>
<And>
<Or>
<Or>
<Or>
<Or>
<Or>
<Or>
<Or>
<Or>
<Or>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">A**</Value></Eq>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">C***s</Value></Eq>
</Or>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">G***h</Value></Eq>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">C***d</Value></Eq>
</Or>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">i**</Value></Eq>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">C**P</Value></Eq>
</Or>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">Q*</Value></Eq>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">g**</Value></Eq>
</Or>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">S**d</Value></Eq>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">C**d</Value></Eq>
</Or>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">S***</Value></Eq>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">J***o</Value></Eq>
</Or>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">T***e</Value></Eq>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">K**d</Value></Eq>
</Or>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">T***p</Value></Eq>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">L****ts</Value></Eq>
</Or>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">TA***p</Value></Eq>
<Eq><FieldRef Name="CustomerName"/><Value Type="Text">LE**ts</Value></Eq>
</Or>
<Neq><FieldRef Name="Expired"/><Value Type="Text">Yes</Value></Neq>
</And>
</Where>

and i edit my list view using sharepoint designer,and i added the above CAML query after i removed all the white spaces and extra lines from the CAML query.

but when i access the list view inside my sharepoint site, i got an error "undefined error"...so not sure why ? although my above CAML query is valid.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.