IBM BJ0NJML - Service And Asset Management - Field Selection

Object Structure Element
246
Integration Guide
For example, to find all employees that have an ACTIVE status, format the query
as follows:
<QueryMXPERSON>
<MXPERSONQuery>
<PERSON>
<STATUS operator ="=">ACTIVE</STATUS>
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>
Field Selection
A field-based query compares the value in a database field with the value in the
XML field of the query request.
For example, the following query searches for employees:
<QueryMXPERSON>
<MXPERSONQuery>
<PERSON>
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>
The following query searches for employees where PERSONID is equal to ATI
and STATUS is equal to ACTIVE.
<QueryMXPERSON>
<MXPERSONQuery>
<PERSON>
<PERSONID operator ="=">ATI</PERSONID>
<STATUS operator ="=">ACTIVE</STATUS>
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>
The operandMode attribute of the MXPERSONQuery element defines the
statement that is run with an AND or an OR condition between the field
evaluations. The default condition that is used by the system is the AND
condition.
The following query searches for employees where PERSONID is like %ATI%.
The operand represents the default behavior and requires no operator value.
<QueryMXPERSON>
<MXPERSONQuery>
<PERSON>
<PERSONID>ATI</PERSONID>
</PERSON>
</MXPERSONQuery>
</QueryMXPERSON>