Openbravo's User Experience Lab
GUI design, ERP Usability and Visual Design

Filter Expressions

Tuesday, November 29, 2011

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.