IBM BJ0NJML - Service And Asset Management - Range Selection

Object Structure Element
Integration Queries 247
The following query searches for the inventory balances where the bin number is
not null.
<QueryMXINVBAL>
<MXINVBALQuery>
<INVBALANCES>
<BINNUM operator =”!="></BINNUM>
</INVBALANCES >
</MXINVBALQuery>
</QueryMXINVBAL>
The following query searches for the inventory balances where the bin number is
null.
<MXINVBAL>
<INVBALANCES>
<BINNUM>NULL</BINNUM>
</INVBALANCES >
</MXINVBAL>
The following query uses the equivalent of a SQL IN clause to search for the
employees whose status is ACTIVE or INACTIVE.
<QueryMXPERSON>
<MXPERSONQuery>
<PERSON>
<STATUS>ACTIVE,INACTIVE</STATUS>
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>
The following query searches for the employees where the Person ID starts with
the letter A.
<QueryMXPERSON>
<MXPERSONQuery>
<PERSON>
<PERSONID operator ="SW">A</PERSONID>
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>
The following query searches for the employees where the Person ID ends with
the letter Z.
<QueryMXPERSON>
<MXPERSONQuery>
<PERSON>
<PERSONID operator ="EW">Z</PERSONID>
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>
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.