It's all about the answers!

Ask a question

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


YuanYou Yin (238) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.