Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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

0 votes


Be the first one to answer this question!

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,952

Question asked: Jun 05 '18, 9:31 p.m.

Question was seen: 836 times

Last updated: Jun 05 '18, 9:31 p.m.

Confirmation Cancel Confirm