Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018557
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2011-09-19 16:372012-03-02 15:38
ReporterrgorisView Statuspublic 
Assigned Tomtaal 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision9c8ee91f8e95
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018557: 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).
TagsOB3-Reviewed
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0018518 newTriage Platform Base Add GUI based column filter expressions 
related to design defect 0031315 acknowledgedTriage Platform Base Equals other column filter is not working 

-  Notes
(0044964)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (reporter)
2012-02-22 12:38

Tested and code reviewed on pi @ rev 94ab687f1f98
(0045789)
hudsonbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2011-09-19 16:37 rgoris New Issue
2011-09-19 16:37 rgoris Assigned To => mtaal
2011-09-19 16:37 rgoris Modules => Core
2011-09-19 16:37 rgoris Relationship added related to 0018518
2011-10-28 20:52 iciordia Tag Attached: OB3-Reviewed
2011-11-15 10:14 iperdomo Target Version 3.0MP6 =>
2012-02-09 15:18 hgbot Checkin
2012-02-09 15:18 hgbot Note Added: 0044964
2012-02-09 15:18 hgbot Status new => resolved
2012-02-09 15:18 hgbot Resolution open => fixed
2012-02-09 15:18 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2d73d1ed6bf15077f6aa50ca9f476d8fe29d0ce9 [^]
2012-02-10 22:14 hgbot Checkin
2012-02-10 22:14 hgbot Note Added: 0045027
2012-02-10 22:37 hgbot Checkin
2012-02-10 22:37 hgbot Note Added: 0045030
2012-02-13 11:54 rgoris Note Added: 0045065
2012-02-13 11:54 rgoris Status resolved => closed
2012-02-14 13:52 iperdomo Status closed => new
2012-02-14 13:52 iperdomo Resolution fixed => open
2012-02-17 18:55 hgbot Checkin
2012-02-17 18:55 hgbot Note Added: 0045247
2012-02-17 18:55 hgbot Status new => resolved
2012-02-17 18:55 hgbot Resolution open => fixed
2012-02-17 18:55 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/2d73d1ed6bf15077f6aa50ca9f476d8fe29d0ce9 [^] => http://code.openbravo.com/erp/devel/pi/rev/9c8ee91f8e95cdd965f03380fc921c58407a5b83 [^]
2012-02-21 08:14 hgbot Checkin
2012-02-21 08:14 hgbot Note Added: 0045294
2012-02-22 09:55 hgbot Checkin
2012-02-22 09:55 hgbot Note Added: 0045337
2012-02-22 09:55 hgbot Checkin
2012-02-22 09:55 hgbot Note Added: 0045338
2012-02-22 12:38 iperdomo Note Added: 0045355
2012-02-22 12:38 iperdomo Status resolved => closed
2012-03-02 15:35 hudsonbot Checkin
2012-03-02 15:35 hudsonbot Note Added: 0045789
2012-03-02 15:36 hudsonbot Checkin
2012-03-02 15:36 hudsonbot Note Added: 0045812
2012-03-02 15:36 hudsonbot Checkin
2012-03-02 15:36 hudsonbot Note Added: 0045814
2012-03-02 15:38 hudsonbot Checkin
2012-03-02 15:38 hudsonbot Note Added: 0045887
2012-03-02 15:38 hudsonbot Checkin
2012-03-02 15:38 hudsonbot Note Added: 0045909
2012-03-02 15:38 hudsonbot Checkin
2012-03-02 15:38 hudsonbot Note Added: 0045918
2012-03-02 15:38 hudsonbot Checkin
2012-03-02 15:38 hudsonbot Note Added: 0045919
2015-11-27 13:22 caristu Relationship added related to 0031315


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker