Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0018557 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | minor | always | 2011-09-19 16:37 | 2012-03-02 15:38 | |||
Reporter | rgoris | View Status | public | |||||
Assigned To | mtaal | |||||||
Priority | high | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 9c8ee91f8e95 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
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 Reproduce | Try typing .= in a column filter | |||||||
Proposed Solution | Other 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). | |||||||
Tags | OB3-Reviewed | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |||||||||||||||
|
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 |