topic Re: Hiding joined fields in map service in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47189#M1670 <HTML><HEAD></HEAD><BODY><P>The suggested workaround to use a query layer is successful in hiding unwanted fields. However, it does produce a different field naming convention, so will need to watch out for downstream dependencies with consuming applications. </P><P></P><P>Further testing also revealed that the problem is isolated with a feature class to feature class join, as a join to a standalone table is successful in hiding fields. </P></BODY></HTML> Mon, 15 Dec 2014 18:43:09 GMT SandraLuken 2014-12-15T18:43:09Z Hiding joined fields in map service https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47187#M1668 <HTML><HEAD></HEAD><BODY><P>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. </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>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. </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>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. </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Is there a setting we've missed? Is this a bug?</P></BODY></HTML> Sun, 14 Dec 2014 16:45:54 GMT https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47187#M1668 SandraLuken 2014-12-14T16:45:54Z Re: Hiding joined fields in map service https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47188#M1669 <HTML><HEAD></HEAD><BODY><P>A possible workaround you could try is to create a <A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//00s50000000n000000">query layer with ArcMap</A>. </P></BODY></HTML> Mon, 15 Dec 2014 04:30:32 GMT https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47188#M1669 TobiasFimpel1 2014-12-15T04:30:32Z Re: Hiding joined fields in map service https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47189#M1670 <HTML><HEAD></HEAD><BODY><P>The suggested workaround to use a query layer is successful in hiding unwanted fields. However, it does produce a different field naming convention, so will need to watch out for downstream dependencies with consuming applications. </P><P></P><P>Further testing also revealed that the problem is isolated with a feature class to feature class join, as a join to a standalone table is successful in hiding fields. </P></BODY></HTML> Mon, 15 Dec 2014 18:43:09 GMT https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47189#M1670 SandraLuken 2014-12-15T18:43:09Z Re: Hiding joined fields in map service https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47190#M1671 <HTML><HEAD></HEAD><BODY><P>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"&nbsp; Good luck!</P></BODY></HTML> Mon, 15 Dec 2014 18:51:01 GMT https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47190#M1671 TobiasFimpel1 2014-12-15T18:51:01Z Re: Hiding joined fields in map service https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47191#M1672 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Tue, 23 Dec 2014 15:20:30 GMT https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47191#M1672 SandraLuken 2014-12-23T15:20:30Z Re: Hiding joined fields in map service https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47192#M1673 <HTML><HEAD></HEAD><BODY><P>The issue has been captured by Esri Inc </P><P></P><P>[<A href="http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDA4NDUxNw==">BUG-000084517</A> : 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.]</P><P></P><P><A href="http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDA4NDUxNw==" title="http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDA4NDUxNw==">http://support.esri.com/en/bugs/nimbus/QlVHLTAwMDA4NDUxNw==</A></P></BODY></HTML> Wed, 04 Mar 2015 18:32:02 GMT https://community.esri.com/t5/arcgis-enterprise-questions/hiding-joined-fields-in-map-service/m-p/47192#M1673 SandraLuken 2015-03-04T18:32:02Z