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