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 Jan 15, 2019 by eric.oneal_LWC

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