Query Result Set Limited to 1000

How are you querying the data, i mean using QueryEntity, QueryRule or smart service. However i don't think it's a good idea of fetching 1000 rows at a time, instead of this we can perform Batching to increase the performance. the URL mention by ChristineH is very useful in your scenario.

Thanks everyone -

In our scenario we needed all the results - as the result set was used to populate a drop down list for product selection.

There exists a configuration option to set set Row Return Limits - which is defaulted to 1,000 - This is what changed from Appian 6 to Appian 7 for us.

 

Row Return Limits for the Query Database Smart Service

The data that is returned by the Query Database Smart Service only includes a maximum of ten rows of data (1,000 rows for Appian Cloud users).

To configure Appian to read additional rows of data from a database query, complete the following:

1. Edit (or create) <APPIAN_HOME>/ear/suite.ear/conf/custom.properties.

2. Adjust the number of rows of data returned by changing the resources.appian.process.application.arv.limit=10 property to arv.limit=<desired-number>.

 

https://docs.appian.com/suite/help/17.1/Configuring_Relational_Databases.html#row-return-limits-for-the-query-database-smart-service

 

We adjusted the arv.limit, restarted Appian and were good to go ;)

Thanks everyone -

In our scenario we needed all the results - as the result set was used to populate a drop down list for product selection.

There exists a configuration option to set set Row Return Limits - which is defaulted to 1,000 - This is what changed from Appian 6 to Appian 7 for us.

 

Row Return Limits for the Query Database Smart Service

The data that is returned by the Query Database Smart Service only includes a maximum of ten rows of data (1,000 rows for Appian Cloud users).

To configure Appian to read additional rows of data from a database query, complete the following:

1. Edit (or create) <APPIAN_HOME>/ear/suite.ear/conf/custom.properties.

2. Adjust the number of rows of data returned by changing the resources.appian.process.application.arv.limit=10 property to arv.limit=<desired-number>.

 

https://docs.appian.com/suite/help/17.1/Configuring_Relational_Databases.html#row-return-limits-for-the-query-database-smart-service

 

We adjusted the arv.limit, restarted Appian and were good to go ;)