Limited number of records in executeSql: /home/Support/LabKey Support Forum

Limited number of records in executeSql

LabKey Support Forum

View Message

Limited number of records in executeSql

zoya_pasha

2018-07-20 02:00

Status: Closed

Hello,

I am using JavaScript API of Labkey 17.1. On using the function LABKEY.Query.executeSql, I am able to fetch records up to 100000. I checked the documentation. The default value for the same is 'All rows'. However, the maximum number of rows I am able to get in one transaction is limited. Please help!

Regards
Zoya

Jon (LabKey DevOps) responded:	2018-07-27 09:59
Hi Zoya, You should be able to dictate a larger value by using the maxRows option within your LABKEY.Query.executeSql command: https://www.labkey.org/download/clientapi_docs/javascript-api/symbols/LABKEY.Query.html#.executeSql Without dictating a value, we do default at 100,000 rows. Regards, Jon