Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010598Openbravo ERPA. Platformpublic2009-09-14 20:592009-10-13 07:47
Reportershuehner 
Assigned Toshuehner 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP10 
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
Summary0010598: 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
blocks defect 0010597 closed shuehner WindowTree_data.xsql has sql errror in optional parameter (uses ar table alias which is not defined in from clause) 
Attached Filesdiff 10598.diff (872) 2009-09-14 21:01
https://issues.openbravo.com/file_download.php?file_id=1751&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-09-14 20:59shuehnerTypedefect => backport
2009-09-14 20:59shuehnerfix_in_branch => 2.40
2009-09-14 21:01shuehnerFile Added: 10598.diff
2009-09-15 19:50hgbotCheckin
2009-09-15 19:50hgbotNote Added: 0020097
2009-09-15 19:50hgbotStatusscheduled => resolved
2009-09-15 19:50hgbotResolutionopen => fixed
2009-09-15 19:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^]
2009-09-29 12:02hgbotCheckin
2009-09-29 12:02hgbotNote Added: 0020437
2009-09-29 12:02hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^]
2009-10-13 07:47arunkumarStatusresolved => closed
2009-10-13 07:47arunkumarNote Added: 0020949
2009-10-13 07:47arunkumarFixed in Version => 2.40MP10

Notes
(0020097)
hgbot   
2009-09-15 19:50   
Repository: erp/stable/2.40
Changeset: bd212c0c3a29c202204178fdf44ea67c95139068
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Sep 15 19:50:27 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^]

Fixed 10598: Fix sql error in optional parameter

---
M src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
---
(0020437)
hgbot   
2009-09-29 12:02   
Repository: erp/stable/2.40_pageddatagrid
Changeset: bd212c0c3a29c202204178fdf44ea67c95139068
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Sep 15 19:50:27 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/bd212c0c3a29c202204178fdf44ea67c95139068 [^]

Fixed 10598: Fix sql error in optional parameter

---
M src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
---
(0020949)
arunkumar   
2009-10-13 07:47   
Tested & Working fine.