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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035956
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2017-05-09 10:222017-05-29 17:43
ReporterJONHMView Statuspublic 
Assigned Toalostale 
PriorityhighResolutionfixedFixed in Version3.0PR17Q3
StatusclosedFix in branchFixed in SCM revisionbd9a190d0eea
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035956: The numeric field filter does not work with operators in HQL based selectors

DescriptionThe numeric field filter does not work with operators in HQL based selectors, if price list is set.
Steps To Reproduce1) 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
TagsNo tags attached.
Attached Filespng file icon Screenshot from 2017-05-09 10-16-35.png [^] (92,449 bytes) 2017-05-09 10:22

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0026981 closedshankarb Impossible to filter amount fields in Query/List widgets 
related to defect 0032940 closedcaristu Not possible to filter string fields in Custom Query Selectors using equals operator 
related to defect 0030096 closedcaristu Cannot filter the business partner field by ' symbol in selector drop down 
depends on defect 00177593.0MP2 closedadrianromero The popup of selector does not filter properly when defining "start with" filtering 

-  Notes
(0096698)
hgbot (developer)
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 (developer)
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 (developer)
2017-05-25 09:16

 Code reviewed + testing OK.
(0096979)
hudsonbot (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2017-05-09 10:22 JONHM New Issue
2017-05-09 10:22 JONHM Assigned To => platform
2017-05-09 10:22 JONHM File Added: Screenshot from 2017-05-09 10-16-35.png
2017-05-09 10:22 JONHM Modules => Core
2017-05-09 10:22 JONHM Resolution time => 1496095200
2017-05-09 10:22 JONHM Triggers an Emergency Pack => No
2017-05-09 13:29 jfrances Issue Monitored: jfrances
2017-05-22 11:49 alostale Assigned To platform => alostale
2017-05-22 11:49 alostale Status new => acknowledged
2017-05-22 11:49 alostale Review Assigned To => caristu
2017-05-22 11:53 alostale Relationship added related to 0026981
2017-05-22 11:54 hgbot Checkin
2017-05-22 11:54 hgbot Note Added: 0096698
2017-05-22 11:54 hgbot Status acknowledged => resolved
2017-05-22 11:54 hgbot Resolution open => fixed
2017-05-22 11:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bd9a190d0eea4c7a9634123c1bd7c081346065f3 [^]
2017-05-25 08:38 caristu Relationship added related to 0032940
2017-05-25 08:38 caristu Relationship added depends on 0017759
2017-05-25 09:03 caristu Relationship added related to 0030096
2017-05-25 09:15 hgbot Checkin
2017-05-25 09:15 hgbot Note Added: 0096771
2017-05-25 09:16 caristu Note Added: 0096773
2017-05-25 09:16 caristu Status resolved => closed
2017-05-25 09:16 caristu Fixed in Version => 3.0PR17Q3
2017-05-29 17:43 hudsonbot Checkin
2017-05-29 17:43 hudsonbot Note Added: 0096979
2017-05-29 17:43 hudsonbot Checkin
2017-05-29 17:43 hudsonbot Note Added: 0096985

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker