I have to convert a data table fetched from database into csv format and user should be download this csv file. How will i be able to do that
Hello,
You have two possibilities.
1/ create the CSV in a connector (or a Groovy connector) and save it in a Bonita Document. For the user, use a Download to get the information.
==> More code to do
Document to save in the process variable
more robust if the list is big
2/ via a REST API, produce the value on the form, then use the ALASQL widget: user can collect the information from the browser
https://community.bonitasoft.com/project/widgetalasqloperation
Ps: in this option, you saved the information in a Process Variable (List of Map), then use the REST API Context to get this information to the browser
https://community.bonitasoft.com/project/restapicontext
==> easiest
Attention, if the number of records is over 500, the REST API needs time to get all theses information to the browser, and the browser should not display a such big list. So, you have to use the first options
PS: a video explaining how to use the REST API CONTEXT : https://youtu.be/M9Y8xaHZFRo
Best,