cancel
Showing results for 
Search instead for 
Did you mean: 

How to stop the information broadcasting mail if the output of the query is

Former Member
0 Kudos

Hi everyone, We have a requirement to not to send the information broadcasting mail in case if the query output is blank (ie no applicable data). However as per the schedule the mail should go in case if there is applicable data. In other words, users are not interested in opening the broadcasted mail to see if there is any applicable data or not.  Appreciate if you can help on this.

Regards

Sudha

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You can use the function module "RRW3_GET_QUERY_VIEW_DATA" to execute the query and check the result.

Based on the FM you can see if there is data in it (E_CELL_DATA).

If there is data you can trigger your broadcaster either by event (BP_RAISE_EVENT) or executing the program to start the broadcast providing setting ID ( submit to program RSRD_BROADCAST_STARTER  providing parameters and return).

Thanks.

striker_wbb
Active Contributor
0 Kudos

Hi,

I assume you are running the broadcasting using process chain, right?

You may use this program to know if zero record was fetched..Insert this in your process chain before broadcasting..

OR

If you are using the SCHEDULE button in the portal, you may CHECK this setting so that if there is an added record that's the only time the email will be broadcasted..

Regards,

Loed