Hi Asier,
At this moment 'or' logic is only supported in numeric fields and not in text fields, this because it is easy to confuse
with the actual word or being used in a text string. We can customize this behavior of our UI library but it requires a
few hours of work or so (for me) and we would be less robust if the UI library gets upgraded (as parts of the standard
behavior needs to be replaced/overridden).
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
On 10/03/2011 01:48 PM, Asier Zabaleta Ibero wrote:
Martin,
For example, I want to filter in a string column, values containing east and west (trying to filter invoices from 2 or
more organizations).
How could I make this happen ?
Asier
On Sun, Sep 11, 2011 at 2:06 PM, Martin Taal <martin.t...@openbravo.com
<mailto:martin.t...@openbravo.com>> wrote:
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 <tel:%2B31%206%20288%2048%20943>
@:martin.t...@openbravo.com <mailto:martin.t...@openbravo.com>
Skype: martintaal
Openbravo Headquarters:
P:+34 93 27 25 947 <tel:%2B34%2093%2027%2025%20947>
F:+34 93 27 25 905 <tel:%2B34%2093%2027%2025%20905>
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
<mailto:Openbravo-development@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/openbravo-development
--
Asier Zabaleta Ibero
Senior Consultant
P:+34 607 798 464
F:+34 948 281 030
Address
Edificio Slan, Planta 2a, Landaben, Calle J,
31012 Pamplona, Navarra, Spain
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Openbravo-development mailing list
Openbravo-development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-development
