topic Couple issues on service with joined table in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/couple-issues-on-service-with-joined-table/m-p/361860#M14041 <HTML><HEAD></HEAD><BODY><P>I have a couple problems with a service containing a layer with a joined table. The feature class is stored in a SDE database, the join table is in a SQL non-geodatabase within the same SQL Server instance.<BR />SQL Server 2012<BR />ArcGIS Desktop and Server 10.3.1</P><P></P><P>Issues:<BR />1. Using the REST interface, queries using fields in the joined SQL table returns 0 features. The query executes without error and returns the layer metadata.<BR />Queries on feature class fields will successfully return features, as will queries on the unjoined SQL table.<BR />How can I query the feature class on the joined fields?</P><P></P><P>2. Labels will not display feature class fields but will display joined table fields.<BR />A label expression containing fields from both the feature class and table will act as if the feature class field contains an empty string string.<BR />Why do the labels on a joined layer only display data from joined fields?</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 26 Oct 2016 14:02:28 GMT PaulKroseman 2016-10-26T14:02:28Z Couple issues on service with joined table https://community.esri.com/t5/arcgis-enterprise-questions/couple-issues-on-service-with-joined-table/m-p/361860#M14041 <HTML><HEAD></HEAD><BODY><P>I have a couple problems with a service containing a layer with a joined table. The feature class is stored in a SDE database, the join table is in a SQL non-geodatabase within the same SQL Server instance.<BR />SQL Server 2012<BR />ArcGIS Desktop and Server 10.3.1</P><P></P><P>Issues:<BR />1. Using the REST interface, queries using fields in the joined SQL table returns 0 features. The query executes without error and returns the layer metadata.<BR />Queries on feature class fields will successfully return features, as will queries on the unjoined SQL table.<BR />How can I query the feature class on the joined fields?</P><P></P><P>2. Labels will not display feature class fields but will display joined table fields.<BR />A label expression containing fields from both the feature class and table will act as if the feature class field contains an empty string string.<BR />Why do the labels on a joined layer only display data from joined fields?</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 26 Oct 2016 14:02:28 GMT https://community.esri.com/t5/arcgis-enterprise-questions/couple-issues-on-service-with-joined-table/m-p/361860#M14041 PaulKroseman 2016-10-26T14:02:28Z