Query Many to Many tables in ExB

DavidTreering1 — Fri, 16 Dec 2022 16:44:20 GMT

New to Experience Builder, so forgive the lack of specificity.

I have a schema with M:N relationships that I would like to query and work with in ExB.

For example, a State has zero or more Contractors, who may work in one or more States. The goal is to select a State in the map and populate the related Contractors in the Table/List. Possibly then select the Contractor in the Table/List and highlight related States in the map.

I have a simple non-attributed relationship class Contractor_State with the foreign keys from the two tables.

First, do ExB actions and trigger recognize related tables? It seems like it does not. Could the SQL Expression Builder in the Dev Edition be configured with joins to access related records?

Any advice on how to proceed?

Re: Query Many to Many tables in ExB

MagalyClément-Zaber — Thu, 31 Aug 2023 09:38:25 GMT

Hi,

Have you found a solution ? I am in the same situation dans can't find how to do this.

Thanks

topic Re: Query Many to Many tables in ExB in ArcGIS Experience Builder Questions

Query Many to Many tables in ExB

Re: Query Many to Many tables in ExB