Hi i am try to get al activity asociates
If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.
Hi,
select * from dmi_workitem where r_runtime_state in (0,1) and r_workflow_id='yourworkflowid'
This dql lists your workflows dormant and acquired workitems. If workitems can be suspended, then take into account that too.
You should get a copy of Server Object Reference PDF.
My Code, hope it will be helpful
IDfWorkflowEx wfe = ( IDfWorkflowEx ) session.getObject(id);
String dql = "select * from dmi_workitem_s where r_runtime_state in (0,1) and r_workflow_id='" + wfe.getProcessId() + "'";
IDfEnumeration objectsByQuery = session.getObjectsByQuery( dql , "dmi_workitem" );
IDfWorkitemEx wiEx = new DfWorkitemEx();
if ( objectsByQuery.hasMoreElements() ) {
wiEx = (IDfWorkitemEx) objectsByQuery.nextElement();
}
Thank's, for all support.