- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-19-2025 05:44 AM
@L_ B_ Laun sorry for never replying I never got a notification that you had replied. If you are still looking at this you will need to make a database view
Assuming this is on the Crisis Event record, you would build a database view that joins the sn_recovery_event_asset table (which would be where you would say a location is impacted) to the sn_bia_dependency table and joining via Asset name and Depends on field and filtered where the element definition is location. Then you will be able to dot walk to the BIA fields via the impacted dependency group and then to the BIA.
You can then make a scripted relationship that then filters this database view for the impacted locations for the crisis events. This can then be added as a related list on the crisis form
Hopefully that helps!