Export to Excel

@rajivr, AFAIK it is the only one approach for exporting the data in excel through batches..

I am also face the same issue.so I am exporting through batches only.

let see other mates comments..

@Rajiv As we have tested this just an hour ago, we are successfully able to export more than 3 lakhs records into excel with 2-4 seconds, the table consist of 10 columns and expecting it to export till 10 lakhs rows at a time as per this scenario

Thats a good news. Can you please tell me how you did it @Alok Singh?

First of all, I inserted more than 3 lakhs rows in a table using java in loop, once it's got over, I used SQL to Excel smart service by passing the query as select * from tableName , and when I started the process execution, I found within 3 to 4 second the flow got moved forward and at the next node I.e. User Input Task I configured to download the generated document, I found it was containing more than 3 lakhs four thousand rows.

Thanks a lot. I did not try the above smart service yet. I had tried getdatasubsetdownloadlinkfromrule(rule, input) which is not a good option if more number of records has to be exported. Let me try this smart service.

yes it worked out ! The smart service is able to do this.

Nice to see that, it worked :)

@Alok We have tempo reports and can run a process from link using a!startProcess which includes SQL to Excel smart service to export data, but in reports we would not be able to show a User Input Task to provide a download link of created document. Is there any way(a smart service/expression function) which can be included in process model that would directly download the file, same as export to datasubset does.

Thanks in advance!

@chitrarekhas not sure but we can try following:

1) Make the report drillable
2) On drill call an interface which will invoke a web-api on load() (using Expression Rule)
3) Use this Web-API to invoke a process model
4) create 2 parameterized process variable, one for, where condition input for SQL as drillable and another as Integer for returning DocumentID

5) Use Export SQL to Excel Smart Service
6) get the generated Document ID as Response
7) and populate the document using toDocument(documentId) under the above Interface (Which appeared on drilldown)
8) Use the above document under documentDownloadLink

Have a try on this, hope this will work out, please let me know whether this worked or not

Thanks

Thanks Alok!, I have created a web API and it's returning the newly created doc ID. Would you please let me know how should I invoke that API using Expression rule. I tried calling calling using httpQuery() but it does not return doc id in its repsonse.

Thanks again!