I am studying plug-in - Download DataSubset (On-Premise) to export data from sai

alvinc over 8 years ago

I am studying plug-in - Download DataSubset (On-Premise) to export data from sail form to excel.
Found that the input of rule: getdatasubsetdownloadlinkfromrule() must be rules that return the exportable datasubet.

My question is: On a sail form, there is a edit section that allow user to update some fields within datasubset. I am not able to get the latest data if i use rule to retrieve data from database. How could I export the on-screen data(CDT) to an excel?

Please help! Million thanks!!

Discussion posts and replies are publicly visible

0 alvinc over 8 years ago

Anyone can help ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Robert Shankin
Appian Employee
over 8 years ago

In order to edit the datasubset in a SAIL form, you could configure a form with an editable grid that loads the original data.
A user could edit the values in the grid as needed.
In the saveInto for the submit button, try something like
...
saveInto:{
a!save(ri!newDatasubset, local!newDatasubset),
a!save(ri!cancel,false)
}
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tom Ryan
Appian Employee
over 8 years ago

The function getdatasubsetdownloadlinkfromrule() needs to take a rule that returns a datasubset, it doesn't need to pull the data from a database. For example, you could have the SAIL form editing the datasubset, and save the new datasubset into a process variable, and then define a rule that returns the process variable you have just created. The download link for the excel document would have to be on the second form of a wizard. This doesn't seem like a particularly elegant solution, but from my understanding the plugin is not really designed to return form data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel