Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0017143Openbravo ERPA. Platformpublic2011-05-12 13:532011-05-13 18:49
psarobe 
shuehner 
immediatemajoralways
closedfixed 
5
pi 
3.0RC73.0RC7 
Core
No
0017143: When you enter into the Employee Expense it is not showing anything when it should
This is the error in the log:

b3e0edee 13:44:54 [http-8080-7] ERROR org.openbravo.client.kernel.ComponentGenerator - Error parsing component View
>>>>>>> Issues found in javascript <<<<<<<<<
Core.View:1775:176: Unexpected '\'. >> offending code: whereClause: 'e in (select t1.businessPartner from TimeAndExpenseSheet as t1, TimeAndExpenseSheetLine as t2 where t1=t2.timeSheet and t1.processed=\'Y\' and t2.timeSheet<\>\'Y\' and t2.invoiceLine is null))',
>>>>>>> Issues (1966ms) <<<<<<<<<


Take into account that there is "clause where" in the tab
1. Create a expense sheet and process (time sheet='N')
2. Go to Employee Expense
No tags attached.
Issue History
2011-05-12 13:53psarobeNew Issue
2011-05-12 13:53psarobeAssigned To => shuehner
2011-05-12 13:53psarobeModules => Core
2011-05-12 17:37hgbotCheckin
2011-05-12 17:37hgbotNote Added: 0036912
2011-05-12 17:37hgbotStatusnew => resolved
2011-05-12 17:37hgbotResolutionopen => fixed
2011-05-12 17:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fa4d6a6b3d7d87947abfbffca7bed35f6e7e9fb7 [^]
2011-05-13 06:23hudsonbotCheckin
2011-05-13 06:23hudsonbotNote Added: 0036943
2011-05-13 18:49psarobeNote Added: 0036984
2011-05-13 18:49psarobeStatusresolved => closed
2011-05-13 18:49psarobeFixed in Version => 3.0RC7

Notes
(0036912)
hgbot   
2011-05-12 17:37   
Repository: erp/devel/pi
Changeset: fa4d6a6b3d7d87947abfbffca7bed35f6e7e9fb7
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu May 12 17:36:54 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/fa4d6a6b3d7d87947abfbffca7bed35f6e7e9fb7 [^]

Fixed 17143: fixed hql where clause in two tabs
- Employee Expense
- Invoiceable Expenses
in both tabs the conversion from sql-whereclause -> hql-whereclause introduced
some bug which this cset fixes.

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0036943)
hudsonbot   
2011-05-13 06:23   
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/d221ad9e329e [^]

Maturity status: Test
(0036984)
psarobe   
2011-05-13 18:49   
Works fine