Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0033850 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | always | 2016-08-30 09:33 | 2016-12-16 18:38 | |||
| Reporter | JONHM | View Status | public | |||||
| Assigned To | NaroaIriarte | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR17Q1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 089aa21df4fb | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | alostale | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 43440 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0033850: Addresses are not filtered if region is not set | |||||||
| Description | In Location/Address tab of [Business Partner] widow, the addresses are not filtered if region isn't set. | |||||||
| Steps To Reproduce | 1- Log in the ERP with the "F&B Admin" role. 2- Go to "Business Partner" window and select any record. 3- Go to the "Location/Address" subtab and create a new record. 4- Click on the "Location/Address" field amplifier. 5- Fill every record instead of "Region" and save the record. 6- In the "Location/Address" filter, write the name of the newly created location. 7- Realize that the filter is not working and the message "No items to show" is shown. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0091606) hgbot (developer) 2016-11-16 16:53 |
Repository: erp/devel/pi Changeset: 089aa21df4fb76296bd8a9c163ebb6ce85069288 Author: Naroa Iriarte <naroa.iriarte <at> openbravo.com> Date: Mon Nov 14 13:26:18 2016 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/089aa21df4fb76296bd8a9c163ebb6ce85069288 [^] Fixed issue 33850: The Location/Address filter was not working fine The location/Address filter of the Location/Address subtab of the "Business Partner" tab was not working fine when trying to filter by Location/Addresses which had not a Region defined. The problem was in the generated query, there was a concatenation with the region name, and when the region was null, all the result was null. To fix this problem the coalesce funtion has been added to the query in the cases where it was not added. Now, if the value is null, as it is the case, the empty string will be get in the concatenation. --- M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java --- |
|
(0091814) alostale (viewer) 2016-11-25 09:43 |
code reviewed - tested: working both in Oracle and PostgreSQL |
|
(0092636) hudsonbot (viewer) 2016-12-16 18: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/dc8bf00badd0 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-08-30 09:33 | JONHM | New Issue | |
| 2016-08-30 09:33 | JONHM | Assigned To | => platform |
| 2016-08-30 09:33 | JONHM | OBNetwork customer | => Yes |
| 2016-08-30 09:33 | JONHM | Modules | => Core |
| 2016-08-30 09:33 | JONHM | Support ticket | => 43440 |
| 2016-08-30 09:33 | JONHM | Triggers an Emergency Pack | => No |
| 2016-09-06 13:06 | heccam | Issue Monitored: heccam | |
| 2016-10-18 14:10 | alostale | Status | new => acknowledged |
| 2016-10-26 13:07 | NaroaIriarte | Assigned To | platform => NaroaIriarte |
| 2016-11-16 16:53 | hgbot | Checkin | |
| 2016-11-16 16:53 | hgbot | Note Added: 0091606 | |
| 2016-11-16 16:53 | hgbot | Status | acknowledged => resolved |
| 2016-11-16 16:53 | hgbot | Resolution | open => fixed |
| 2016-11-16 16:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/089aa21df4fb76296bd8a9c163ebb6ce85069288 [^] |
| 2016-11-16 17:06 | NaroaIriarte | Review Assigned To | => alostale |
| 2016-11-16 17:06 | NaroaIriarte | Steps to Reproduce Updated | View Revisions |
| 2016-11-25 09:43 | alostale | Note Added: 0091814 | |
| 2016-11-25 09:43 | alostale | Status | resolved => closed |
| 2016-11-25 09:43 | alostale | Fixed in Version | => 3.0PR17Q1 |
| 2016-12-16 18:38 | hudsonbot | Checkin | |
| 2016-12-16 18:38 | hudsonbot | Note Added: 0092636 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |