Rule Set Look-Up Method

The Rule Set Look-Up method looks up the rules for each input rule set and tests the rules against the row set. Then it performs actions if the rule set passes or fails. For example, it could be used for identifying applicable bundles or promotions.

Arguments

Input Argument	Description
Context	Optional. Property set of variables shared across all rows.
Row Set	The set of rows to process.
Output Row Set	Optional. The property set used for output.
Process Condition	A Boolean condition that is evaluated to determine whether to process each row.
Business Object	The business object to query to retrieve the rules.
Business Component	The business component to query to retrieve the rules.
Search Specification	A search expression comprised of business component fields, literals, and variable values from {Context} and {Row}. For example: `[Required Flag] = 'Y'`
In Memory Search Specification	Optional. Additional terms that are ANDed with the Search Specification. The In Memory Search Specification is executed in memory. This can be used only if Cache Enabled is Y.
Cache Search Specification	Optional. Additional terms that define the key values for the Level 1 cache; for example: `[Price List Id] = {Row.Price List Id})` For more information, see Logging of Performance.
Sort Specification	Optional. A comma-separated list of business component fields used to sort the query result.
Cache Enabled	Optional. Specifies whether to cache query results. Y or N. The default is N.
Rule Set Field	The field in the business component that groups the rules into a rule set (example: Promotion Id, Bundle Id).
Row Join Field	The field in the {Row} that is joined to a matching rule (example: Product Id). This transform tests all rows that join to see if the rule expression is satisfied.
Rule Join Field	The field in the rule business component that is joined to a matching {Row} (example: Product Id).
Rule Expression	Optional. A Boolean expression that defines whether a rule is satisfied by a row; for example: `"{Match.Min Qty} = 0)` OR `{Match.Min Qty} <= {Row.Qty}")`
Pass Only If All Rules Match	Y or N. This indicates whether to execute the On Pass … conditions only if all rules in a rule set pass, or whether to execute those conditions for any rule that is satisfied.
Row Set Sort Specification	Optional. A comma-separated list of {Row} field names that determine the sequence in which rows in {Row Set} are processed as they are compared with the rules. This transform is used to make sure that the highest value item is given away in a buy-one-get-one-free scenario. This transform is required for backward compatibility.
Rule Sets	A property set containing a list of rule sets to test. Each child property set can contain the following fields: [Rule Set Sequence Id] (optional) [Sequence] (optional) A value for the "Rule Set Field" (example: [Bundle Id]) [Next Sequence on Fail] (optional) For example, the list of promotions that requires integrity checking or the list of bundles associated with the current price list. If the [Next Sequence on Pass] field is populated, then the Rule Sets transform skips to that value of [Sequence] if the current rule set passes. If the [Next Sequence on Fail] field is populated, then the transform skips to that value of [Sequence] if the current rule set fails. Note: There may be multiple sequences of rule sets in the Rule Sets property set. Individual rule-set sequences are identified by the optional [Rule Set Sequence Id] field. Attributes of the rule set being evaluated are exposed to action syntax as {Rule Set.Value}.
On Pass First Match	Occurs for the first row in the row set that matches a rule in a rule set for which the evaluation criteria are satisfied. For 'On Pass … [Rule]' conditions, {Row} and {Match} variables are available to actions.
On Pass Match	Occurs for every row in the row set that matches a rule in a rule set for which the evaluation criteria are satisfied. For 'On Pass … [Rule]' conditions, {Row} and {Match} variables are available to actions.
On Pass Last Match	Occurs for the last row in the row set that matches a rule in a rule set for which the evaluation criteria are satisfied. For 'On Pass … [Rule]' conditions, {Row} and {Match} variables are available to actions.
On Fail First Rule	Occurs for the first rule not satisfied in a failed rule set. Note: For On Fail … [Rule] conditions, only the {Match} variable is available to actions.
On Fail Rule	Occurs for each rule that was not satisfied in a failed rule set.
On Fail Last Rule	Occurs for the last rule that was not satisfied in a failed rule set.

Example

The following figure shows an example of arguments for a PSP procedure step named Identify Applicable Bundles, which uses the Rule Set Look-Up method.