Filtering a many-to-many relationship

Question

Hello,

Here is my situation:

- I have a point FC of LOCALITIES and a table of SAMPLES collected - many samples collected in each locality

- Every year there's a new expedition that goes to some of the localities and collects more samples so for every sample in the SAMPLES table, not only there's a field with the locality ID but also a field with the ID of the expedition - and separately a third table called EXPEDITIONS

This seems to be a standard many-to-many relationship.

I'd like to see the map of the LOCALITIES but filtered by the EXPEDITIONS.

I'm trying to use list and filter widgets but cannot find the right actions to use.

I'm using ExB developer edition 1.5 with ArcGIS enterprise 1.8.1

Thank you in advance,

Marcelo

SveinungBertnesRåheim · Answer

We have discussed  the same problems in this thread. According to Esri, it is not possible to start an action based on the result of another action. You have to interact manually to activate an action:
https://community.esri.com/t5/arcgis-experience-builder-questions/many-to-many-relationship-in-experience-builder/m-p/1342167#M8968

Is this how EB is supposed to behave, or is this a bug? I dont know.

SerjStol · Answer

Hi, did you say this suggestion worked for you? I find this only works for One to Many relationships. If you have Many to Many, the foreign keys of original and destination feature class are stored in an intermediary table and ExB Action Triggers do not expose that table so there is no way to set the correct keys for the triggers to work. In the Web Map Viewer popups however, the related records do work for M:N relationships.

Correct me if I am wrong but are M:N not supported in ExB widget action triggers?

EmmaHatcher · Answer

Well you aren't alone at least, I have a whole list of looks-like-a-bug things in ExB that I've run into... Feeling like one would write a novella dedicated to just those buggie things at this point.