Display Files attached in previous Process Instances

[gbanks]

Given a Process Instance ID OR ContentId, I need to be able to display to the user in a downloadable format all files attached during that workflow. These files are being stored as BLOBs in an Oracle database table. Is there a way I can display these files to the user following a query of that process instance ID? The "link" column of this table is empty.

[gbanks]

Ok I have attached it. Thank you for your diligence, Ciju

[sekharbpm]

Hi Ciju,

does the community version stores the attached file in ACT_HI_ ATTACHMENT db ?

Regards,

sekhar

[cjose]

Looks like you are complicating this. You don't have to do any of that if all you trying to do is display a previously selected attachment. Please find attached a modified version where you can use display value field to select an attachment.

[gbanks]

I'm trying to display a document attached in a previous process instance, not the current one

[cjose]

It is best to be done using the Java APIs associated with related contents. You can refer to an example at activiti-examples/activiti-copy-attachments-from-parent-process at master · cijujoseph/activiti-exam....

If it is one or two files, using the url field field is an option too. Please find attached an example showing how to do it. to run this example, you need to know the content id which you can obtain using rest apis.

Hope this helps. Also, when asking questions, it would be great if you can provide as much details as you can at the beginning including some attachments like unit tests, prototypes etc which will help save time!

[gbanks]

Ciju, this still does not resolve my issue. The processes would not be related in any way; there is no parent-child relationship. I basically need to create a search engine where a user can find/download ANY content that has been uploaded in an entirely different process.

[cjose]

Understood. I was just showing an example of how to use the JAVA APIs. You will have to write your logic based on your needs.

Ciju

[gbanks]

I am unable to import your app, I see the error 
"Error while processing the app definition file : Could not deserialize form definition "

[cjose]

Are you using a version older than 1.6? I created the app in 1.6.3 and if you are using one of the older versions (1.5.x or below) you may get this error.

[gbanks]

As I am unable to view your example, would you mind explaining what you have done? I understand I perform an API call to retrieve the file using its contentId. When I have done this, it returns the raw file in a way that does not let me map it to a variable which I can then display in another form. How do I get from the API call to being able to view/download the file?