download excel report from temporary community document folder to local drive

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.


OriginalPostID-255357



  Discussion posts and replies are publicly visible

Parents
  • You are almost there , the fix is simple. If you look at your "fieldNames" and data returned by your query rule ,the names doesn't match. For example WORKFLOWNAME, this "workFlowName" in data and "WorkFlowName" in fieldNames. These names should match ,of course you can have what ever descriptive names you wish in "fieldLabels". But "fieldNames" should have the exact name of the field in data
Reply
  • You are almost there , the fix is simple. If you look at your "fieldNames" and data returned by your query rule ,the names doesn't match. For example WORKFLOWNAME, this "workFlowName" in data and "WorkFlowName" in fieldNames. These names should match ,of course you can have what ever descriptive names you wish in "fieldLabels". But "fieldNames" should have the exact name of the field in data
Children
No Data