Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010597Openbravo ERPA. Platformpublic2009-09-14 20:592009-10-06 11:24
Reportershuehner 
Assigned Toshuehner 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50MP6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010597: WindowTree_data.xsql has sql errror in optional parameter (uses ar table alias which is not defined in from clause)
DescriptionThis file (in 2.40 and 2.50) defines the following optional parameter:

<Parameter name="editable" optional="true" type="none" after="WHERE " text="tn.IsActive='Y' AND ar.isActive='Y' AND "/>

However the ar table alias is not defined in the FROM clause.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0010598 closed shuehner WindowTree_data.xsql has sql errror in optional parameter (uses ar table alias which is not defined in from clause) 
blocks defect 0004038 closed shuehner Slow compilation in sqlC part due to high amount of data 
Attached Filesdiff 10597.diff (852) 2009-09-14 21:00
https://issues.openbravo.com/file_download.php?file_id=1750&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-09-14 20:59shuehnerNew Issue
2009-09-14 20:59shuehnerAssigned To => rafaroda
2009-09-14 20:59shuehnerAssigned Torafaroda => shuehner
2009-09-14 20:59shuehnerStatusnew => scheduled
2009-09-14 20:59shuehnerfix_in_branch => pi
2009-09-14 21:00shuehnerFile Added: 10597.diff
2009-09-14 21:01shuehnerRelationship addedblocks 0004038
2009-09-15 19:48hgbotCheckin
2009-09-15 19:48hgbotNote Added: 0020096
2009-09-15 19:48hgbotStatusscheduled => resolved
2009-09-15 19:48hgbotResolutionopen => fixed
2009-09-15 19:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/df31c039af19f6cedbb45bf013a4f3114f4e13d5 [^]
2009-09-18 13:29psarobeStatusresolved => closed
2009-09-18 13:29psarobeFixed in Version => 2.50MP6
2009-09-19 00:00anonymoussf_bug_id0 => 2861740
2009-09-29 14:12hgbotCheckin
2009-09-29 14:12hgbotNote Added: 0020469
2009-09-29 14:12hgbotStatusclosed => resolved
2009-09-29 14:12hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/df31c039af19f6cedbb45bf013a4f3114f4e13d5 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/df31c039af19f6cedbb45bf013a4f3114f4e13d5 [^]
2009-10-06 11:24psarobeStatusresolved => closed
2009-10-06 11:24psarobeNote Added: 0020756

Notes
(0020096)
hgbot   
2009-09-15 19:48   
Repository: erp/devel/pi
Changeset: df31c039af19f6cedbb45bf013a4f3114f4e13d5
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Sep 15 19:48:04 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/df31c039af19f6cedbb45bf013a4f3114f4e13d5 [^]

Fixed 10597: Fixed sql error in optional parameter

---
M src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
---
(0020469)
hgbot   
2009-09-29 14:12   
Repository: erp/devel/pi-pageddatagrid
Changeset: df31c039af19f6cedbb45bf013a4f3114f4e13d5
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Sep 15 19:48:04 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/df31c039af19f6cedbb45bf013a4f3114f4e13d5 [^]

Fixed 10597: Fixed sql error in optional parameter

---
M src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
---
(0020756)
psarobe   
2009-10-06 11:24   
Closed again because hudson has reopened without no reason