topic Re: Can't view "Related Records" option using a webservice in ArcGIS Online Questions

Can't view "Related Records" option using a webservice

BrianBulla — Thu, 02 Nov 2023 19:13:48 GMT

Hi,

I'm trying to show related records in a pop-up. According to this blog ( https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/rolling-out-related-records-in-map-viewer/ ) article, I should be able to do this, but for some reason I do not have the option to "Add Content - Related Records". See screenshot below. Can anyone explain what might be going wrong here??

Here are the details on the webservice I am using. I can view the features, and modify the features fields in the pop-up. Just no access to the related table for some reason.

ArcGIS REST Services Directory

Home > services > Works > Valves_Over_Inspections (MapServer)

Help | API Reference

JSON | SOAP

Works/Valves_Over_Inspections (MapServer)

View In: ArcGIS JavaScript ArcGIS Online Map Viewer ArcGIS Earth ArcMap ArcGIS Pro

View Footprint In: ArcGIS Online Map Viewer

Service Description:

Map Name: Valves Over Inspections

Legend

All Layers and Tables

Dynamic Legend

Dynamic All Layers

Layers:

Tables:

Valve_Inspections (4)

Description:

Copyright Text:

Spatial Reference: 26917 (26917)

Single Fused Map Cache: false

Initial Extent:

XMin: 670900.4892873524

YMin: 4861540.759367962

XMax: 671264.1504525405

YMax: 4861797.333926209

Spatial Reference: 26917 (26917)

Full Extent:

XMin: 632250.5783000002

YMin: 4845167.040200001

XMax: 706521.8962000003

YMax: 4932435.0529

Spatial Reference: 26917 (26917)

Units: esriMeters

Supported Image Format Types: PNG32,PNG24,PNG,JPG,DIB,TIFF,EMF,PS,PDF,GIF,SVG,SVGZ,BMP

Document Info:

Title: Map

Author:

Comments:

Subject:

Category:

Keywords:

AntialiasingMode: Fast

TextAntialiasingMode: Force

Supports Dynamic Layers: true

MaxRecordCount: 2000

MaxImageHeight: 4096

MaxImageWidth: 4096

Supported Query Formats: JSON, geoJSON, PBF

Supports Query Data Elements: true

Min Scale: 0

Max Scale: 0

Supports Datum Transformation: true

Child Resources: Info Dynamic Layer

Supported Operations: Export Map Identify QueryDomains QueryLegends Find Return Updates

Re: Can't view "Related Records" option using a webservice

KenBuja — Thu, 02 Nov 2023 20:04:58 GMT

Do you have a relationship set up with that specific layer? If you click on the "Valves Over Inspected" layer, does that page contain a list of relationships? For example, this layer has several relationships set up.

Re: Can't view "Related Records" option using a webservice

ArmstKP — Thu, 02 Nov 2023 21:02:13 GMT

@BrianBulla @KenBuja Related records from ArcGIS Server services are still not supported in the map viewer, surprisingly and unbelievably! You still have to use the classic map viewer to do so.

Re: Can't view "Related Records" option using a webservice

KenBuja — Thu, 02 Nov 2023 20:39:26 GMT

I can view related records in a popup using the Map Viewer. For example, using the service in my previous message, I built a popup to show the information from a related table.

var rec = First(FeatureSetByRelationshipName($feature, "DCGIS.ITSPE", ['BIDNAME', 'BIDTOTALDUE', 'BIDCOLLECTED', 'BIDBALANCE'])); if (IsEmpty(rec.BIDNAME)) return 'Not a BID'; return `${rec.BIDNAME} • Total Due: ${Text(rec.BIDTOTALDUE, '$#,###.00')} • Collected: ${Text(rec.BIDCOLLECTED, '$#,###.00')} • Balance: ${Text(rec.BIDBALANCE, '$#,###.00')}`

Re: Can't view "Related Records" option using a webservice

ArmstKP — Mon, 06 Nov 2023 13:35:26 GMT

@KenBuja Sure, you have to use arcade expressions to do so, but then the related records aren't interactive like they are with hosted feature layers (below):

Re: Can't view "Related Records" option using a webservice

MobiusSnake — Fri, 03 Nov 2023 03:00:29 GMT

I'm not sure about the limitations that others have mentioned, but do you have feature access enabled on this map service, and are you accessing the resulting feature service endpoint? If so I would expect your URL to end in /FeatureServer rather than /MapServer.

Re: Can't view "Related Records" option using a webservice

BrianBulla — Fri, 03 Nov 2023 12:18:03 GMT

Yes, both the Valves Over and the Valves Under have a related table:

Re: Can't view "Related Records" option using a webservice

BrianBulla — Fri, 03 Nov 2023 12:25:17 GMT

Hi.

Well to be honest, I'm not 100% sure how this service was setup. Where I work the GIS users have no access to publish their own services, so we just submit a ticket to our IT help desk with an attached .mxd or .aprx file and they create the service. We just get the URL sent back to us with no control over how things are created.

From the responses above, and some blog/community articles, it seems like there are two issues here.

1. however this webservice was created, it won't work in AGOL. So I guess our backend needs to be updated? From what IT is telling me, our REST services are at v10.91....does that make sense??

2. We also have an onsite Portal, where the option to add related features to a pop-up aren't supported either, but I read somewhere that functionality is coming in Q4 of this year....is that correct?? But I guess if our REST is still at an unsupported version, then it doesn't really matter if Portal will support it or not.

A lot of moving parts here!! 🙂

I will try the @KenBuja method using Arcade to see if I can at least get something in there for now.

Re: Can't view "Related Records" option using a webservice

BrianBulla — Fri, 03 Nov 2023 12:51:03 GMT

Ha ha!! And now that I'm back on to Arcade I am now remembering why I stopped trying to get Arcade to work in the first place....back to square on I suppose. 🙂

https://community.esri.com/t5/arcgis-online-questions/arcade-not-working-in-pop-up/td-p/1338625

Re: Can't view "Related Records" option using a webservice

BrianBulla — Fri, 03 Nov 2023 13:31:47 GMT

Hi Ken,

Just troublehsooting this now, and even the Arcade is not working. So with your example, when you're in the AGOL webmap and you click on "Tables" on the left hand side, do you see all of your related tables available? In mine I see nothing. But maybe related tables don't show up here anyways....I'm just curious.

Re: Can't view "Related Records" option using a webservice

MobiusSnake — Fri, 03 Nov 2023 23:43:40 GMT

If you replace the "MapServer" part of the URL with "FeatureServer", do you get anything?

Re: Can't view "Related Records" option using a webservice

BrianBulla — Mon, 06 Nov 2023 19:16:20 GMT

I get a "Service does not exist or is inaccessible".

If I try to go straight to that as a URL in a web browser, I just get a blank page. I'm not totally sure how our IT department sets this stuff up, as we are not allowed to publish anything ourselves. I don't even know what the different options are to ask them to change something.

Re: Can't view "Related Records" option using a webservice

BrianBulla — Mon, 06 Nov 2023 19:29:58 GMT

Does anyone know of a public webservice with a relationship in it that is not on AGOL, that I could use to do soem testing with. I'm just not sure where the issue is....the webservice created for me, maybe our firewall, something else??? Who knows.

Thanks,

Re: Can't view "Related Records" option using a webservice

KenBuja — Mon, 06 Nov 2023 19:47:35 GMT

Have you tried the one I mentioned above? There are other layers in that service with related records:

Re: Can't view "Related Records" option using a webservice

Anonymous User — Wed, 15 Nov 2023 21:48:23 GMT

Re: Can't view "Related Records" option using a webservice

BrianBulla — Mon, 06 Nov 2023 20:00:17 GMT

Thanks @KenBuja .

So just trying the first one in the list, I am still unable to add the "Related Records" (see screenshot below). I am in AGOL. I should be able to, shouldn't I?? Looking at the REST, there appears to be 3 related tables but I don't seem to have an option for any of them.

Re: Can't view "Related Records" option using a webservice

KenBuja — Mon, 06 Nov 2023 20:10:06 GMT

This is an older server, running on 10.91. From what others in the thread have said, that capability isn't available yet on Enterprise servers until 11.2 is released.

Re: Can't view "Related Records" option using a webservice

BrianBulla — Mon, 06 Nov 2023 20:11:05 GMT

Thanks Ken

Re: Can't view "Related Records" option using a webservice

KenBuja — Mon, 06 Nov 2023 20:21:06 GMT

You can add a related table to your map, using the Add button in the upper left and using the URL of your table layer.

Re: Can't view "Related Records" option using a webservice

BrianBulla — Mon, 06 Nov 2023 20:23:43 GMT

Yes, this is what I experience too.