ArcGIS Server's Query - Returned w/ different records

ShaningYu

I tried 2 things:

1)  Run the code sourced from ESRI (see attached).  The query returned > 100 features and populated on the left pane's Grid.

2)  Go to the service site: http://trainingcloud.arcgis.com/arcgis/rest/services/Redlands_PointsOfInterest/MapServer/0, and run the query:   where:  NAME Like '%Redlands%'   Geometry Type:  Envelope   Out fields:  OBJECTID, NAME, Match_addr, TEL, TYPE   Spatialo relationship: Contains Or use the link  http://trainingcloud.arcgis.com/arcgis/rest/services/Redlands_PointsOfInterest/MapServer/0/query?where=NAME+Like+%27%25Redlands%25%27&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelContains&relationParam=&outFields=OBJECTID%2C+NAME%2C+Match_addr%2C+TEL%2C+TYPE&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&f=html which results in only 12 records.

Tried several times with the same results on both cases.  Can someone explain why?  Thanks.

My Template

Name	Address

Find Features

Created by J. Doe

Ex4.html.zip

nowork.jpg

JohannesLindner_9-1634021840233.png

RobertScheitlin__GISP

Shaning,

    no it was not attached when I replied.

The issue is initially when you run the code the results contain all features that intersect the maps view extent and when you run your query you are only looking for features that have 'Redlands' in its name.

I think your confusion is that you are seeing 'Redlands' in the in the Match_addr of the initial 100+ results and are expecting to see the same when you query.  If you change your query to  this then you will see results similar to what you are when you initially run the app:

http://trainingcloud.arcgis.com/arcgis/rest/services/Redlands_PointsOfInterest/MapServer/0/query?where=Match_addr+Like+%27%25Redlands%25%27&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelContains&relationParam=&outFields=OBJECTID%2C+NAME%2C+Match_addr%2C+TEL%2C+TYPE%2C+Match_addr&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&f=html