topic Re: Display Files attached in previous Process Instances in Alfresco Forum

Display Files attached in previous Process Instances

gbanks — Mon, 10 Jul 2017 19:25:54 GMT

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 proce

Re: Display Files attached in previous Process Instances

cjose — Mon, 10 Jul 2017 20:59:44 GMT

Could you please confirm if you are using the Enterprise version of the Activiti or the community version?

Re: Display Files attached in previous Process Instances

gbanks — Mon, 10 Jul 2017 21:05:49 GMT

Enterprise

Re: Display Files attached in previous Process Instances

cjose — Mon, 10 Jul 2017 21:24:22 GMT

Check if these APIs are of any help? Content | Alfresco Documentation

Re: Display Files attached in previous Process Instances

gbanks — Mon, 10 Jul 2017 21:39:32 GMT

Using this API I'm able to GET the details about the documents (ID, name, etc). However, if I try to map the ID to a variable and then use Display Value id_variable in a form, it shows up empty. How do I then display the file?

Re: Display Files attached in previous Process Instances

cjose — Mon, 10 Jul 2017 21:46:29 GMT

It can be solved in few different ways. Are you able to share a prototype of what you trying to do? If you want to get the actual file itself, you need to invoke the following API with the ID you get from the RELATED_CONTENT table

GET api/enterprise/content/{contentId}/raw

Re: Display Files attached in previous Process Instances

gbanks — Mon, 10 Jul 2017 21:52:53 GMT

Alright so I've used that call and get "Response message: could not parse response to JSON: %PDF-1.7" How then am I able to map the PDF to a variable/ display it to the user in a form?

Re: Display Files attached in previous Process Instances

cjose — Mon, 10 Jul 2017 22:56:06 GMT

Like I said above, please provide a prototype of your solution so that I

can better help you.

Re: Display Files attached in previous Process Instances

gbanks — Tue, 11 Jul 2017 14:55:09 GMT

Here is a prototype. I have removed the endpoint address.

Re: Display Files attached in previous Process Instances

cjose — Tue, 11 Jul 2017 20:39:14 GMT

For some reason I cannot download it! Can you attach it in this thread? You can do attachments using the advanced editor. Also, please export the whole app including any forms you have in your prototype

Ciju

Re: Display Files attached in previous Process Instances

gbanks — Tue, 11 Jul 2017 20:43:20 GMT

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

Re: Display Files attached in previous Process Instances

cjose — Tue, 11 Jul 2017 20:51:16 GMT

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.

Re: Display Files attached in previous Process Instances

gbanks — Tue, 11 Jul 2017 21:17:51 GMT

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

Re: Display Files attached in previous Process Instances

cjose — Tue, 11 Jul 2017 21:42:50 GMT

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-examples · GitHub.

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!

Re: Display Files attached in previous Process Instances

gbanks — Wed, 12 Jul 2017 13:45:15 GMT

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.

Re: Display Files attached in previous Process Instances

cjose — Wed, 12 Jul 2017 13:48:34 GMT

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

Re: Display Files attached in previous Process Instances

gbanks — Wed, 12 Jul 2017 14:13:47 GMT

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

Re: Display Files attached in previous Process Instances

cjose — Wed, 12 Jul 2017 15:02:52 GMT

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.

Re: Display Files attached in previous Process Instances

gbanks — Wed, 12 Jul 2017 15:26:33 GMT

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?

Re: Display Files attached in previous Process Instances

cjose — Wed, 12 Jul 2017 15:31:44 GMT

See if you are able to import the attached app. I manually modified to make it compatible with 1.5