Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0027094 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | always | 2014-07-16 09:45 | 2014-08-08 18:54 | |||
| Reporter | caristu | View Status | public | |||||
| Assigned To | shankarb | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 3.0PR14Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 9ca3a8d726f5 | ||||
| Projection | none | ETA | none | Target Version | 3.0PR14Q4 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | AugustoMauch | |||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 29819 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0027094: Error after opening a saved view ordered by a foreign key column in the Role window | |||||||
| Description | When accessing to the Role window with a saved view ordered by a FK column the following error is raised: "Exception when creating query select e from <ADRole> as e left join ..." | |||||||
| Steps To Reproduce | 1) Activate the instance, in order to use the saved view feature 2) Go to the [Role] window 3) Sort the window using any of the FK columns: client or organization 4) Close the window 5) Access to the [Role] window again | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0069056) hgbot (developer) 2014-08-04 08:49 |
Repository: erp/devel/pi Changeset: 9ca3a8d726f58548b005750b361159d82f2b21e8 Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com> Date: Mon Aug 04 12:16:50 2014 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/9ca3a8d726f58548b005750b361159d82f2b21e8 [^] Fixes issue 0027094: Error after opening a saved view ordered by a foreign key column in the Role window Added alias to hql where clause. When foreign key column is used a join is created, so client.id will not resolved properly. --- M src-db/database/sourcedata/AD_TAB.xml --- |
|
(0069110) AugustoMauch (administrator) 2014-08-07 09:45 |
Code reviewed and verified in pi@9ca3a8d726f5 |
|
(0069256) hudsonbot (viewer) 2014-08-08 18:54 |
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/4450016dee64 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-07-16 09:45 | caristu | New Issue | |
| 2014-07-16 09:45 | caristu | Assigned To | => AugustoMauch |
| 2014-07-16 09:45 | caristu | OBNetwork customer | => No |
| 2014-07-16 09:45 | caristu | Modules | => Core |
| 2014-07-16 09:45 | caristu | Support ticket | => 29819 |
| 2014-07-16 09:45 | caristu | Triggers an Emergency Pack | => No |
| 2014-07-16 09:45 | caristu | Issue Monitored: networkb | |
| 2014-07-16 10:46 | caristu | Summary | Error after opening a saved view ordered by a foreign key column => Error after opening a saved view ordered by a foreign key column in the Role window |
| 2014-07-16 10:46 | caristu | Description Updated | View Revisions |
| 2014-07-16 10:50 | caristu | Resolution time | => 1411596000 |
| 2014-07-16 10:50 | caristu | Priority | immediate => high |
| 2014-07-16 10:50 | caristu | version | PR14Q2.3 => pi |
| 2014-07-16 10:50 | caristu | Target Version | => PR14Q4 |
| 2014-08-04 08:31 | shankarb | Assigned To | AugustoMauch => shankarb |
| 2014-08-04 08:47 | shankarb | Review Assigned To | => AugustoMauch |
| 2014-08-04 08:48 | shankarb | Issue Monitored: AugustoMauch | |
| 2014-08-04 08:49 | hgbot | Checkin | |
| 2014-08-04 08:49 | hgbot | Note Added: 0069056 | |
| 2014-08-04 08:49 | hgbot | Status | new => resolved |
| 2014-08-04 08:49 | hgbot | Resolution | open => fixed |
| 2014-08-04 08:49 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/9ca3a8d726f58548b005750b361159d82f2b21e8 [^] |
| 2014-08-07 09:45 | AugustoMauch | Note Added: 0069110 | |
| 2014-08-07 09:45 | AugustoMauch | Status | resolved => closed |
| 2014-08-07 09:45 | AugustoMauch | Fixed in Version | => 3.0PR14Q4 |
| 2014-08-08 18:54 | hudsonbot | Checkin | |
| 2014-08-08 18:54 | hudsonbot | Note Added: 0069256 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |