topic Re: Related Records not appearing in Explorer for ArcGIS in ArcGIS Explorer Questions

Related Records not appearing in Explorer for ArcGIS

DanielIrwin — Fri, 08 Sep 2017 09:39:44 GMT

So we finally upgraded to the latest version of the explorer app on iOS (v.17.1.2 of app running on iOS 10.3.3), serving up maps from our Portal for ArcGIS instance through a VPN to the device. One of the things we were keen to make use of (and part of the reason for the upgrade) was the related records capability, of which we have quite a few. However, when I interrogate those map layers containing related records I do not see them. Are there any specific requirements for this to work, or has anyone else come across similar issues?

Re: Related Records not appearing in Explorer for ArcGIS

JayantaPoddar — Tue, 22 Jun 2021 08:49:07 GMT

Support for related records is currently not available with Explorer for ArcGIS. It is under consideration for future release. You could vote-up this idea https://community.esri.com/ideas/12518 .

Re: Related Records not appearing in Explorer for ArcGIS

DanielIrwin — Fri, 08 Sep 2017 10:37:00 GMT

Err, it is? See What's new—Explorer for ArcGIS | ArcGIS under the "Use beautiful, more responsive and informative maps" section?

Re: Related Records not appearing in Explorer for ArcGIS

JayantaPoddar — Fri, 08 Sep 2017 10:54:55 GMT

My bad. Good to see the feature already implemented. Thank you for sharing the update.

Re: Related Records not appearing in Explorer for ArcGIS

JayantaPoddar — Fri, 08 Sep 2017 12:06:36 GMT

Are you able to view the related records in web browser of ArcGIS Online?

Re: Related Records not appearing in Explorer for ArcGIS

DanielIrwin — Fri, 08 Sep 2017 12:22:39 GMT

As mentioned in OP we use Portal for ArcGIS and not AGOL but yes, we have always been able to view the related records there, it just appears to be in the mobile app that this isn't appearing...

Re: Related Records not appearing in Explorer for ArcGIS

HeatherMcCracken — Fri, 08 Sep 2017 14:36:39 GMT

Hi Daniel,

You are correct, accessing related records is supported in our current version of Explorer. Currently we support getting related records from the origin feature to the destination feature only. So, for example - you can tap on a Hydrant and get it's inspections, but not the reverse (presuming the relationship set up with Hydrants as the origin and Inspections is the destination)

Is it possible this is what you are running into? And that if you tap the feature in the other layer, you do actually get related info? If this is the case, and you would like to have this additional support - it would be great to hear more about this requirement and your particular workflow so we can understand your use case.

Whether it's this case, or something else we'd like to hear more about it. If you could email Explorer4ArcGIS@esri.com with the details of either scenario that would be great. Then we can get into the details there.

Thanks for the question and the feedback.

Heather

bpierce-esristaff‌

Re: Related Records not appearing in Explorer for ArcGIS

DanielIrwin — Mon, 11 Sep 2017 13:34:11 GMT

Hi Heather,

Thanks for the information, we did wonder if the problem was that we had configured the relationship class to go in both directions (forwards and back), so we altered the relationship class to just go forward, but we are still not seeing anything in the output. I've attached a screenshot of the relationship class below, is there anything else that might cause it to fail?

Many thanks

Dan

Re: Related Records not appearing in Explorer for ArcGIS

AlexanderNohe1 — Mon, 11 Sep 2017 14:57:49 GMT

Hi Dan,

Can you post a link to the feature service? Or show a screenshot with the related tables in the feature service?

Thanks,

Alexander

Re: Related Records not appearing in Explorer for ArcGIS

Anonymous User — Tue, 03 Oct 2017 18:22:53 GMT

Hey Dan,

I worked with Mervyn on this issue we found a few bugs with related records (as well as a bonus issue) -- here are the results:

BUG: Related data not showing when layers published as services with primary or foreign key hidden
- Workaround: Unhide PK/FK and republish service. Hide PK/FK in popup configuration if do not want to show
BUG: Related data not showing when definition expression applied to the layer while publishing
- Workaround: Export layer with definition expression into it's own feature class and republish service
BUG-000106749: Layers do not load with “Item does not exist or is inaccessible” after copying content between environments OR if the Map Service item added to Web Map is no longer accessible.
- Workaround: Use a tool like ago-assistant to remove the invalid "itemId" parameter from the layer's JSON

Can you mark this as the correct answer?

Thanks,

Joel

Re: Related Records not appearing in Explorer for ArcGIS

DanielIrwin — Thu, 05 Oct 2017 09:47:56 GMT

Hi Joel,

I've marked this as the correct answer (the second bug), although it is a bug rather than our problem being solved. Unfortunately we can't export the layer with the definition query and republish as this would significantly alter the architecture of our data model.

Re: Related Records not appearing in Explorer for ArcGIS

Anonymous User — Thu, 05 Oct 2017 13:56:07 GMT

Thanks Dan!

Marking my response as the correct answer will allow other users to determine if this is the same issue that they are running into. Once I get the official BUG numbers from support I will edit my response above to include them. This will make it easier for other users who want to be attached to the BUGs in order to track developments progress.

I understand the workarounds are not ideal, but I wanted to include them in case someone needs to get around this bug asap. We are well aware of the issues and are working diligently to get them addressed!

Re: Related Records not appearing in Explorer for ArcGIS

LeahSperduto — Tue, 12 Dec 2017 16:17:35 GMT

Is there a requirement for the service to be a feature service? or can it be a map service?

Re: Related Records not appearing in Explorer for ArcGIS

JustinConnerWR — Fri, 05 Jan 2018 17:47:46 GMT

The issue of related records not showing up is also true for Collector.

Re: Related Records not appearing in Explorer for ArcGIS

RobertHarris5 — Mon, 12 Feb 2018 13:42:50 GMT

Joel, we are having the same issue with Explorer. Our example is one point feature class related to another point feature class. In this case it is streetlights related to a Work Request with a GPS location. Popups for both feature classes work in Portal, however users cannot click on a light and see the related work requests. We would prefer to not symbolize the work request and have users access them through the light as a related record.

Explorer version 17.1.2

Portal 10.5.1

ArcSDE 10.2.1

Published using ArcMap 10.2.1 (as a map service only, not a feature service)

PK/FK has been turned on, the other two workarounds are not an option for us.

No definition queries defined in the publishing map.

Re: Related Records not appearing in Explorer for ArcGIS

JustinConnerWR — Mon, 12 Feb 2018 13:49:50 GMT

(when using a Map Service instead of a Feature Service under certain conditions)

Re: Related Records not appearing in Explorer for ArcGIS

Anonymous User — Mon, 12 Feb 2018 14:31:32 GMT

Hey Robert Harris‌,

There is a known issue where the related data will not be returned if the Map Service is added to the map by the map service root url. Can you try adding the streetlights and work request layers to a map by the map service layer (ie "https://.../MapServer/4" & "https://.../MapServer/5") to verify this is the issue you're running into?

Re: Related Records not appearing in Explorer for ArcGIS

Anonymous User — Mon, 12 Feb 2018 14:39:10 GMT

Hey Alison Mynsberge‌,

I suspect you're running into the same issue that Robert was seeing above..

There is a known issue where the related data will not be returned if the Map Service is added to the map by the map service root url. Can you try adding the layers to a map by the map service layer (ie "https://.../MapServer/4" & "https://.../MapServer/5")?

Re: Related Records not appearing in Explorer for ArcGIS

JustinConnerWR — Mon, 12 Feb 2018 14:42:27 GMT

Yes, that fixes it. Having the details on here will hopefully help someone else experiencing the same issue as it's not clearly documented anywhere else. I was told that using related tables with map services (vs. feature services) is not considered supported in Collector b/c Collector's primarily use is to edit [feature services].

Re: Related Records not appearing in Explorer for ArcGIS

RobertHarris5 — Mon, 12 Feb 2018 17:09:13 GMT

Thank you Joel. Technically that does resolve the issue. I am able to view related tables in popups by adding the map service layer. I need to do some more testing to see the overall impact of this for our production mapping environment. In our most used web application (and Explorer map) we have a map with 7 map services feeding the map, and up to 41 layers in each map service...