I've tried using the query.num property but that only works for hosted arcgis.com services. I've also looked into enabling pagination on the map service so that I can specify a query.resultRecordCount property, but it looks like that won’t be possible (https://community.esri.com/thread/118631) with a file geodatabase back end. Also no support for a SELECT TOP … SQL query on file geodatabases. I could limit the "Maximum Number of Records Returned by Server" on the service properties, but this would require a whole new service because I need to return all records for display on the map (Not an elegant solution).
var topTenQuery = new Query(); topTenQuery.returnGeometry = false; //topTenQuery.where = "ACCRATE > 0 limit 10"; // causes error //topTenQuery.where = "ACCRATE IN (SELECT TOP 10 ACCRATE FROM [featureLayer])"; // causes error topTenQuery.outFields = ['OBJECTID', 'RDNAME', 'ACCRATE']; topTenQuery.orderByFields = ['ACCRATE DESC']; //topTenQuery.resultRecordCount = 10; //causes error because pagination is not enabled featureLayer.queryFeatures(topTenQuery, resultsHandler);
Thanks for any help!