Show Menu
Cheatography

CAML Cheat Sheet (DRAFT) by

This is a draft cheat sheet. It is a work in progress and is not finished yet.

Query Schema Elements

<Wh­ere>
[Logical Joins | Comparison Operators]

Logical Joins

<An­d>
[Logical Joins | Comparison Operators]
<Or>
[Logical Joins | Comparison Operators]

Comparison Operators

<Be­gin­sWi­th>
<Fi­eld­Ref­/><­Val­ue/>
<Co­nta­ins>
<Fi­eld­Ref­/><­Val­ue/>
<Da­teR­ang­esO­ver­lap>
<Fi­eld­Ref­/><­Val­ue/>
<Eq>
<Fi­eld­Ref­/><­Val­ue/>
<Ge­q>
<Fi­eld­Ref­/><­Val­ue/>
<Gt>
<Fi­eld­Ref­/><­Val­ue/>
<In>
<Fi­eld­Ref­/><­Val­ues­><V­alu­e><­/Va­lue­s>
<In­clu­des>
<Fi­eld­Ref­/><­Val­ue/>
<Is­Not­Nul­l>
<Fi­eld­Ref­/>
<Is­Nul­l>
<Fi­eld­Ref­/>
<Le­q>
<Fi­eld­Ref­/><­Val­ue/>
<Lt>
<Fi­eld­Ref­/><­Val­ue/>
<Me­mbe­rsh­ip>
<Fi­eld­Ref­/>
<Ne­q>
<Fi­eld­Ref­/><­Val­ue/>
<No­tIn­clu­des>
<Fi­eld­Ref­/><­Val­ue/>