Change in executeSql defaults?

LabKey Support Forum (Inactive)
Change in executeSql defaults? jdutra  2013-01-24 14:44
Status: Closed
 
We are testing labkey v12.3 on our development server. I have an executeSql query that retrieves 188 rows. In 12.2, it gives me all 188 rows, but in 12.3 it returns only the first 100, as if it is paging the data by default. The documentation says that the default is to return all rows, which is generally what I want so I have never used the maxRows parameter. I tried setting maxRows to 188 in my query in 12.3 and it works correctly again. Have you changed the default behavior? I have lots of executeSql queries that assume all rows are being returned by the server.

Thanks for your help,
- Jen
 
 
kevink responded:  2013-01-25 08:47
Hi Jen,

Yes, this is a regression in 12.3. We'll issue a fix for 12.3 shortly. Thanks for reporting the issue.

Kevin