DFC to download the workitems/attachments of the workflow

S.Thilahi

Can any one let us know how to download workitems/attachements of the workflow using dfc.

i am using the below query to get attachment id's and i want to save those attachments in to local machine.

select item_id from dmi_queue_item where name='****' and (task_state='dormant' or task_state='acquired')

Thanks in advance

Find more posts tagged with

Comments

mpraditt

Thanks for you question, someone will send a reply soon. Good luck!

astone

Hi, try this:

IDfSysObject srcSysObject = null;

IDfWorkflow wf = (IDfWorkflow)sess.getObject(new DfId(id_wf));

IDfCollection col = wf.getAttachments();

while (col.next()){

String docId = col.getString("r_component_id");

srcSysObject = (IDfSysObject) sess.getObject(new DfId(docId));

ByteArrayInputStream bais = srcSysObject.getContent();

if (bais.available() > 0){

//change this for your documents

OutputStream outputStream = new FileOutputStream ("c:/x/a.pdf"); //your configuration for save

bais.writeTo(outputStream);

}

Best regards!

manishanandswami

private IDfSysObject getPackage() {

IDfSysObject packageComponentObject = null;

IDfCollection idfCollection = null;

IDfSysObject dfSysObject =null

try {

IDfQueueItem idfqueueitem = (IDfQueueItem) getDfSession().getObject(new DfId(m_taskId));

m_workItemId = idfqueueitem.getItemId();

workItemObject = ((IDfWorkitem) getDfSession().getObject(m_workItemId));

idfCollection = workItemObject.getPackages(null);

while (idfCollection.next()) {

IDfPackage dfPackage = (IDfPackage) getDfSession().getObject(

new DfId(idfCollection.getString("r_object_id")));

String packageName = dfPackage.getPackageName();

log.debug(MessageFormat.format("packagename = {0}", packageName));

if (packageName.equalsIgnoreCase(this.packageName)) {

= (IDfSysObject) getDfSession().getObject(dfPackage.getComponentId(0));

}

} catch (DfException e) {

log.error(e);

throw new WrapperRuntimeException(e);

}

finally {

DQLHelper.cleanup(idfCollection);

}

log.debug(MessageFormat.format("projectCode = {0}", projectCode));

return dfSysObject

}

It will return you the attached package java ByteArray InputStream u can get the content