Alert for Delivery
I am using the below mentioned query which is assigned to generate alert to employee after addition of delivery. This alert works fine.
My requirement is: when alert is open in Inbox by user their is an column for attachment i want to provide link to user to access the PLD for delivery.
Solution will be appreciable.
SELECT T0.[CardName], T0.[DocDate], T1.[ItemCode], T1.[Dscription],
T1.[Quantity] FROM ODLN T0 INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry
Where DateDiff (dd, T0.DocDate,Getdate())=0