Hiding joined fields in map service

Question

We are trying to create a map service based on a single feature class, that is joined to another feature class and another table. Yes I know, perhaps not the best approach, but it works for us based on how our data is structured.

In previous versions of ArcGIS Server (i.e., 10.0 SP5) we are able to accomplish both of these joins AND hide all unwanted fields, in both the parent and joined tables.

Now attempts to recreate this service with ArcGIS Server 10.2.2 are unsuccessful when it comes to hiding fields. As soon as one join is applied, all fields are now visible.

Is there a setting we've missed? Is this a bug?

SandraLuken · Answer

The issue has been captured by Esri Inc

[BUG-000084517 : Map service is showing the fields which are turned off in the MXD when a feature class is joined with another feature class and the data is in Oracle SDE 10.1 geodatabase.]

http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDA4NDUxNw==

SandraLuken · Answer

This was submitted to my local distributor and the issue can be replicated. It is now on it's way to Esri Inc to confirm as a bug. Will post a link to the NIM If/when this is confirmed.

To · Answer

Interesting, good to know. In your SQL query you should be able to re-name fields using standard SQL syntax "SELECT fieldname1 as thisnewfieldname1,...FROM...WHERE...etc"  Good luck!