topic Re: query related table and showing query results on map layer in ArcGIS Experience Builder Questions

query related table and showing query results on map layer

Lwkrynock — Tue, 27 Sep 2022 12:28:52 GMT

I'm working on an ExB app that includes building features and related tables that describe building usage (e.g. what departments occupy space in the buildings). The relationship class between buildings and the different usage tables is 1:M.

I have a query widget that queries a usage table by department. I can click on each item in the query results list and the map will flash each building using the trigger/actions shown below (query output as trigger, map feature layer as action). However, what I would like to do is have the map highlight ALL of the buildings in the result list at one time. There are no actions available for the records created trigger (I assume because the query is on a non-spatial table?).

Are there other ways to make this work in ExB? Essentially, I want to query a non-spatial table and use the related field to select/highlight features in a related map layer.

Re: query related table and showing query results on map layer

AlexLynch — Tue, 27 Sep 2022 15:12:53 GMT

Do you have option to select Framework as target within Query widget? Record selection changes==>+ Add action => Framework => Select data records

Re: query related table and showing query results on map layer

Lwkrynock — Tue, 27 Sep 2022 15:48:20 GMT

I do have that option. When I enable that, the feature info record for the building is selected when I select one of the results (see below). It does not cause any action on the map. What I'd love to see is all 48 results highlighted on the map once the query is run. I guess this isn't possible since I'm not querying a related table instead of the actual map layer.

Re: query related table and showing query results on map layer

TianWen — Fri, 30 Sep 2022 09:05:55 GMT

Thanks for the post. Unfortunately, this is currently not supported.

Re: query related table and showing query results on map layer

PeterBrad3 — Tue, 14 Nov 2023 13:55:23 GMT

I'm looking for this functionality as well. I have an asset point feature service and a related inspection table. It would be great to query the inspection table and have it automatically show related assets. For example, query inspections that indicate garbage is present on site and show the all the assets in a list have have garbage present on site.

Re: query related table and showing query results on map layer

Laura — Wed, 23 Apr 2025 19:49:55 GMT

This would be cool functionality to see!