Spquery query syntax

The spquery query statement is displayed in XML format, as shown in the following example:

<Query>
<Orderby>
<Fieldref name = "modified" ascending = "false"> </fieldref>
</Orderby>
<Where>
<Or>
<NEQ>
<Fieldref name = "status"> </fieldref> // field name
<Value type = "text"> completed </value> // Field Value
</NEQ>
<Isnull>
<Fieldref name = "status"> </fieldref>
</Isnull>
</Or>
</Where>
</Query>

Now I will use the familiar SQL syntax to compare it.

Spquery	SQL
<Where> </where>	Where
<Orderby> </orderby>	Order
<And> </and>	And
<Or> </or>	Or
<EQ> </EQ>	=
<Geq> </geq>	> =
<GT> </GT>	>
<Leq> </Leq>	<=
<Lt> </LT>	<
<NEQ> </NEQ>	! =

Note:
The <and> condition can contain only two identical sub-elements, that is, one <and> can have at most two <EQ> sub-elements, however, <and> can contain another <and> sub-element. Therefore, when multiple <and> query conditions exist, we must use the <and> layer-by-layer method. Now I only use and, so I understand this, and others do not know if it is the same.

These commonly used items are listed here. For some special items, check the SDK.

Windows SharePoint Services SDK