Query to check broadcast on Bookmark

Sameer Patil shared this question 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

Replies (2)

Eric Hagfors ●

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

Reply URL

Eric Hagfors ●

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

Reply URL