We are trying to create a dashboard or experience builder that will allow us to filter construction feature layers, based off a value from a relate table. We have construction layers that collect data that have a relate table to a table that contains information about each work order. We want to filter the feature layers based off of a loan id field in the relate table. The feature layer and table are related by a work order number field.
In short I want to select a loan id from the relate table, and filter the construction layers based on the related record that is tied to the relate table by a work order number.
Related table:
work order: 1234567 has a loan_id of COL25
construction feature:
Work Order is 1234567
