Hi,
I updated Openbravo to the latest Smartclient 8.1 nightly builds. One new feature which I enabled is filter expressions.
It is now possible to use expressions in the column filtering in the header (on live.builds). This works for the
following types of fields:
- numeric fields
- string/text fields
- foreign key fields
Some nice extra features which filter expressions give are:
- you can show all records which are null or not null for a certain column
- show records which do not start with or do not end with a certain string in a
column
- range selection in numeric fields (also works in string columns)
Some obvious ones:
> or <, <= and >= (works also on text fields)
... (range), for example 1,1...2,4 will give all records with a value from 1,1 to 2,4 (it should work with number
formatting)
But also:
| (ends with), for example entering |as in a text column filter will show all
records with a value ending on as
! (not equal to)
^ (starts with)
!^ (not starts with)
!@ (not ends with)
~ (contains)
!~ (not contains)
== (exact match)
=.fieldName (for example if you type =.name in the column header of the description column then all records which have
an equal name and description are shown)
Rob will be looking at the expression language as some of the expressions are a bit techy, so the coming weeks some more
advanced expressions may change.
--
With Regards, Martin Taal
Openbravo
M: +31 6 288 48 943
@:martin.t...@openbravo.com
Skype: martintaal
Openbravo Headquarters:
P: +34 93 27 25 947
F: +34 93 27 25 905
Address: Edificio Slan, Planta 2a, Landaben, Calle J, 31012 Pamplona, Navarra,
Spain
Mailing address: PO Box 5117, 31010 Pamplona, Navarra, Spain
------------------------------------------------------------------------------
Using storage to extend the benefits of virtualization and iSCSI
Virtualization increases hardware utilization and delivers a new level of
agility. Learn what those decisions are and how to modernize your storage
and backup environments for virtualization.
http://www.accelacomm.com/jaw/sfnl/114/51434361/
_______________________________________________
Openbravo-development mailing list
Openbravo-development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-development
