AnsweredAssumed Answered

resultOffset & resultRecordCount Parameters are causing the query to return No records found

Question asked by Glitchy on Apr 5, 2018
Latest reply on May 7, 2018 by Jefairfi

setDefinitionExpression is including the resultOffset and resultRecordCount parameters that are causing the service query to return No records found.  If I make the same query without these parameters it returns records.

 

How can I eliminate these parameters from being added to the query when I set the definition expression? 

or

How can I get the service to return records with these parameters set?

 

resultOffset=0

resultRecordCount=1000

 

No records found query 

https://gis.maricopa.gov/arcgis/rest/services/Flo2d/Flo2d_Boundaries/MapServer/1/query?f=json&where=admp%20%3D%20%27121_… 

 

If I remove theses parameters &resultOffset=0&resultRecordCount=1000 then it returns the expected 72 records. 

https://gis.maricopa.gov/arcgis/rest/services/Flo2d/Flo2d_Boundaries/MapServer/1/query?f=json&where=admp%20%3D%20%27121_… 

 

Also of note if I change the where statement to 1=1 it will return all the records even with the resultOffset and resultRecordCount parameters

https://gis.maricopa.gov/arcgis/rest/services/Flo2d/Flo2d_Boundaries/MapServer/1/query?f=json&where=1=1&returnGeometry=t… 

Outcomes