Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0035956Openbravo ERPA. Platformpublic2017-05-09 10:222017-05-29 17:43
JONHM 
alostale 
highmajoralways
closedfixed 
5
pi 
3.0PR17Q3 
caristu
Core
No
0035956: The numeric field filter does not work with operators in HQL based selectors
The numeric field filter does not work with operators in HQL based selectors, if price list is set.
1) Open window [Purchase Invoice] and create a new record
2) Create a new line and open product selector (select lens icon)
3) Having a Price list set, filter by products with 'Unit Price' value >1

--> We got message no items to show
No tags attached.
related to defect 0026981 closed shankarb Impossible to filter amount fields in Query/List widgets 
related to defect 0032940 closed caristu Not possible to filter string fields in Custom Query Selectors using equals operator 
related to defect 0030096 closed caristu Cannot filter the business partner field by ' symbol in selector drop down 
depends on defect 00177593.0MP2 closed adrianromero The popup of selector does not filter properly when defining "start with" filtering 
png Screenshot from 2017-05-09 10-16-35.png (92,449) 2017-05-09 10:22
https://issues.openbravo.com/file_download.php?file_id=10739&type=bug
png
Issue History
2017-05-09 10:22JONHMNew Issue
2017-05-09 10:22JONHMAssigned To => platform
2017-05-09 10:22JONHMFile Added: Screenshot from 2017-05-09 10-16-35.png
2017-05-09 10:22JONHMModules => Core
2017-05-09 10:22JONHMResolution time => 1496095200
2017-05-09 10:22JONHMTriggers an Emergency Pack => No
2017-05-09 13:29jfrancesIssue Monitored: jfrances
2017-05-22 11:49alostaleAssigned Toplatform => alostale
2017-05-22 11:49alostaleStatusnew => acknowledged
2017-05-22 11:49alostaleReview Assigned To => caristu
2017-05-22 11:53alostaleRelationship addedrelated to 0026981
2017-05-22 11:54hgbotCheckin
2017-05-22 11:54hgbotNote Added: 0096698
2017-05-22 11:54hgbotStatusacknowledged => resolved
2017-05-22 11:54hgbotResolutionopen => fixed
2017-05-22 11:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bd9a190d0eea4c7a9634123c1bd7c081346065f3 [^]
2017-05-25 08:38caristuRelationship addedrelated to 0032940
2017-05-25 08:38caristuRelationship addeddepends on 0017759
2017-05-25 09:03caristuRelationship addedrelated to 0030096
2017-05-25 09:15hgbotCheckin
2017-05-25 09:15hgbotNote Added: 0096771
2017-05-25 09:16caristuNote Added: 0096773
2017-05-25 09:16caristuStatusresolved => closed
2017-05-25 09:16caristuFixed in Version => 3.0PR17Q3
2017-05-29 17:43hudsonbotCheckin
2017-05-29 17:43hudsonbotNote Added: 0096979
2017-05-29 17:43hudsonbotCheckin
2017-05-29 17:43hudsonbotNote Added: 0096985

Notes
(0096698)
hgbot   
2017-05-22 11:54   
Repository: erp/devel/pi
Changeset: bd9a190d0eea4c7a9634123c1bd7c081346065f3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon May 22 11:53:43 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/bd9a190d0eea4c7a9634123c1bd7c081346065f3 [^]

fixed bug 35956: numeric filter does not work with operators in HQL selectors

  CustomQuerySelectorDatasource didn't attend the actual operator in numeric
  advanced criterias, it was always using equals.

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0096771)
hgbot   
2017-05-25 09:15   
Repository: erp/devel/pi
Changeset: 9398554178854e765047d504b3bdbc2c903a9a14
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu May 25 09:13:54 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9398554178854e765047d504b3bdbc2c903a9a14 [^]

related to bug 35956: added missing javadoc info for the getWhereClause method

---
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/CustomQuerySelectorDatasource.java
---
(0096773)
caristu   
2017-05-25 09:16   
Code reviewed + testing OK.
(0096979)
hudsonbot   
2017-05-29 17:43   
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/1ee70113bdc4 [^]
Maturity status: Test
(0096985)
hudsonbot   
2017-05-29 17:43   
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/1ee70113bdc4 [^]
Maturity status: Test