query related table and showing query results on map layer
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.
Do you have option to select Framework as target within Query widget? Record selection changes==>+ Add action => Framework => Select data records
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.
