Hello Experts,
We have created the following query and added it to alerts management to notify certain users when a production order is closed.
SELECT T0.[DocNum], T0.[ItemCode], T0.[Status] FROM OWOR T0 WHERE T0.[status] = 'L' and T0.[U_RD] is null AND datediff(mi,U_Status_Update,getdate()) <= 5 FOR BROWSE
I would like to have a drill-down arrow in the alert message that gets sent out to users.
I have searched the forums and discovered that adding FOR BROWSE to the end of the query creates the orange drill-down arrow when the query is executed which is great but the drill-down arrow still does not show in the internal mail message sent out to users.
Can drill-down links be included in alerts/messages and if so, what have I done wrong?
Thank you kindly,
Richard
SAP Business One Version 8.8 PL:15