When using “a!queryEntity()”, what should the batchSize be set to in a!pagingInfo() in order to return all the items from a query?
When using “a!queryEntity()”, what should the batchSize be set to in a!pagingInfo() in order to return all the items from a query?
In a!queryEntity(), setting the batchSize to -1 in a!pagingInfo() will return all items from the query result. This is the designated value to retrieve every item without limiting the number of returned records.
hen using "a!queryEntity()" to execute a query, the "batchSize" parameter in the "a!pagingInfo()" function should be set to a value greater than or equal to the maximum number of items that can be returned by the query. To return all the items from a query, you can set the "batchSize" parameter to a large number, such as 1000 or more, depending on the size of your data. Setting the "batchSize" parameter to -1 or 0 is not valid and will result in an error. Setting the parameter to null is also not valid. Therefore C. 1000.
When the batch size is set to -1, will return all the items from the data store entity. This worls only in a!queryEntity() And setting the batch size to 0 will return the count of total items Refer the documentation below https://docs.appian.com/suite/help/21.4/fnc_system_a_paginginfo.html