Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027094Openbravo ERPA. Platformpublic2014-07-16 09:452014-08-08 18:54
Reportercaristu 
Assigned Toshankarb 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR14Q4Fixed in Version3.0PR14Q4 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket29819
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027094: Error after opening a saved view ordered by a foreign key column in the Role window
DescriptionWhen 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 Reproduce1) 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-16 09:45caristuNew Issue
2014-07-16 09:45caristuAssigned To => AugustoMauch
2014-07-16 09:45caristuOBNetwork customer => No
2014-07-16 09:45caristuModules => Core
2014-07-16 09:45caristuSupport ticket => 29819
2014-07-16 09:45caristuTriggers an Emergency Pack => No
2014-07-16 09:45caristuIssue Monitored: networkb
2014-07-16 10:46caristuSummaryError 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:46caristuDescription Updatedbug_revision_view_page.php?rev_id=6068#r6068
2014-07-16 10:50caristuResolution time => 1411596000
2014-07-16 10:50caristuPriorityimmediate => high
2014-07-16 10:50caristuversionPR14Q2.3 => pi
2014-07-16 10:50caristuTarget Version => PR14Q4
2014-08-04 08:31shankarbAssigned ToAugustoMauch => shankarb
2014-08-04 08:47shankarbReview Assigned To => AugustoMauch
2014-08-04 08:48shankarbIssue Monitored: AugustoMauch
2014-08-04 08:49hgbotCheckin
2014-08-04 08:49hgbotNote Added: 0069056
2014-08-04 08:49hgbotStatusnew => resolved
2014-08-04 08:49hgbotResolutionopen => fixed
2014-08-04 08:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9ca3a8d726f58548b005750b361159d82f2b21e8 [^]
2014-08-07 09:45AugustoMauchNote Added: 0069110
2014-08-07 09:45AugustoMauchStatusresolved => closed
2014-08-07 09:45AugustoMauchFixed in Version => 3.0PR14Q4
2014-08-08 18:54hudsonbotCheckin
2014-08-08 18:54hudsonbotNote Added: 0069256

Notes
(0069056)
hgbot   
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   
2014-08-07 09:45   
Code reviewed and verified in pi@9ca3a8d726f5
(0069256)
hudsonbot   
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