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
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.
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.
If using the IN or NOT IN operator, you can load multiple values from a .txt, Excel, or .csv file.
Notes:
|
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. See Set Date Ranges for more information. Note: This tab only displays if you select a column that has a Date data type. |
Tips:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center