Rule Builders

A query is a request for data results, for action on data, or for both. You can use a query to search for specific items based on if the condition is met.

Where to find Query Builders

You can find query builders in several places in the Workbench. You can find a Query Builder in the Landing Pages Administration.

To navigate to a Query Builder in the Landing Pages:

1. Click on "Workbench"

2. On the Navigation Pane, click on Merchandising -> Landing Pages

3. Click the "Pencil" to edit a Landing Page and to view the Query Builder.
   
   
   
   

You can also find a Query Builder in "Boost & Bury Rules":

1. Click on "Workbench"

2. On the Navigation Pane, click on Merchandising -> Boost & Bury Rules

3. Click on "Add/Edit Conditional Rules"
   
   

   Open

   

Click on the "Pencil" to edit the Boost & Bury Rule.

Open

The "Select Items to Display" section contains a Query Builder.

1. Select "ANY" or "ALL". If "ANY" of the following conditions are met, Items will display according to any of the listed conditions. If "ALL" is selected, every listed condition has to be met, in order for Items to display.
   
   

2. When you click on the "Select Value" menu, a list of fields display. Select a field that you would like to include in the query.
   
   

3. Depending on the field type, the list of operands change. For text fields, the operands include:

   1. is – the query will include whatever text is in the field

   2. is not – the query will exclude the text in the field

   3. contains – Contains an exact or partial match of the text string within the field you selected for filtering.

   4. does not contain - Does not contain an exact or partial match of the text string within the field you selected for filtering.

   5. is in – Matches any value in a delimited set. NOTE: Separate values with a comma to specify a list.

   6. is not in - If the value of the specified field is not one of the specified values, it is true.
      
      

4. For numeric fields, the operands include:

   1. equals – matches the value in the condition

   2. does not equal – Does not match the value in the condition

   3. equals or greater than – Is larger than or equal to the value in the condition

   4. equals or less than – Is less than or equal to the value in the condition

   5. greater than – Is larger than the value in the condition

   6. less than – Is less than the value in the condition
      
      

5. Enter the value to compare to the field selected in Step 2
   
   

6. Click on the Calculate & Show Matches button to view the results of the query.