Field
|
field
|
The name of the field to be included in the query block. On the Configuration
Editor, you can click Browse to select a field or enter the fully qualified
field name manually.
|
Source
|
source
|
The name of the source field in the object from which the criteria is
obtained. Click Browse to select a field, or enter the qualified field name
manually. An asterisk (*) can be used as a wildcard character.
Tip –
When a field in a child object is defined for a blocking query,
use the asterisk wildcard character in the ePath to the source field to ensure
all instances of the child object in an incoming message are used as search
criteria. Each instance is joined by an OR operator. For example, this configuration:
<field>Enterprise.SystemSBR.Person.Name.FirstName
</field>
<source>Person.Name[*].FirstName</source>
|
would result in a WHERE clause similar to this:
WHERE
Name.FirstName=”Meg” OR Name.FirstName=”Maggie”
|
Operator
|
type of search
|
An indicator of the type of search to perform on the field. On the Configuration
Editor, you can select one of the following values from the drop-down list.
In the XML file, you specify one of the following names for the XML element
that defines one field in a query block.
-
equals -
Performs an exact search against either the criteria or the value defined
for the “Use Constants” option.
-
not-equals - Searches for
values that do not equal either the criteria or the value defined for the “Use
Constants” option.
-
greater-than-or-equal -
Performs a search for values that are greater than or equal to either the
criteria or the value defined for the “Use Constants” option.
-
less-than-or-equal - Performs
a search for values that are less than or equal to either the criteria or
the value defined for the “Use Constants” option.
-
range - Performs a search against a range of either
static or user-defined ranges. If you select this option, you must specify
upper and lower bounds.
Tip –
If a field is to be used for simple range searching (where the
user or incoming message supplies lower and upper limits of the range are
supplied) be sure to define that field for range searching in midm.xml for the
searches that use this query. For more complex range searches that use offset
values or constants instead of user-supplied limits, do not define the field
for range searching in midm.xml.
|
Use Constant/Value
|
constant
|
On the Configuration Editor, this is an indicator of whether to use
a constant value as the search criteria for the field. When this option is
selected, you need to enter the constant in the corresponding Value field.
In the XML file, enter the value of the constant in the constant element.
|
Upper Bound
Type
|
upper-bound/type
|
For range searching only, the type of value to use for the upper limit
of the search range. Select or enter one of the following options.
-
not defined - No specific upper limit is defined;
a user enters the value when performing the search. Be sure to define this
field for range searching in the MIDM as well. In the XML file, this
is indicated by omitting the upper-bound element.
-
constant - A specific value is defined to use as
the upper limit of the range when no search criteria is entered or when incomplete
information is available.
-
offset - A value to be added to the user-supplied
value to determine the upper limit on the search range.
For constant
and offset, enter the value in the corresponding Value field.
|
Lower Bound
Type
|
lower-bound/type
|
For range searching only, the type of value to use for the lower limit
of the search range. Select one of the options listed for Upper Bound Type.
If you select offset, the value you specify for the offset will be subtracted
from the user-supplied value.
|
Value (for the upper
and lower bounds)
|
upper-bound
lower-bound
|
For constant and offset range searching, the upper or lower limit of
the range. For constants, this is the upper or lower limit; for offsets, this
is the value added to or subtracted from the user-supplied value. It can be
numeric, date, or string. In the XML file, the upper-bound and lower-bound elements fall within an element named default.
|