Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018557Openbravo ERPA. Platformpublic2011-09-19 16:372012-03-02 15:38
Reporterrgoris 
Assigned Tomtaal 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018557: Filter Expression: comparing to other field (column) values
Description 
   =.fieldName means the value should match the value of another field. Either the user-visible title of the field (field.title) or the field's name (field.name) may be used.

THis does not work properly at the moment: another = is added automatically while typing the =.

Steps To ReproduceTry typing .= in a column filter
Proposed SolutionOther than that, we need to extend this to more applicable cases:
>.fieldName is greater than the other field (e.g. when comparing amount outstanding with amount paid)
<. similar
>=.fieldName similar
<=.fieldName
!.fieldName does not equal other field (also when comparing discrepancies)

This functionality must also be supported by the GUI dialog (see related issue).
Additional Information
TagsOB3-Reviewed
Relationships
related to feature request 0018518 new Triage Platform Base Add GUI based column filter expressions 
related to design defect 0031315 acknowledged Triage Platform Base Equals other column filter is not working 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-09-19 16:37rgorisNew Issue
2011-09-19 16:37rgorisAssigned To => mtaal
2011-09-19 16:37rgorisModules => Core
2011-09-19 16:37rgorisRelationship addedrelated to 0018518
2011-10-28 20:52iciordiaTag Attached: OB3-Reviewed
2011-11-15 10:14iperdomoTarget Version3.0MP6 =>
2012-02-09 15:18hgbotCheckin
2012-02-09 15:18hgbotNote Added: 0044964
2012-02-09 15:18hgbotStatusnew => resolved
2012-02-09 15:18hgbotResolutionopen => fixed
2012-02-09 15:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2d73d1ed6bf15077f6aa50ca9f476d8fe29d0ce9 [^]
2012-02-10 22:14hgbotCheckin
2012-02-10 22:14hgbotNote Added: 0045027
2012-02-10 22:37hgbotCheckin
2012-02-10 22:37hgbotNote Added: 0045030
2012-02-13 11:54rgorisNote Added: 0045065
2012-02-13 11:54rgorisStatusresolved => closed
2012-02-14 13:52iperdomoStatusclosed => new
2012-02-14 13:52iperdomoResolutionfixed => open
2012-02-17 18:55hgbotCheckin
2012-02-17 18:55hgbotNote Added: 0045247
2012-02-17 18:55hgbotStatusnew => resolved
2012-02-17 18:55hgbotResolutionopen => fixed
2012-02-17 18:55hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/2d73d1ed6bf15077f6aa50ca9f476d8fe29d0ce9 [^] => http://code.openbravo.com/erp/devel/pi/rev/9c8ee91f8e95cdd965f03380fc921c58407a5b83 [^]
2012-02-21 08:14hgbotCheckin
2012-02-21 08:14hgbotNote Added: 0045294
2012-02-22 09:55hgbotCheckin
2012-02-22 09:55hgbotNote Added: 0045337
2012-02-22 09:55hgbotCheckin
2012-02-22 09:55hgbotNote Added: 0045338
2012-02-22 12:38iperdomoNote Added: 0045355
2012-02-22 12:38iperdomoStatusresolved => closed
2012-03-02 15:35hudsonbotCheckin
2012-03-02 15:35hudsonbotNote Added: 0045789
2012-03-02 15:36hudsonbotCheckin
2012-03-02 15:36hudsonbotNote Added: 0045812
2012-03-02 15:36hudsonbotCheckin
2012-03-02 15:36hudsonbotNote Added: 0045814
2012-03-02 15:38hudsonbotCheckin
2012-03-02 15:38hudsonbotNote Added: 0045887
2012-03-02 15:38hudsonbotCheckin
2012-03-02 15:38hudsonbotNote Added: 0045909
2012-03-02 15:38hudsonbotCheckin
2012-03-02 15:38hudsonbotNote Added: 0045918
2012-03-02 15:38hudsonbotCheckin
2012-03-02 15:38hudsonbotNote Added: 0045919
2015-11-27 13:22caristuRelationship addedrelated to 0031315

Notes
(0044964)
hgbot   
2012-02-09 15:18   
Repository: erp/devel/pi
Changeset: 2d73d1ed6bf15077f6aa50ca9f476d8fe29d0ce9
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Feb 09 15:17:50 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2d73d1ed6bf15077f6aa50ca9f476d8fe29d0ce9 [^]

Fixes issue 18557: Filter Expression: comparing to other field (column) values

---
M modules/org.openbravo.userinterface.smartclient/web/org.openbravo.userinterface.smartclient/js/ob-smartclient.js
---
(0045027)
hgbot   
2012-02-10 22:14   
Repository: erp/devel/pi
Changeset: 77bd40529a885218c3affd6a78946d6e4addcace
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Fri Feb 10 22:14:02 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/77bd40529a885218c3affd6a78946d6e4addcace [^]

Related to issue 18557: Filter Expression: comparing to other field (column) values

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-grid.js
---
(0045030)
hgbot   
2012-02-10 22:37   
Repository: erp/devel/pi
Changeset: 23efa6079aa6722b60fa96351a0873f1774f931e
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Fri Feb 10 22:35:58 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/23efa6079aa6722b60fa96351a0873f1774f931e [^]

Related to issue 18557: Filter Expression: comparing to other field (column) values

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/form/formitem/ob-formitem-number.js
---
(0045065)
rgoris   
2012-02-13 11:54   
It works now for =.fieldName. Once in a while an SQL error is returned but this is not reproducable. We decided not to activate >, < and <> , it is better implemented in a later stage with a GUI to assist the user in building the query. Documentation updated here: http://wiki.openbravo.com/wiki/ManualDoc:OB3_UserInterface#Column_Filters [^]
(0045247)
hgbot   
2012-02-17 18:55   
Repository: erp/devel/pi
Changeset: 9c8ee91f8e95cdd965f03380fc921c58407a5b83
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Fri Feb 17 18:54:21 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9c8ee91f8e95cdd965f03380fc921c58407a5b83 [^]

Fixes issue 18557: Filter Expression: comparing to other field (column) values
Show more helpfull message if the filter is incorrect
Moved a generic method from the kernel module to core

---
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/KernelUtils.java
M modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MESSAGE.xml
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
M src/org/openbravo/erpCommon/utility/Utility.java
---
(0045294)
hgbot   
2012-02-21 08:14   
Repository: erp/devel/pi
Changeset: 8e3bca6e8153b013da361059f3e966a249663854
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Mon Feb 20 23:53:10 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8e3bca6e8153b013da361059f3e966a249663854 [^]

Related to issue 18557: Filter Expression: comparing to other field (column) values
Also handle illegal filter values in a nicer way using a message

---
M modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MESSAGE.xml
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0045337)
hgbot   
2012-02-22 09:55   
Repository: erp/devel/pi
Changeset: aeb1f4a8bfeda3763faa1738733fab382fe167ca
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Feb 22 09:49:00 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/aeb1f4a8bfeda3763faa1738733fab382fe167ca [^]

Related to issue 18557: Filter Expression: comparing to other field (column) values
Hide the error message if a new filter action takes place

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
---
(0045338)
hgbot   
2012-02-22 09:55   
Repository: erp/devel/pi
Changeset: 6289860471caea942c8ca2645148126db0fab367
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Feb 22 09:54:57 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/6289860471caea942c8ca2645148126db0fab367 [^]

Related to issue 18557: Filter Expression: comparing to other field (column) values
Hide message if grid is filtered

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
---
(0045355)
iperdomo   
2012-02-22 12:38   
Tested and code reviewed on pi @ rev 94ab687f1f98
(0045789)
hudsonbot   
2012-03-02 15:35   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test
(0045812)
hudsonbot   
2012-03-02 15:36   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test
(0045814)
hudsonbot   
2012-03-02 15:36   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test
(0045887)
hudsonbot   
2012-03-02 15:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test
(0045909)
hudsonbot   
2012-03-02 15:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test
(0045918)
hudsonbot   
2012-03-02 15:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test
(0045919)
hudsonbot   
2012-03-02 15:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test