Query records in a related table

208
0
08-07-2021 05:37 PM
Labels (2)
JBLYON3
New Contributor

I have a published feature service with a related table.  I can successfully query the feature and show the associated results in a related table but I can’t seem to figure out a way to query the related table then filter the associated feature.  Is it possible to do a query on the related table?

Example: Feature contains salesperson location and id number.  Each sales person could be assigned to multiple states as recorded in a related table. Selecting the sales person will filter and show me the states they are assigned to.  However, each state can also have multiple sales persons assigned. I can’t figure out a way to select the state (from the related table) and have it filter to show the sales persons assigned. If I set it up as a category selector and use grouped value, since there are multiples of some states, I don't have the option to select the source field. It automatically selects the same field in the category selector, in this case state.

Thanks for the help!

 

Tags (2)
0 Replies