Hi All,
I have a requirement where I need to query with 40k input and output will be 2x or 3x of that. I have passed the batchSize as 20 and fetchTotalCount as true. I need to display the data in grid and need to export all in a excel also. But I am getting a time out error. Is there any way I can query these number of data in UI. Please help us with your suggestions.
Regards,
Kavya
Discussion posts and replies are publicly visible
I have given a list of Batch Id values in a paragraph field and will click on the search button.In that we have code about the query Entity to query the results and storing in one rule input, which we will pass to grid rule as data parameter. Then the same rule input is passed as a process variable in the process flow and it is converted into a CDT structure and we will store the values in temp Table and export the data from temp table for that particular process Id. So upto 4k data we got the results but after that it is throwing time out error.
Error ss:
I would try to offload this data heavy process to a stored procedure in the database. Then show the results in a paged grid and allow the export directly from the database.
What do you mean by limitation in returning the data with stored pro endure?