General Ledger  GL Query Builder  CQB Design Elements  Filters

Understanding the GL Query Builder (continued)

Filters (continued)

Listed below are the Relation types available when creating filters.

=                    Equal to

<>                    Not Equal To

>                    Greater Than (used with numeric or date type fields)

<                    Less Than (used with numeric or date type fields)

>=                    Greater Than or Equal To (used with numeric or date type fields)

<=                    Less Than or Equal To (used with numeric or date type fields)

Is Null                    The field is empty

Is Not Null          The field contains any value

Starts With          The value entered is found at the beginning of the field

Ends With          The value entered is found at the end of the field

Contains          The value entered is found anywhere in the data

Page   1  2  3  4  5  6  7  8  9                                                   Page  6