Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0027094
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2014-07-16 09:452014-08-08 18:54
ReportercaristuView Statuspublic 
Assigned Toshankarb 
PriorityhighResolutionfixedFixed in Version3.0PR14Q4
StatusclosedFix in branchFixed in SCM revision9ca3a8d726f5
ProjectionnoneETAnoneTarget Version3.0PR14Q4
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027094: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  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 (manager)
2014-08-07 09:45

Code reviewed and verified in pi@9ca3a8d726f5
(0069256)
hudsonbot (developer)
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

- 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 Modules => Core
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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker