This topic has not yet been rated - Rate this topic

Geq Element (Query)

SharePoint 2010

Other Versions

Windows SharePoint Services 3

Published: May 2010

Arithmetic operator that means "greater than or equal to." This element can be used within a Where element in a query.

Copy


<Geq>
  <FieldRef Name = "Field_Name"/>
  <Value Type = "Field_Type"/>
  <XML />
</Geq>

Attributes

Attribute	Description
None	N/A

And, Or, Where

Minimum: 0

Maximum: Unbounded

Remarks

Remember that Collaborative Application Markup Language (CAML) is case-sensitive; note the lowercase "eq" in the Geq element name.

Example

The following example queries for cases where the Expires field value either equals an empty string or is greater than or equal to the current date:

XML

Copy

<Query>
  <Where>
    <Or>
      <IsNull>
        <FieldRef Name="Expires" />
      </IsNull>
      <Geq>
        <FieldRef Name="Expires" />
        <Value Type="DateTime">
          <Today />
        </Value>
      </Geq>
    </Or>
  </Where>
  <OrderBy>
    <FieldRef Name="Modified" Ascending="FALSE" />
  </OrderBy>
</Query>

Reference

Eq Element (Query)

Gt Element (Query)

Lt Element (Query)

Neq Element (Query)

Change History

Date	Description	Reason
May 2010	Initial publication

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ