Bug: Query based on OBJECTID field fails for ArcSDE layers in an ArcIMS Image or Feature service
Any query based on the OBJECTID field for ArcSDE layers served in an ArcIMS Image or Feature service fails to return any results.
Similarly, when using ArcMap as a client, this failure is exhibited as an empty attribute table for the ArcIMS Image or Feature service layer.
Some clients, including ArcMap, use the fully qualified OBJECTID field name rather than #ID# when generating a SPATIALQUERY.
If the map configuration file contains a SPATIALQUERY with the #ID# subfield to represent the OBJECTID field, any query using a fully qualified OBJECTID field name fails since the Spatial Server is expecting the name #ID# for the OBJECTID field.
For all fields of the ArcSDE layer and any joined tables, always specify the fully qualified name in subfields of SPATIALQUERY in the map configuration file.
The map configuration file cannot be read locally in ArcIMS Author or ArcExplorer-Java Edition when using fully qualified names.