Openbravo Issue Tracking System - Openbravo ERP  | 
| View Issue Details | 
  | 
| ID | Project | Category | View Status | Date Submitted | Last Update | 
| 0010597 | Openbravo ERP | A. Platform | public | 2009-09-14 20:59 | 2009-10-06 11:24 | 
  | 
| Reporter | shuehner |   | 
| Assigned To | shuehner |   | 
| Priority | high | Severity | minor | Reproducibility | have not tried | 
| Status | closed | Resolution | fixed |   | 
| Platform |  | OS | 5 | OS Version |  | 
| Product Version | 2.40 |   | 
| Target Version |  | Fixed in Version | 2.50MP6 |   | 
| Merge Request Status |  | 
| Review Assigned To |  | 
| OBNetwork customer | No | 
| Web browser |  | 
| Modules | Core | 
| Support ticket |  | 
| Regression level |  | 
| Regression date |  | 
| Regression introduced in release |  | 
| Regression introduced by commit |  | 
| Triggers an Emergency Pack | No | 
  | 
| Summary | 0010597: WindowTree_data.xsql has sql errror in optional parameter (uses ar table alias which is not defined in from clause) | 
| Description | This 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 |  | 
| Tags | No 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 Files |   10597.diff (852) 2009-09-14 21:00 https://issues.openbravo.com/file_download.php?file_id=1750&type=bug | 
  | 
| Issue History | 
| Date Modified | Username | Field | Change | 
| 2009-09-14 20:59 | shuehner | New Issue |  | 
| 2009-09-14 20:59 | shuehner | Assigned To |  => rafaroda | 
| 2009-09-14 20:59 | shuehner | OBNetwork customer |  => No | 
| 2009-09-14 20:59 | shuehner | Assigned To | rafaroda => shuehner | 
| 2009-09-14 20:59 | shuehner | Status | new => scheduled | 
| 2009-09-14 20:59 | shuehner | fix_in_branch |  => pi | 
| 2009-09-14 21:00 | shuehner | File Added: 10597.diff |  | 
| 2009-09-14 21:01 | shuehner | Relationship added | blocks 0004038 | 
| 2009-09-15 19:48 | hgbot | Checkin |  | 
| 2009-09-15 19:48 | hgbot | Note Added: 0020096 |  | 
| 2009-09-15 19:48 | hgbot | Status | scheduled => resolved | 
| 2009-09-15 19:48 | hgbot | Resolution | open => fixed | 
| 2009-09-15 19:48 | hgbot | Fixed in SCM revision |  => http://code.openbravo.com/erp/devel/pi/rev/df31c039af19f6cedbb45bf013a4f3114f4e13d5 [^] | 
| 2009-09-18 13:29 | psarobe | Status | resolved => closed | 
| 2009-09-18 13:29 | psarobe | Fixed in Version |  => 2.50MP6 | 
| 2009-09-19 00:00 | anonymous | sf_bug_id | 0 => 2861740 | 
| 2009-09-29 14:12 | hgbot | Checkin |  | 
| 2009-09-29 14:12 | hgbot | Note Added: 0020469 |  | 
| 2009-09-29 14:12 | hgbot | Status | closed => resolved | 
| 2009-09-29 14:12 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/df31c039af19f6cedbb45bf013a4f3114f4e13d5 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/df31c039af19f6cedbb45bf013a4f3114f4e13d5 [^] | 
| 2009-10-06 11:24 | psarobe | Status | resolved => closed | 
| 2009-10-06 11:24 | psarobe | Note Added: 0020756 |  |