Chat now with support
Chat with Support

Toad Data Point 6.1 - Release Notes

Set WHERE Conditions

In the Query Builder, you can use a Where condition to filter data returned by a query or to join sets of data.

Note: If you reverse engineer a query that contains a Where clause, it displays in a Global Where clause bubble on the Diagram pane rather than the Where Condition field below the Diagram pane. You can double-click the Global Where Clause bubble in the Diagram pane, or can click to edit it.

To set a Where condition

  1. In the Query Builder, add columns to the query. To learn more about the Query Builder, see Build Queries Visually.
  2. In the Criteria pane (bottom pane), select the column you want to use to filter data.
  3. Select the Where field in the column and click .

    Note: You can also use the Where Condition to add the same column twice to the query.

  4. Use the Where Condition editor to create a Where clause. Review the following for additional information:

    Form Page Description

    Field

    Select an operator or predicate to use in this condition.

    Value 1 Type

    (Value 2 Type)

    Select whether the expression is a column or constant.

    • Column—After selecting this option, select the column name.
    • Constant—After selecting this option, enter a value or select a value from the list.

    If using the IN or NOT IN operator, you can load multiple values from a .txt, Excel, or .csv file.

    • Select Constant. Click in the field to browse to and select a file. If using an Excel file, all values must be in the first column in the first worksheet. If using a .txt file, each value must be on a separate line.
    • After the file is uploaded, the values are automatically added to the Where clause. Click the down arrow to display the loaded values or to deselect some values.

    Notes:

    • You can also specify a bind variable in this field using ":variable". If you enter a variable, you are prompted to enter a value for the variable when you execute the statement.
    • The Value 2 Type field is only available if you select the Between predicate.

    Formula Page

    Description

    Functions

    Perform an incremental search or select a function and then select a column on which to perform the function.

    Note: The date format for functions is any valid date format supported by the database surrounded by single quotes (for example, 'mm/dd/yy').

    Operators

    Double-click an operator or predicate to use in this condition.

    Columns and calculated fields

    Double-click a column to apply a function or operator against.

    Date Range Page

    Description

    Date Range Values

    Select a date range to apply to this column. Set Date Ranges

    Note: This tab only displays if you select a column that has a Date data type.

Tips:

  • You can use variables in a Where condition. Using Bind Variables
  • Click Subquery to add a subquery. Add Subqueries
  • To remove a Where condition, open the Where Condition window and click Remove.

 

Related Topics

Build Queries Visually 

Add Subqueries

Add Or Conditions 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating