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="&gt;=">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="&gt;=">1000</PERSONID >
< PERSONID operator="&lt;=">20000</PERSONID >
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>