This menu allows you to specify a Where clause to use in your data query. A
Where clause in an SQL statement restricts (or filters) the rows which are
returned by SQL query. The Clause is in the form of a logical statement which
must be TRUE for the row to be included in the result set. The lists at the
bottom of the menu list the available columns, functions and operators that
can be used to build the clause.
Only Include Rows Where Clause
A text editor into which you can type a where clause.
Available Columns
List of available columns from current table that can be used in the where
clause. Double clicking on a column name will insert it into the where clause
at the current cursor position.
Available Functions
List of available SQL functions that can be used in the where clause. Double
clicking on a function name will insert it into the where clause at the
current cursor position.
Operators
List of available operators that can be used in the where clause. Double
clicking on an operator will insert it into the where clause at the current
cursor position.
Clear
Removes all the text from the current where clause.