Configuring Logic to Evaluate Effectivity Expressions for Effectivity Resolution

A Part BOM Item can have several Effectivity Expressions.

Figure 54.

By default, multiple Effectivity Expressions on a Part BOM Relationship Item are evaluated using the OR conditional operator for the Effectivity Resolution: A given Part BOM is effective against Effectivity Criteria if at least one of its Effectivity Expressions evaluates to true for the selected Effectivity Scope.

It is possible to change the evaluation logic to use the AND conditional operator: A given Part BOM is effective against Effectivity Criteria if all of its Effectivity Expressions evaluate to true for the selected Effectivity Scope.

The evaluation logic is configured in the Where Condition of the top Part BOM item in the effs_effectivityResolutionOnPartBom QD.

This section describes the configuration specifications of this Query Definition for both evaluation logic.

Note: It is recommended to use only the “Count()” aggreagate function for Effectivity relationships to prevent performance degradation.

Specification of the AND Evaluation Logic

For the AND evaluation logic, the Where Condition of the top Part BOM item of the effs_effectivityResolutionOnPartBom Query Definition is configured as follows:

Count(effs_Part_BOM_expression) = Count(effs_Part_BOM_expr_no_resolve)

Figure 55.

Specification of the OR (Default) Evaluation Logic

For the OR (default) evaluation logic, the Where Condition of the top Part BOM item of the effs_effectivityResolutionOnPartBom Query Definition is configured as follows:

(Count(effs_Part_BOM_expr_no_resolve) = 0) OR (Count(effs_Part_BOM_expression) > 0)

Figure 56.