Design conditions for WHERE clauses

A WHERE clause is used to set up a filter condition on the selected columns to return only those records that meet a specified condition.

You can create a WHERE clause in the SELECT, INSERT INTO, and UPDATE statements and work with them on the Where tab of Tabbed Editor. The editor displays the clause as a tree structure with individual conditions and condition groups. Each group can contain multiple conditions or nested groups, combined using logical operators.

Open Tabbed Editor

To open Tabbed Editor, do one of the following:

  • In the top menu, select Query > Show Tabbed Editor.

  • On the Query toolbar, click Show Tabbed Editor.

Add a WHERE clause

1. To add a filter condition, click Add a new condition, select the upper-level group operator, then select Add Condition.

2. Choose a logical operator to define how multiple conditions are combined:

  • AND – Returns records when all conditions are true.
  • OR – Returns records when at least one condition is true.
  • NOT (AND/OR) – Reverses the logic of the specified condition group.

3. Click the enter a value placeholder and choose the column.

4. Click the current operator (default: =) and choose the filter operator for the condition (for example, =, <, <>) from the list.

5. Click the enter a value placeholder and enter the value for the condition.

WHERE clause template

6. To preview the query, select Text in the bottom panel of the Query Builder document.

Work with WHERE conditions and condition groups

You can create, modify, or remove groups and conditions in the WHERE clause.

Add a condition group to the row

1. Open the group template by doing one of the following:

  • Click Add a new group .

  • Click a logical group operator and select Add Group.

  • Press Ctrl+Plus Sign.

2. Click the enter a value placeholder and choose the column to filter.

3. Click the condition criteria operator to choose the required criteria operator from the list.

4. Optional: Enter a value if the operator requires one.

5. Optional: To preview the query, select Text in the bottom panel of the Query Builder document.

Remove a condition

To remove a condition, do one of the following:

  • Click Remove condition for the condition you want to remove.

  • Select the condition and press Delete or Minus Sign.

Remove a group

To remove a group, do one of the following:

  • Click Remove condition for the group you want to remove.

  • Select its logical operator and select Remove Group.

  • Select the group and press Delete or Minus Sign.

To remove all conditions and groups, select the upper-level operator and select Clear All.

You can also copy, cut, and paste conditions and groups using Ctrl+C, Ctrl+X, and Ctrl+V.

Navigate between conditions and condition groups

To navigate between conditions and condition groups, do the following:

  • Use Up Arrow, Down Arrow, Left Arrow, and Right Arrow to navigate between conditions and groups.

  • Use Left Arrow and Right Arrow to navigate between criteria operator and operands.