Blank e-Mail from Agent/iBot when there is no data

Question

Summary: Getting blank e-mail from Agent when there is no data for the report on scheduled time. Is it possible to stop sending e-mail from Agent when there no data?

Content (required): Business users dont want to receive blank e-mails from OAC agents. We need an option to stop sending e-mails if there is no data on report.

Version (include the version you are using, if applicable): OAC July 2022 update

Code Snippet (add any code snippets that support your topic, if applicable):

Gianni Ceresa · Answer

Yeah, that checkbox is off by default.

You generally use it when you want to be notified that nothing happen (and when you do that, people setup rules to automatically archive your automated emails and will not even read them when there is something real inside :D  )

Subhakara Netala-Oracle · Answer

Thanks @Gianni Ceresa. We had the condition for ROWCOUNT more than 0(zero) but in delivery content tab, If Condition is False is enabled. That was the reason for Blank e-Mail. After unchecking the the condition, now we are not getting mails. I think by-mistake we had checked that.

Gianni Ceresa · Answer

You can set a condition on the agent, and the condition will be if there are rows or not. The agent will still run based on the schedule, but if the condition fail (= no rows of data), it does stop there and doesn't send anything.