Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Hi Community,
Trying to replace store proc. plugin with executeStoredProcedureForQuery, But due to limitation it results only 1000 rows in one result set.
As per the documentation a!executeStoredProcedureForQuery() Function - Appian 25.3,
I have modified custome.proerties file with below settings but still not sure how I should get 10 result set with 1000 rows in each?
conf.executeStoredProcedure.limits.maxRowsPerResultSet=1000
conf.executeStoredProcedure.limits.maxTotalRows=10000
Do I need to change store proc to get multiple result set?
can we increases more that 10K records using conf.executeStoredProcedure.limits.maxTotalRows configuration?
Thanks in advance.
Bhushan
Discussion posts and replies are publicly visible
Given the limitation the workaround is to loop through the store procedure to return all the data. As per Appian recommendation even the 10k max limit, if applied, should be applied cautiously as it can impact performance. So suggest you to use the limit and offset in sql code of your store procedure and batch the dataset in a loop to fetch entire dataset.