Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0019621 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | sometimes | 2012-02-02 10:18 | 2012-03-02 15:36 | |||
| Reporter | ioritzCia | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | e4e3a55d6378 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_22 | |||
| OS Version | Ubuntu 10.04 | Database version | 8.4 | Ant version | 1.7.1 | |||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | Mozilla Firefox | |||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0019621: Advance Filtering is not working correctly in some columns. | |||||||
| Description | Advance Filtering is not working correctly in some columns. I think it happens in the ones that are an ID but this is a guess. | |||||||
| Steps To Reproduce | - Go to 'Matched Purchase Orders' window. - Try to set "#" filter in 'Invoice Line' to see the rows that have that value to null. It does not work. - If you try to make a workaround to the previous filter you can set the filter to "!^P and !^F" it does not work neither. -This column is an ID I have also tested the same filters in the line of an invoice with the product column and it does not work neither. - I have tested them in the Business Partner Catgory window in the name column an they work fine. This is not an ID window. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0045070) alostale (viewer) 2012-02-13 15:59 |
The problem is in FK filters. For "null" and "notNull" operators the generated query composes the identifier and then checks if it is null or not null. Problem is in HQL compound paths are transformed in SQL inner joins, so null entries are just removed. The solution is not to compose the identifier in this case but to directly check its nullness. The risk of regression of this fix is low as it only affects filters null and not null on identifier columns. |
|
(0045071) hgbot (developer) 2012-02-13 16:01 |
Repository: erp/devel/pi Changeset: e4e3a55d6378ec9152cdeeabf570e5a7d096c195 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Mon Feb 13 16:00:40 2012 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/e4e3a55d6378ec9152cdeeabf570e5a7d096c195 [^] fixed bug 19621: fixed null and not null filters on FK fields --- M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java --- |
|
(0045327) marvintm (viewer) 2012-02-21 17:55 |
Tested both id and non-id columns. |
|
(0045835) hudsonbot (viewer) 2012-03-02 15:36 |
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/544d64e0c159 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-02-02 10:18 | ioritzCia | New Issue | |
| 2012-02-02 10:18 | ioritzCia | Assigned To | => alostale |
| 2012-02-02 10:18 | ioritzCia | Web browser | => Mozilla Firefox |
| 2012-02-02 10:18 | ioritzCia | Modules | => Core |
| 2012-02-02 10:18 | ioritzCia | OBNetwork customer | => No |
| 2012-02-07 08:41 | alostale | Relationship added | related to 0019253 |
| 2012-02-13 15:59 | alostale | Note Added: 0045070 | |
| 2012-02-13 16:01 | hgbot | Checkin | |
| 2012-02-13 16:01 | hgbot | Note Added: 0045071 | |
| 2012-02-13 16:01 | hgbot | Status | new => resolved |
| 2012-02-13 16:01 | hgbot | Resolution | open => fixed |
| 2012-02-13 16:01 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e4e3a55d6378ec9152cdeeabf570e5a7d096c195 [^] |
| 2012-02-21 17:55 | marvintm | Note Added: 0045327 | |
| 2012-02-21 17:55 | marvintm | Status | resolved => closed |
| 2012-03-02 15:36 | hudsonbot | Checkin | |
| 2012-03-02 15:36 | hudsonbot | Note Added: 0045835 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |