It's all about the answers!

Ask a question

What is the correct format of query for dataset of jazz datasource.


YuanYou Yin (233) | asked Jun 05 '18, 9:31 p.m.

When I edit the Property Binding of dataset ,in the textarea of querytext,I input the following content:

var query = " SELECT PROJECT_AREA_ITEMID,STATE_NAME,TIMESTAMP,WI_COUNT "; 
query += " FROM WORKITEM_STATES WHERE 1=1";
this.text = query;

But,there is the following error:

  Plugin・Provider :Eclipse.org
  PluginName:BIRT Data Engine
  Plugin ID:org.eclipse.birt.data
  Version:2.6.2.r262_v20110215
  ErrorCode:data.engine.fail.prepareExecution
  ErrorMessage:Failed to prepare the query execution for the data set: WorkItemStatesFromWorkItems1
Failed to prepare the following query for the data set type (com.ibm.team.reports.generic.dataSet).
[ SELECT PROJECT_AREA_ITEMID,STATE_NAME,TIMESTAMP,WI_COUNT  FROM WORKITEM_STATES WHERE 1=1]
    org.eclipse.datatools.connectivity.oda.OdaException: nearby SELECT PROJECT_AREA_ITEMID  syntax parsing error

RTC6.0.2

BIRT2.6.2

Be the first one to answer this question!


Register or to post your answer.