Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026981Openbravo ERPA. Platformpublic2014-06-30 21:302014-08-08 18:52
Reporterjecharri 
Assigned Toshankarb 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR14Q4 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket29592
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026981: Impossible to filter amount fields in Query/List widgets
DescriptionImpossible to filter amount fields in Query/List widgets
Steps To Reproduce-Go to ERP and add widget "Invoice to Pay"
-Press in "show all" button and you will see the widget data as a window
-Try to filter the invoices with grandtotal higher than 10 with ">10"

Verify that there is no results when it should be.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0035956 closed alostale The numeric field filter does not work with operators in HQL based selectors 
Attached Filesdiff FixIssue26981.diff (15,024) 2014-07-03 08:50
https://issues.openbravo.com/file_download.php?file_id=7041&type=bug
Issue History
Date ModifiedUsernameFieldChange
2014-06-30 21:30jecharriNew Issue
2014-06-30 21:30jecharriAssigned To => AugustoMauch
2014-06-30 21:30jecharriOBNetwork customer => Yes
2014-06-30 21:30jecharriWeb browser => Google Chrome
2014-06-30 21:30jecharriModules => Core
2014-06-30 21:30jecharriSupport ticket => 29592
2014-06-30 21:30jecharriResolution time => 1404252000
2014-06-30 21:30jecharriTriggers an Emergency Pack => No
2014-07-03 08:50shankarbStatusnew => scheduled
2014-07-03 08:50shankarbNote Added: 0068525
2014-07-03 08:50shankarbfix_in_branch => pi
2014-07-03 08:50shankarbFile Added: FixIssue26981.diff
2014-07-03 08:51shankarbAssigned ToAugustoMauch => shankarb
2014-07-03 09:55jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2014-07-03 09:55jonalegriaesarteResolution time1404252000 => 1404424800
2014-07-03 09:55jonalegriaesartefix_in_branchpi =>
2014-07-06 09:14shankarbReview Assigned To => alostale
2014-07-06 09:14shankarbWeb browserGoogle Chrome => Google Chrome
2014-07-06 09:14shankarbIssue Monitored: alostale
2014-07-06 09:15hgbotCheckin
2014-07-06 09:15hgbotNote Added: 0068543
2014-07-06 09:15hgbotStatusscheduled => resolved
2014-07-06 09:15hgbotResolutionopen => fixed
2014-07-06 09:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/df2c956cf299ebafc29918e4330217d50e01ba00 [^]
2014-07-06 15:10hgbotCheckin
2014-07-06 15:10hgbotNote Added: 0068544
2014-07-14 10:18alostaleNote Added: 0068602
2014-07-14 10:18alostaleStatusresolved => closed
2014-07-14 10:18alostaleFixed in Version => PR14Q4
2014-08-08 18:52hudsonbotCheckin
2014-08-08 18:52hudsonbotNote Added: 0069141
2014-08-08 18:52hudsonbotCheckin
2014-08-08 18:52hudsonbotNote Added: 0069142
2017-05-22 11:53alostaleRelationship addedrelated to 0035956

Notes
(0068525)
shankarb   
2014-07-03 08:50   
Fix pushed to try. Will be pushed to pi once try passes. Fix will be attached to issue
(0068543)
hgbot   
2014-07-06 09:15   
Repository: erp/devel/pi
Changeset: df2c956cf299ebafc29918e4330217d50e01ba00
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Sun Jul 06 12:44:19 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/df2c956cf299ebafc29918e4330217d50e01ba00 [^]

Fixes Issue 26981: Impossible to filter amount fields in Query/List widgets

Applied the proper hql operator for numeric fields.

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0068544)
hgbot   
2014-07-06 15:10   
Repository: erp/devel/pi
Changeset: f23e38fd6bb0409d3168fc652782c6ca52e18704
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Sun Jul 06 18:40:05 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/f23e38fd6bb0409d3168fc652782c6ca52e18704 [^]

Related to Issue 26981 : Removed incorrect where clause when only operator is present

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
---
(0068602)
alostale   
2014-07-14 10:18   
Code reviewed + tested
(0069141)
hudsonbot   
2014-08-08 18:52   
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/4450016dee64 [^]
Maturity status: Test
(0069142)
hudsonbot   
2014-08-08 18:52   
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/4450016dee64 [^]
Maturity status: Test