Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035956 | Openbravo ERP | A. Platform | public | 2017-05-09 10:22 | 2017-05-29 17:43 |
|
| Reporter | JONHM | |
| Assigned To | alostale | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | | Fixed in Version | 3.0PR17Q3 | |
| Merge Request Status | |
| Review Assigned To | caristu |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 46658 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0035956: The numeric field filter does not work with operators in HQL based selectors |
| Description | The numeric field filter does not work with operators in HQL based selectors, if price list is set. |
| Steps To Reproduce | 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 |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | 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 | 0017759 | 3.0MP2 | closed | adrianromero | The popup of selector does not filter properly when defining "start with" filtering |
|
| Attached Files |  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
|
|
| 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 | OBNetwork customer | => Yes |
| 2017-05-09 10:22 | JONHM | Modules | => Core |
| 2017-05-09 10:22 | JONHM | Support ticket | => 46658 |
| 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 | |
|
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
---
|
|
|
|
|
|
Code reviewed + testing OK. |
|
|
|
|
|
|
|
|
|