Menu
Nov 29, 2011

Filter Expressions

They were introduced in maintenance pack 4 last month but have not been given the attention they deserve: Filter Expressions. These are handy clauses that can be applied to grids. Examples are “greater than” (>), “between” (…) or even the more uncommon ones such as “does not end with” (!@) and many more.  A boolean “or” can also be used to combine expressions, such as 0…100 or >200, which is “between 0 and 100 or greater than 200″.

Once you have created a complex set of filter expressions for your grid, such as “All unpaid invoices in USD with a value higher than $1000 and more than 21 days overdue for customers with names starting with A to G“, you may want to use Saving Views to avoid rework next time you want to apply the same filter set.

Here´s the complete list of filter expressions.

Categories: Other | Leave a comment

Leave a Comment

(required)