Query to check broadcast on Bookmark

Sameer Patil shared this question 2 months ago
Answered

Hi Team,

We need to find broadcasts configured on bookmarks of reports.

Please share query which can show us that data.

Regards

Sameer

Comments (2)

photo
1

Hi Sameer,

thanks for reaching out.

Reportbroadcast table has a "reportid" field that can be identified via reportheader table.

reportbroadcast also as a "datafilterid" column, , this links to reportinstance.filterid.

reportbroadcast.datafilterid also matches "reportinstance.reportinstanceid" which can link the reportinstance.reportid to the reportheader table.

reportinstance.reportstatuscode = BOOKMARK will ID bookmarks in the system.

Hope this helps! let me know if you have any additional qustions. Thanks, Eric

photo
1

Hi Sameer,

I'm going to go ahead and mark this Question as Answered at this time. Feel welcome to reach out in the future.

Thanks,

Eric