Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017143Openbravo ERPA. Platformpublic2011-05-12 13:532011-05-13 18:49
Reporterpsarobe 
Assigned Toshuehner 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0RC7Fixed in Version3.0RC7 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017143: When you enter into the Employee Expense it is not showing anything when it should
DescriptionThis 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
Steps To Reproduce1. Create a expense sheet and process (time sheet='N')
2. Go to Employee Expense
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-05-12 13:53psarobeNew Issue
2011-05-12 13:53psarobeAssigned To => shuehner
2011-05-12 13:53psarobeModules => Core
2011-05-12 13:53psarobeOBNetwork customer => No
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