Is This Content Helpful?
We're glad to know this article was helpful.
MSD based services with joined datasets fail to perform Query in Services Directory if the feature class and table are stored in different locations. For example, a feature class from SDE joined with a table from SQL server cannot be queried.
In MSD based map services, when a feature class and a joined table are stored in different locations, users cannot query the feature.
The instruction provided below describe a work around for this problem.
Place the table and feature class in the same location, such as an SDE database. Join the table with the feature class and save it as MXD and MSD. Publish these files.
For more information on creating a UIControl, see the ArcGIS Desktop Help topic Creating custom commands with VBA and UI Controls.