0028863: Log error related to widget queries

Description

When defining widget queries, if we split select clause in different lines, although the query is executed correctly, an error is shown at openbravo log (Take a look at attached document with an example query and the error shown).

Steps To Reproduce

- Log in as System Administrator.
- Create a new widget (Widget window).
- Define the query that will execute that widget in order to show the information that we need.
- Take into account that, although the widget will be shown correctly (obviously if our query is defined in a correct way) the error mentioned before is shown at openbravo log and it should not.

Tags

No tags attached.

Attached Files

widgetQueryAndError [^] (1,926 bytes) 2015-02-04 14:32 [Show Content] [Hide Content]

QUERY:
------
select 
       tel.expenseSheet.documentNo as documentNo,
       tel.expenseSheet.id as expenseSheetId,
       tel.description as description,
       case when tel.expenseDate is not null then tel.expenseDate  else tel.expenseSheet.reportDate end as expenseDate,
       tel.product.id as productId,
       tel.product.name as productName,
       tel.quantity as quantity,
       tel.uOM.name as uomName,
       p.id as projectId,
       p.name as projectName,
       tel.expenseSheet.processed as processed
from
	TimeAndExpenseSheetLine as tel
	LEFT JOIN tel.project as p,
	ADUser as u
	where tel.timeSheet = 'Y'
	and tel.client.id=:client
	and tel.expenseSheet.businessPartner=u.businessPartner
	and u.id=:user
order by  tel.expenseSheet.reportDate, tel.expenseSheet.documentNo



------------------------------------------------
------------------------------------------------

ERROR AT OPENBRAVO.LOG:
-----------------------
7ef0fb8d 4487905 [http-8080-8] ERROR org.hibernate.hql.PARSER - line 1:32: unexpected token: select
7ef0fb8d 4487991 [http-8080-8] ERROR org.openbravo.service.datasource.DataSourceServlet - unexpected token: select near line 1, column 32 [select count(*), sum(quantity) select 
       tel.expenseSheet.documentNo as documentNo,
       tel.expenseSheet.id as expenseSheetId,
       tel.description as description,
       case when tel.expenseDate is not null then tel.expenseDate  else tel.expenseSheet.reportDate end as expenseDate,
       tel.product.id as productId,
       tel.product.name as productName,
       tel.quantity as quantity,
       tel.uOM.name as uomName,
       p.id as projectId,
       p.name as projectName,
       tel.expenseSheet.processed as processed
from
	TimeAndExpenseSheetLine as tel
	LEFT JOIN tel.project as p,
	ADUser as u
	where tel.timeSheet = 'Y'
	and tel.client.id=:client
	and tel.expenseSheet.businessPartner=u.businessPartner
	and u.id=:user]

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2015-02-04 14:32	daniOpenbravo	New Issue
2015-02-04 14:32	daniOpenbravo	Assigned To	=> AugustoMauch
2015-02-04 14:32	daniOpenbravo	File Added: widgetQueryAndError
2015-02-04 14:32	daniOpenbravo	OBNetwork customer	=> Yes
2015-02-04 14:32	daniOpenbravo	Modules	=> Query/List widget
2015-02-04 14:32	daniOpenbravo	Triggers an Emergency Pack	=> No
2015-02-09 12:18	jonalegriaesarte	Resolution time	=> 1429048800
2015-02-23 08:48	alostale	Status	new => acknowledged
2015-03-09 17:33	jonalegriaesarte	Resolution time	1429048800 =>
2015-03-17 14:38	alostale	Assigned To	AugustoMauch => platform
2022-02-01 08:05	alostale	Assigned To	platform => Triage Platform Base