Range selection
A query can search for records with a value that falls within a range of values. The format depends on whether the selection criterion is open-ended or it contains an upper and lower range.
The following sample query searches for purchase orders where the DEPARTMENT is greater than 1000.
<QueryMXPERSON>
<MXPERSONQuery>
<PERSON>
< DEPARTMENT operator=">=">1000</DEPARTMENT>
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>
The following sample query searches for person records where the PERSONID is greater than 1000 and less than 20000. The query uses two instances of a single field element, the first with the From selection criteria, and the second with the To selection criteria:
<QueryMXPERSON>
<MXPERSONQuery>
<PERSON>
< PERSONID operator=">=">1000</PERSONID >
< PERSONID operator="<=">20000</PERSONID >
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>