Query to check broadcast on Bookmark

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

Replies (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

Leave a Comment
 
Attach a file