Map service with joined tables

YasnaiaMassie · ‎02-01-2023

Is it possible publish a map service to portal with joined tables?
I have a arcpro document with many layers (feature classes). Each layer is symbolized based on the field of its joined table. When I try to publish a map service the join does not work.

I have ArcGIS enterprise with a local server, my ArcPro is 2.9.

Thank you

TanuHoque · ‎02-01-2023

yes, map service supports joins. If it doesn't work for you then there must be some other issues going on... if problem persists, maybe a good idea to check with Esri Support.

When I try to publish a map service the join does not work.

also, would you mind describe a bit more on what exact is not working? another question - are you adding the service as a 'map image layer' (aka map service layer') in your web app or adding individual layer off the map service as 'feature layer' in your webmap?

thanks

BillFox · ‎02-01-2023

where are the feature class and joined table coming from?

AlexJohnson · ‎02-01-2023

Yes, it's definitely possible. (Not always straight-forward, but possible. I've run into several different issues publishing joined tables.) I'd recommend that your joined tables are registered with the geodatabase, as I worked out in this previous thread: https://community.esri.com/t5/arcgis-enterprise-portal-questions/popups-and-joined-geodatabase-views...

GIS Architect & Environmental Engineer
Principal, Arete Systems

ZachBodenner · ‎02-02-2023

Yes, I've had some issues with using a feature class symbolized on a joined table as a Feature Service in a web map. Are you trying to add it to a map as a feature service or a map service? If this is the issue you're having, you may need to use it in the web map as a map service.

YasnaiaMassie · ‎02-02-2023

Here is an illustration what I've been doing which is not working.

TanuHoque · ‎02-02-2023

thanks @YasnaiaMassie for providing the illustration.

how do you know map service is not honoring the join? Do you see fields from the joined table in the layer REST resources? if you submit a query request with outFields=*, do you see all fields from left and the right side of the join in the result?