This section explains condition expressions that compare master data items and keywords.
The lookup functions below are provided for returning master data item contents.
Refer to "2.8.4 Lookup Functions" for details.
There are two types of functions: those that specify two arguments and those that specify three arguments.
If two arguments are specified, master item existence (true/false) is returned.
If three arguments are specified, master item contents are returned.
Returns the sum of the master item contents.
Returns the number of master items existing (count).
The sections below explain condition expressions in which these lookup functions are specified.
Complex conditions in relation to master items joined by lookup(), such as searches for partial matches and word searches, can be described for searches.
The format used for pattern search is shown below.
Refer to "2.8.4.1 lookup() Function" for information on the lookup() function specified on the left side.
The keyword specified on the right side (a pattern search type) is similar to keyword search. Refer to "2.5.5.1 Pattern Search" for details.
Point
The handling of upper-case and lower-case single-byte alphabets in search target strings can be specified by the rule definition (ANKmix option). The handling of upper-case and lower-case double-byte alphabets can be specified by the rule definition (KNJmix option).
If a pattern (string) is used for a searching, characters to be excluded as search targets can be specified in rule definitions (SkipChar option). Refer to "2.5.5.1.1 Pattern search (string)" for details.
If a pattern (word) is used for a search, the word delimiter character can be specified in the rule definitions (SeparateChar option). Refer to "2.5.5.1.2 Pattern search (word)" for details.
Refer to "2.9 Options" for details.
String search searches master items joined by lookup() for events which are a complete match with the value specified in the string or for events in a size relationship.
The format used for string search is shown below.
Refer to "2.8.4.1 lookup() Function" for information on the lookup() function specified on the left side.
The keyword specified on the right side (string) is similar to keyword search. Refer to "2.5.5.2 String Search" for details.
Point
Characters to be excluded as search targets can be specified in rule definitions (SkipChar option).
The handling of upper-case and lower-case single-byte alphabets in search target strings can be specified by the rule definition (ANKmix option). The handling of upper-case and lower-case double-byte alphabets can be specified by the rule definition (KNJmix option).
Refer to "2.9 Options" for details.
Numeric search searches master items joined by lookup() for events which match the specified numeric value or for events in a size relationship.
The format used for numeric search is shown below.
Refer to "2.8.4.1 lookup() Function" for information on the lookup() function specified on the left side.
The keyword specified on the right side (numeric) is similar to keyword search. Refer to "2.5.5.3 Numeric Search" for details.
Evaluates the existence of master data joined by lookup().
The format used for master data search is shown below.
Refer to "2.8.4.1 lookup() Function" for information on the lookup() function specified on the left side.
A true() function or a false() function is specified in the keyword specified on the right side. Refer to "2.8.5 Boolean Functions" for information on the format of these functions.
Searches the sum of master items joined by lookup_sum() for events which match the specified numeric or for events in a size relationship.
The format used for lookup sum matching is shown below.
Refer to "2.8.4.2 lookup_sum() Function" for information on the lookup_sum() function specified on the left side.
The keyword specified on the right side (numeric) is similar to keyword search. Refer to "2.5.5.3 Numeric Search" for details.
Searches the count for master items joined by lookup_count() for events which match the specified numeric or for events in a size relationship.
The format used for lookup count matching is shown below.
Refer to "2.8.4.3 lookup_count() Function" for information on the lookup_count() function specified on the left side.
The keyword specified on the right side (numeric) is similar to keyword search. Refer to "2.5.5.3 Numeric Search" for details.
