Export (0) Print
Expand All

Gt Element (Query)

Arithmetic operator that means "greater than." This element is used similarly to the Eq and Lt elements.


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

Attribute

Description

None

N/A

Minimum: 0

Maximum: Unbounded

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

The following example queries for cases where the Deadline field value either equals an empty string or is later than the current date.

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

Community Additions

ADD
Show:
© 2014 Microsoft