ReportInstanceID and ReportBroadcastResult data
Hi, I'm looking for a way to connect the filter value applied to each advanced broadcast recipient in the metadata.
I can get the filter values applied to each instance from the reportinstancefilter table, and use the reportinstance table to connect that to the original reportid.
However, I can't find a corresponding value in the broadcast data and specifically the ReportBroadcastResult table to link the reportinstance to the broadcast result/recipient/runUUID/timestamp.
If I could, I'd be able to list each advanced broadcast recipient and the value they were filtered against for each broadcast run.
This could then be developed further to track which recipients have been matched per value and shouldn't receive the advanced broadcast when it runs again (for cases where they should only get it once).
Is there another table or way to connect broadcast result/recipient with reportinstanceID?