How to get multiple result set using executeStoredProcedureForQuery

Hi Bhushan, great question, the key thing is that a!executeStoredProcedureForQuery() doesn’t automatically paginate or split one large dataset into multiple result sets; it simply returns whatever result sets your stored procedure produces, up to the limits you’ve configured (e.g., max 1,000 rows per result set and a max total of ~10,000 rows). So to get 10 separate sets of 1,000 rows, your stored procedure really needs to be written to return multiple result sets or support pagination/offset so you can loop calls in Appian and stitch the outputs together. You can raise conf.executeStoredProcedure.limits.maxTotalRows above 10K in custom.properties, but be cautious, Appian’s built-in limits are there for performance reasons and increasing them significantly can impact the system. See a related community discussion here: https://community.appian.com/discussions/f/visit-appian-community-edition/29068/executestoredprocedureforquery

Hi Bhushan, great question, the key thing is that a!executeStoredProcedureForQuery() doesn’t automatically paginate or split one large dataset into multiple result sets; it simply returns whatever result sets your stored procedure produces, up to the limits you’ve configured (e.g., max 1,000 rows per result set and a max total of ~10,000 rows). So to get 10 separate sets of 1,000 rows, your stored procedure really needs to be written to return multiple result sets or support pagination/offset so you can loop calls in Appian and stitch the outputs together. You can raise conf.executeStoredProcedure.limits.maxTotalRows above 10K in custom.properties, but be cautious, Appian’s built-in limits are there for performance reasons and increasing them significantly can impact the system. See a related community discussion here: https://community.appian.com/discussions/f/visit-appian-community-edition/29068/executestoredprocedureforquery