download excel report from temporary community document folder to local drive

sudhirp712 over 8 years ago

Hi ,

We have created a process model which will extract the report from querydatabase and export it to excel and save it under temporary document folder in community section.

We need to add this to report tab in tempo page as XYZ Report. Users needs to click on XYZ Report and the excel generated report could be downloadable and save this to local drive.

Could anyone help us and let us know how to do it.

Attached the process model.

Discussion posts and replies are publicly visible

Parents

0 Sathya Srinivasan
Appian Employee
over 8 years ago

Can you not use a simple DocumentDownloadLink and point it to the PV of the Document that was generated by the process? If you want to get the LATEST version of the process variable, you should be able to run a simple queryProcessAnalytics() call on that process model, order by START DATE descending and take the output of the FIRST entry.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sathya Srinivasan
Appian Employee
over 8 years ago

Can you not use a simple DocumentDownloadLink and point it to the PV of the Document that was generated by the process? If you want to get the LATEST version of the process variable, you should be able to run a simple queryProcessAnalytics() call on that process model, order by START DATE descending and take the output of the FIRST entry.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data