Report with broadcast schedules
Answered
I was asked to generate a list of all the reports being broadcast, with email addresses (staff who are getting the reports) with the schedules. Is there a way to do this without me having to open every report?
The same question
Hi Renee,
You can do this via SQL or use the tables/joins and columns below from the Yellowfin Configuration DB to build a View and create a Yellowfin Report as required. This in the mean time, should be able to give you what you need. It is to be run against the Yellowfin Configration table.
select RH.reportname AS "Report Name",
RB.broadcasttypecode AS "Type",
RB.requesttypecode AS "Code",
IPC.emailaddress AS "Email Address"
FROM reportbroadcast RB
INNER JOIN reportbroadcastrecipient RBC on (RB.broadcastid = RBC.broadcastid)
INNER JOIN ipcontact IPC on (RBC.recipientid = IPC.ipid)
INNER JOIN reportheader RH on (RB.reportid = RH.reportid)
WHERE broadcasttypecode = 'EMAIL';
If you need anything else of require further help, please let me know.
Thanks,
Paul
Hi Renee,
You can do this via SQL or use the tables/joins and columns below from the Yellowfin Configuration DB to build a View and create a Yellowfin Report as required. This in the mean time, should be able to give you what you need. It is to be run against the Yellowfin Configration table.
select RH.reportname AS "Report Name",
RB.broadcasttypecode AS "Type",
RB.requesttypecode AS "Code",
IPC.emailaddress AS "Email Address"
FROM reportbroadcast RB
INNER JOIN reportbroadcastrecipient RBC on (RB.broadcastid = RBC.broadcastid)
INNER JOIN ipcontact IPC on (RBC.recipientid = IPC.ipid)
INNER JOIN reportheader RH on (RB.reportid = RH.reportid)
WHERE broadcasttypecode = 'EMAIL';
If you need anything else of require further help, please let me know.
Thanks,
Paul
This is going to save me a ton of time. Thank you so much.
This is going to save me a ton of time. Thank you so much.
Hi Renee,
No problems. Glad to have helped. Please let me know if you need anything else or happy for this question to be closed off for now.
Thank you,
Paul
Hi Renee,
No problems. Glad to have helped. Please let me know if you need anything else or happy for this question to be closed off for now.
Thank you,
Paul
Hi Renee,
I am going to close off this ticket for now, but if you need anything else, please get back to me.
Thank you,
Paul
Hi Renee,
I am going to close off this ticket for now, but if you need anything else, please get back to me.
Thank you,
Paul
Replies have been locked on this page!