download excel report from temporary community document folder to local drive

sudhirp712 over 7 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 payalg
Certified Lead Developer
over 7 years ago

Download data to excel from report using Export to excel , There are different-different function in Cloud and On-Premise environment.

1. If environment is Cloud then use this function getdatasubsetdownloadlinkfromprocess().

2. If environment is On-premise then use this function getdatasubsetdownloadlinkfromrule().

Please refer this link :- forum.appian.com/.../Download_DataSubset_Plugin.html

Note:- When we use expression plugin getdatasubsetdownloadlinkfromprocess(processModelUuid,input) to add export link in SAIL interface,if the dynamic value that we pass as a parameter to the expression plugin character length is more than 1417 then link will not be generated, So while passing text data to input attribute we should pass limited data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 payalg
Certified Lead Developer
over 7 years ago

Download data to excel from report using Export to excel , There are different-different function in Cloud and On-Premise environment.

1. If environment is Cloud then use this function getdatasubsetdownloadlinkfromprocess().

2. If environment is On-premise then use this function getdatasubsetdownloadlinkfromrule().

Please refer this link :- forum.appian.com/.../Download_DataSubset_Plugin.html

Note:- When we use expression plugin getdatasubsetdownloadlinkfromprocess(processModelUuid,input) to add export link in SAIL interface,if the dynamic value that we pass as a parameter to the expression plugin character length is more than 1417 then link will not be generated, So while passing text data to input attribute we should pass limited data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data