58 Administrator’s Guide
BMC Atrium Integration Engine 7.1.00
Value option in the query syntax (<value>)
This is a special syntax for data key queries. You can use any syntax in Table 3-13
for the Value option within the query syntax.
KEY syntax ($KEY$)
This is a special syntax for data key queries. It enables you to automatically include
the correct syntax for a multiple or single column key. It is especially useful when
trying to specify a query for all keys in a key list.
NOTE
$KEY$ is a keyword that is usually supported by any adapter.
An example is defined in Table 3-14.
KEYLIST
This is a special syntax for data key queries. If this syntax is entered for an
AR System query, it requests a list of data values from the external data store for
the key fields that are defined on the Primary Key Mapping tab of the respective
mapping console for AR, CMDB and Relationship data exchange.
It generates a query that returns all requests from an AR System form where the
AR System data keys for this data mapping exist in the key list obtained from the
External data store. The External data store list is either all key values in the third-
party data store or a subset of keys based on the query defined in the External Data
Store Query field on the Data Key Query sub tab of the Query tab on the Mapping
Information window.
NOTE
$KEYLIST$ is a keyword that is usually supported by any adapter.
Table 3-13: Value option in the query syntax
Syntax Description
$function|$
Performs the function that follows the pipe to
obtain a value. The value is placed in the query
before it is used to limit the data used in the data
exchange.
$KEYLIST$
Indicates that all keys from the target database
are to be placed in the query before it is used to
limit the data in the data exchange.
$KEYLIST$ is usually supported by any adapter.
xxxxxxx
Any other value is treated as a constant and
passed to AR System server for handling.
Table 3-14: KEY syntax example
Example Result
$KEY$ = $KEYLIST$ $<keyfield1>$ = key1 AND
$<keyfield2>$ = key2
