This tab defines Boolean operations applicable for fields.
List in the left section shows defined operations. Add or delete one by right-clicking the list and choosing appropriate topic from the pop-up menu. To edit an operation, choose it from the list and modify its properties in the dialog's right section.
Operator name is the internal identifier for the operator.
Display name means how the operation will be displayed for a user working with visual query editor.
SQL expression is template for expression in generated SQL query. When building the SQL text:
@f is substituted with the field's name
@1, @2 are substituted with 1st and 2nd constant parameter.
Values format is a string which will separate parameters (in case there are two of them) in the visual query editor.
Values list means that @1 value should be treated as a comma-separated list. E.g., having this option checked, when the user enters a, b, c as parameter value, it's treated as 'a', 'b', 'c' instead of 'a, b, c' in the generated SQL text.
Type of expression means expected type for parameter. It can be the same as field type or of some certain type (see Field Type).
Apply to types is a list of check boxes defining field types to which the operation is applicable.
Ask a Question has such predefined operations:
Name Display SQL expression
EqualTo is equal to @f = '@1'
NotEqual is not equal to @f <> '@1'
LessThan is less than @f < '@1'
LessOrEqual is less than or equal to @f <= '@1'
GreaterThan greater than @f >'@1'
GreaterOrEqual greater than or equal to @f >= '@1'
IsNull is null @f is null
InList is in list @f in (@1)
StartingWith is starting with @f like '@1%'
NotStartingWith is not starting with not (@f like '@1%')
Contains contains @f like '%@1%'
NotContains not contains not (@f like '%@1%')
Between is between @f between '@1' and '@2'
