Using the condition builder

You can use the condition builder.

1. From the menu bar, choose Applications > Catalog Management. The Catalog Management tree displays in the applications side panel.
2. From the Catalog Management tree, choose Products > Items. The Product Item Search window displays in the work area.
3. Click the Advanced Item Search icon. The Advanced Item Search window displays.
4. To create an item query, select a query entity. Click the query entity button for which you want to build a query. The condition builder popup window displays.
5. Select a statement. In the condition builder popup window, click on Choose Field and select the exact attribute you want as part of the query. For example, ItemID.
6. Select a query type and attribute value. In the drop down menu on the left, select the desired query type. In the field on the right, either select the desired attribute value from the drop down menu, or type the value if it is a text field. Click the Add button.
7. Repeat steps 5 and 6 until you have all of the statements you want in your condition. By default, the statements are connected together through an AND operator.
8. Optionally, edit statements by applying actions. If applicable, highlight the statement you want to edit and select the desired action. The following table describes the possible actions.

   Table 1. Statement actions

   Action	Description
   	Replace the highlighted statement. The Add button is replaced by a Replace button, and the statement can be selected again by going through Step 5.
   	Delete the highlighted statement.
   	Create a priority operator. For example, (A AND B) OR C as opposed to A AND (B OR C): The statements within the parenthesis are evaluated first.
   	Remove a priority operator.
   	Create a negation operator. For example, A AND NOT B.
   	Remove a negation operator. For example, A AND NOT B would become A AND B.
   	Replace an OR operator by an AND operator.
   	Replace an AND operator by an OR operator.

   Once the condition is built as desired, click OK.

   
9. Optionally, edit conditions by applying actions.
10. Repeat steps 4 through 8 until you have all the conditions you need for the query. By default, the conditions are connected together through an AND operator. If applicable, highlight the condition you want to edit and select the desired action located in the upper right-hand corner of the window. The following table describes the possible actions.

    Table 2. Condition actions

    Action	Description
    	Return to the condition builder popup window for that condition.
    	Delete the highlighted condition.
    	Replace an AND operator by an AND NOT operator.
    	Replace an AND NOT operator by an AND operator

    Once the condition is built, click the Search icon.

    

    Important: When building queries using the Alias, Additional Attribute, and Exclusion entities, it is important to build conditions in which all attributes for that particular entity go into the same condition and not into multiple conditions.