Page History

...

• Logical Expression - A filter will contain a logical expression which is evaluated on behalf of records in the filtered table(s). Only records, for which the expression evaluates to true, will be returned by any queries issued to the filtered table(s). At runtime, the filter will be translated into an SQL WHERE clauseand appended to the query of any foundset which is bound to the filtered table(s). An expression contains the following components:

  • Data Provider Name - This is the left-hand operand. It is the name of a single column by which to filter. When filtering an entire server connection, only tables which contain the named column will be filtered.

  • Operator - The following operators are supported

    =	Only records whose column equals the specified value
    <	Only records whose column is less than the specified value
    >	Only records whose column greater than the specified value
    >=	Only records whose column greater than or equals the specified value
    <=	Only records whose column less than or equalsthe specified value
    !=	Only records whose column does not equal the specified value
    ^	Only records whose column value is null
    LIKE	Only records whose column matches using the SQL LIKE construct (use wildcard '%' characters)
    IN	Only records whose column value is in (using the SQL IN construct) a list of values
    BETWEEN	Only records whose column value is (inclusive) between a list of 2 values
    #	Modifier, used to make case-insensitive queries
    ||	Modifier used to concatenate two conditions w/ a logical OR

    Note
    Operators and modifiers may be combined, producing more complex conditions. For example #^||!= would translate to: is null OR case-insensitive not equals

  • Data Provider Value - This is the right-hand operand and should evaluate to a literal value to be compared with the named column.

...