Expression Builder

Top  Previous  Next

The Expression Builder dialog assists you in composing SQL queries. The SQL syntax is well hidden behind a simple user interface, making it pretty simple to create queries.

 

There are four types of fields:

· Boolean - A true/false value.
· Date/time - A date, time, or date/time value.
· Numeric - A 32 bit integer.
· Text - A string of characters

 

Each field data type has its own set of operators, and each operator has zero, one, or two operands (value fields). This means that when you choose field and operator, the dialog box shows the necessary fields you have to fill in.

 

 

expr_build

 

 

expr_build2

 

expr_build3

 

 

Category - lists all the inventory categories.

 

Field - lists all fields for the selected category.

 

Operator - lists all the available operators for the selected field.

 

Value fields - enter a value in the value fields (one or two depending on the operator).

 

 

Boolean operators:

 

is false

is true

 

Date/time operators:

 

is after today

is before today

is between

is empty

is last 7 days

is last month

is last week

is not empty

is on

is on or after

is on or before

is this month

is this week

is today

is today or after

is today or before

is tomorrow

is yesterday

 

Numeric operators:

 

is at least

is at most

is between

is equal

is less than

is more than

is not equal

 

Text operators:

 

begins with

contains

does not contains

ends with

is at least

is at most

is between

is empty

is equal

is less than

is more than

is not empty

is not equal