Alert for new Goods Issue

[former_member459477]

SELECT T0.DocNum, T0.UserSign, T0.JrnlMemo

FROM dbo.OIGE T0

WHERE T0.JrnlMemo = 'Goods Issue'

I want to get alert when a new Goods Issue is posted.

In Alert management I have changed to add mode and given alert: name, tick active box, selected Query above from 'open saved query' and ticked 'Int.' and 'Email' box for myself. Frequency is set for every minute for testing purpose.

I add a Goods Issue but alert does not happen. Where do I go wrong?

Thanks

[Former Member · Accepted solution]

Hi,

Try:

SELECT T0.DocNum, T0.UserSign, T0.JrnlMemo

FROM dbo.OIGE T0

WHERE T0.JrnlMemo LIKE 'Goods Issue%' AND DateDiff(dd,T0.DocDate,GetDate()) = 0

Thanks,

Gordon