Good question! The following will give you a list of active broadcasts, including the report name, frequency, etc. Please replace the text "youryellowfinDB" with the name of your database.
SELECT *
FROM youryellowfinDB.[TaskSchedule]
INNERJOIN reportbroadcast ON taskschedule.scheduleunitid=reportbroadcast.broadcastid
INNER JOIN reportheader ON reportbroadcast.reportid=reportheader.reportid
WHERE ScheduleSubjectCode = 'BROADCAST'
AND ScheduleIsOn = 1
If you need anything else, please let me know.
Cheers,
Neal
Hi Shahul,
Good question! The following will give you a list of active broadcasts, including the report name, frequency, etc. Please replace the text "youryellowfinDB" with the name of your database.
SELECT *
FROM youryellowfinDB.[TaskSchedule]
INNERJOIN reportbroadcast ON taskschedule.scheduleunitid=reportbroadcast.broadcastid
INNER JOIN reportheader ON reportbroadcast.reportid=reportheader.reportid
Just touching base to see if the SQL query I sent earlier was able to give you the information you were looking for? Is there anything else I can help with on this?
Cheers,
Neal
Hi Shahul,
Hope you are having a good week.
Just touching base to see if the SQL query I sent earlier was able to give you the information you were looking for? Is there anything else I can help with on this?
The same question
Hi Shahul,
Good question! The following will give you a list of active broadcasts, including the report name, frequency, etc. Please replace the text "youryellowfinDB" with the name of your database.
SELECT *
FROM youryellowfinDB.[TaskSchedule]
INNERJOIN reportbroadcast ON taskschedule.scheduleunitid=reportbroadcast.broadcastid
INNER JOIN reportheader ON reportbroadcast.reportid=reportheader.reportid
WHERE ScheduleSubjectCode = 'BROADCAST'
AND ScheduleIsOn = 1
If you need anything else, please let me know.
Cheers,
Neal
Hi Shahul,
Good question! The following will give you a list of active broadcasts, including the report name, frequency, etc. Please replace the text "youryellowfinDB" with the name of your database.
SELECT *
FROM youryellowfinDB.[TaskSchedule]
INNERJOIN reportbroadcast ON taskschedule.scheduleunitid=reportbroadcast.broadcastid
INNER JOIN reportheader ON reportbroadcast.reportid=reportheader.reportid
WHERE ScheduleSubjectCode = 'BROADCAST'
AND ScheduleIsOn = 1
If you need anything else, please let me know.
Cheers,
Neal
Hi Shahul,
Hope you are having a good week.
Just touching base to see if the SQL query I sent earlier was able to give you the information you were looking for? Is there anything else I can help with on this?
Cheers,
Neal
Hi Shahul,
Hope you are having a good week.
Just touching base to see if the SQL query I sent earlier was able to give you the information you were looking for? Is there anything else I can help with on this?
Cheers,
Neal
It worked. thanks.
It worked. thanks.
Hi Shahul,
Glad to hear it. I will mark this as complete, but please let me know if you need anything further on this.
Cheers,
Neal
Hi Shahul,
Glad to hear it. I will mark this as complete, but please let me know if you need anything further on this.
Cheers,
Neal
Replies have been locked on this page!