Building Simple and Nested Criteria
The following example illustrates how to build simple and nested criteria.
Example: Viewing all Installed products that are considered as scrap so that they can be de-installed or appropriate cleanup activity can be carried out on them.
1. Create a new filter by clicking on the add icon (
) and give it a meaningful name.
) and give it a meaningful name.2. In the Expression Builder, right-click the default group (AND) and choose Add Condition.
3. Choose the Status field from the drop-list of all Installed Product fields.
4. Choose Equals as the operator.
5. Enter the value as Scrap.
6. Click Save to save changes.
The overall criteria expand to And(Status Equals 'Scrap'). It can be interpreted as Show only those IBs which have the Status field as Scrap. The screenshot below shows the expression tree.
Example: Viewing all the leased Installed products that are of the portable type. Such IBs are identified by their Product Family (has the word Portable or Movable) and their status (should be equal to Leased)
1. Create a new filter by clicking on the add icon () and give it a meaningful name.
) and give it a meaningful name.2. In the Expression Builder, create the required expressions as below:
For Status field
1. Right-click the default group (AND) and choose Add Condition.
2. Choose Equals as the operator.
3. Enter the value as 'Leased'.
For Product Family
1. Right-click the default group (AND) and choose Add Group > ORChoose the Product Family field from the drop-down list of all Installed Product fields.
2. Right-click on the newly created OR group and choose Add Condition.
3. Choose Contains as the operator.
4. Choose a value as Portable.
5. Repeat steps (iii) to (v) to create a similar expression but with value as Movable.
6. Click Save to save this filter
The overall criteria expand to And(Status Equals 'Leased', OR (Product Family Contains 'Portable', Product Family Contains 'Movable')). It can be interpreted as Show only those IBs which have the Status field as Leased AND has Product Family value containing either of the words 'Portable OR 'Movable'. The screenshot below shows the expression tree.
Reference Topics