To Send An Email Based On A Condition

[Adrian Ceballos]

I am sorry, I did a big mistake posting on the monyog forums.

May I ask you to delete this post?

Thanks

[peterlaursen]

I have deleted the post in the MONyog cattegory. I have also added this to our issue tracker: http://code.google.c…/detail?id=1633

But please explain: isn't an empty query result as valid a result as any other result? I could clearly imagine that in particular an empty result should be notified.

[Adrian Ceballos]

Thank you Peter,

On this particular case we have users creating on the ERP some invoices with an invalid project code (is like an invalid customer code).

So a simple SQL statement like this:

select * from invoices

where ProjectCode not in

(select ProjectCode from ProjectInventory)

Will tell us that incorrect invoices were created and we can fix the problem right away.

This problem happens only 1 or 2 times in a month, that is why I would like to schedule the query to be executed every day but I would like to send the email only those 1 or 2 times in the month when the “select” return rows.

[Author]

Posts