Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0025447 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] B. User interface | minor | always | 2014-01-08 16:14 | 2014-03-06 11:18 | |||
| Reporter | caristu | View Status | public | |||||
| Assigned To | shankarb | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR14Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 75f848b61c97 | ||||
| Projection | none | ETA | none | Target Version | 3.0PR14Q2 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | AugustoMauch | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0025447: isNull filter expression is not working properly for table reference | |||||||
| Description | The isNull filter expression is not working properly for those fields that are related to a table reference. Other filter expressions like isNotNull are working fine. | |||||||
| Steps To Reproduce | 1) Go to the [Sales Order] window and display the "Sales Representative" (table reference) field in grid view. 2) Without removing the implicit filters, put # (isNull) in the Sales Representative filter. It works fine. 3) Remove the implicit filter (by clicking on the funnel icon) 4) Put # (isNull) in the Sales Representative filter. It doesn't work. 5) Put !# (isNotNull) in the Sales Representative filter. It works fine. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0063318) alostale (manager) 2014-01-08 18:59 edited on: 2014-01-08 19:01 |
This is the current query: Order as e left join e.salesRepresentative as join_0 where (( e.salesRepresentative.name is null )) This is what it should be: Order as e left join e.salesRepresentative as join_0 where (( e.salesRepresentative is null )) Notes: *when fixing this issue take also into account adaptive filtering *verify also other FK references (tableDir, selector...) |
|
(0064703) hgbot (developer) 2014-03-03 06:13 |
Repository: erp/devel/pi Changeset: 75f848b61c970b56a125d16cc20f52179587b357 Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com> Date: Thu Feb 06 14:23:45 2014 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/75f848b61c970b56a125d16cc20f52179587b357 [^] Fixes Issue 25447: isNull filter expression is not working properly for table reference If the operator is isNull or notNull comparison should be done at the object level and not at the field value level --- M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java --- |
|
(0064757) hudsonbot (developer) 2014-03-03 17: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/8d1e52794b1e [^] Maturity status: Test |
|
(0064900) AugustoMauch (administrator) 2014-03-06 11:18 |
Code reviewed and verified in pi@9484419af022. Tested with and without adaptive filtering. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-01-08 16:14 | caristu | New Issue | |
| 2014-01-08 16:14 | caristu | Assigned To | => dbaz |
| 2014-01-08 16:14 | caristu | Modules | => Core |
| 2014-01-08 16:14 | caristu | Resolution time | => 1395788400 |
| 2014-01-08 16:14 | caristu | Triggers an Emergency Pack | => No |
| 2014-01-08 16:15 | dbaz | Assigned To | dbaz => shankarb |
| 2014-01-08 16:15 | caristu | Assigned To | shankarb => dbaz |
| 2014-01-08 16:15 | caristu | Summary | isNull expression filter is not working properly for table reference => isNull filter expression is not working properly for table reference |
| 2014-01-08 16:15 | caristu | Description Updated | View Revisions |
| 2014-01-08 16:15 | caristu | Issue Monitored: networkb | |
| 2014-01-08 16:23 | caristu | Assigned To | dbaz => shankarb |
| 2014-01-08 18:59 | alostale | Note Added: 0063318 | |
| 2014-01-08 19:00 | alostale | Relationship added | related to 0025211 |
| 2014-01-08 19:01 | alostale | Note Edited: 0063318 | View Revisions |
| 2014-02-27 13:31 | caristu | Target Version | 3.0MP33 => 3.0MP32 |
| 2014-03-03 06:12 | shankarb | Issue Monitored: AugustoMauch | |
| 2014-03-03 06:12 | shankarb | Review Assigned To | => AugustoMauch |
| 2014-03-03 06:13 | hgbot | Checkin | |
| 2014-03-03 06:13 | hgbot | Note Added: 0064703 | |
| 2014-03-03 06:13 | hgbot | Status | new => resolved |
| 2014-03-03 06:13 | hgbot | Resolution | open => fixed |
| 2014-03-03 06:13 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/75f848b61c970b56a125d16cc20f52179587b357 [^] |
| 2014-03-03 17:38 | hudsonbot | Checkin | |
| 2014-03-03 17:38 | hudsonbot | Note Added: 0064757 | |
| 2014-03-06 11:18 | AugustoMauch | Note Added: 0064900 | |
| 2014-03-06 11:18 | AugustoMauch | Status | resolved => closed |
| 2014-03-06 11:18 | AugustoMauch | Fixed in Version | => PR14Q2 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |