Broadcast functionality

Deannah shared this question 3 years ago
Answered

Is it possible to use a SQL statement to compile the list of recipients for the broadcast? So it would potentially change every time it is sent.


Many thanks,

Deannah

Replies (3)

photo
1

Hi Deannah,

Thank for reaching out to support with your question.

The "usual" way of doing this is to create a report in Yellowfin that defines the broadcast recipient list, as per our wiki -

https://wiki.yellowfinbi.com/display/yfcurrent/Broadcast

In theory you could create a freehand SQL report with the desired query, and use that report as your recipient list.

However I do see an open task in our dev platform that indicates there may be some access filters when this approach is used. Would this be applicable in your situation?

Thanks,

Eric

photo
1

Hi Deannah.

Just wanted to check in to see if you had a chance to review my reply at this time?

Thanks,

Eric

photo
1

Yes thanks Eric,

I haven't had chance to try it out yet sadly, I will let you know when i do!

:)

Have a great day

photo
photo
1

Hi Deannah,

I'm going to go ahead and mark this question as Answered at this time, feel welcome to reply here if you have any related inquiries.

Thanks,

Eric

Leave a Comment
 
Attach a file