How do I change default row limit value for query database node?

Question

We want to change the default limit of 10 rows for query database node to 1000 rows. Where can we make this configuration change? 
 OriginalPostID-204900 
 OriginalPostID-204900

nathan.schmitz · Accepted Answer

Changing Appian configurations for these types of purposes often indicates that you need to reconsider your overall approach. These limits are in Appian for a reason and you may run into more problems in the future should you use Appian for problems that it isn't intended to solve. With that in mind, you can update the resources.appian.process.application.arv.limit property in the custom.properties which should allow you to return more rows. Note that you'll need to test whether 1000 works since there is likely a hard limit for this configuration.