Select to view content in your preferred language

Update many-to-many relationship through selected items

3813
16
04-14-2025 07:34 AM
Labels (2)
Service_SIG_CAPDFT
Occasional Contributor

Hello,

I'm trying to create an Experience Builder application that allows a field agent performing an intervention on a network to link this intervention to the actual network segments involved.

The data consists of a point feature class called "interventions" and a line feature class called "network". Naturally, a network segment can be involved in multiple interventions, and a single intervention can concern multiple segments. Therefore, a many-to-many (M:N) relationship has been defined in the database.
The datas had been published as a service on our enterprise server then used through URL in Online portal.

Since it's not possible to know in advance which segments are involved, only the team leader in the field can determine which ones are affected. As the teams are not GIS experts, I believe the most user-friendly way to enter the data is to allow them to select the segments directly on the map then clic an "update" button.

In ArcGIS Pro, it's simply a matter of selecting the "intervention" and "network" features, then using the attribute pane and the tool "Add selected item to the relationship".https://pro.arcgis.com/en/pro-app/latest/help/data/relationships/populate-an-attributed-relationship...

Now I'm trying to replicate this action in Experience Builder (or in ArcGIS Online more generally).

The solution suggested by ChatGPT was to develop a custom widget, but I currently don't have the time or skills for that...

I'm open to any ideas.
Thank you.

16 Replies
Gene_Sipes
Frequent Contributor

Thank you! Can you tell me more about your setup? Are your feature class and your related table hosted in either AGO or Portal? Or is it a service published from an SDE DB to a standalone/federated arcgis server?

The setup I am hoping to achieve is as follows:
-SDE DB Feature Class related many-to-many to a standalone Table 
-Published as a feature service to a federated arcgis server to either use in my Portal, or added as URL to AGO.

 

Allen_Zhang
Frequent Contributor

Mine is a hosted service. I searched and the doc said the SDE DB can be published as a service with relationships. But I never did that so I don't know the operatable steps.

0 Kudos
Service_SIG_CAPDFT
Occasional Contributor

 

After checking with ESRI, it is not possible to perform this many-to-many join directly from AGOL.
Our solution, therefore, was to pay for the development of a custom web service by ESRI.
This web service, hosted on our Enterprise environment, will be called via the "Analysis" widget from an Experience Builder hosted on AGOL.
A feasibility study is currently underway and should be delivered to us before the end of the year. The constraint is to have an Enterprise server with version 11.2 or higher.

I will share the relevant information with you as soon as possible.

Gene_Sipes
Frequent Contributor

Thanks for the update. I am interested in learning more!

0 Kudos
Service_SIG_CAPDFT
Occasional Contributor

We got news from ESRI. Il will cost between 25 to 30 k€ to get a custom widget on our enterpirse server.
It's not possible to get a script on our enterprise called by the analysis widget on our AGOL.

So basically the project is  on hold because this solution does not suit us.

I will push futher investigations with the help of AIs to find a workaround but with little hope.

0 Kudos
Gene_Sipes
Frequent Contributor

Ouch, thats a bit high. I'm curious, did ESRI explain why it is not possible to have two feature classes or tables related many to many, published from an enterprise server, not have the capability to be edited?

0 Kudos
Service_SIG_CAPDFT
Occasional Contributor

To update the chat, our setup is the following :
- A post GRE SQL database
- Create a relationship class through arcgis pro
- Publish the related layers and the raltionship table together in a single service on our enterprise
- Use the URLs on an AGOL map viewer