Hi all,
I had to make an alerts for purchase order with an orange linking to the document .
The output of the query, I have made for alert, is giving the correct output with an orange link. But on message and alerts screen at the reciever's end for the same query the orange link does not appear.
Query written for the alert **********************************************************
WITH ABC AS
(
SELECT
ADOC.DocNum [A_DocNum], ADOC.[U_POAmendmentNo][A_POAmendmentNo], ADOC.UpdateDate
FROM ADOC
WHERE
ADOC.ObjType=22
AND
ADOC.LogInstanc = (SELECT MAX(T1.LogInstanc) FROM ADOC T1 WHERE ADOC.DocEntry=T1.DocEntry)
GROUP BY ADOC.DocNum,ADOC.[U_POAmendmentNo],ADOC.UpdateDate
)
SELECT T0.[DocNum], T0.[CardName], T0.[U_PO_No],T0.[U_POAmendmentNo] [PO Amendment No.] FROM OPOR T0
INNER JOIN ABC ON (T0.[DocNum] = ABC.[A_DocNum] AND ( ISNULL(T0.[U_POAmendmentNo],0)<> ISNULL(ABC.[A_POAmendmentNo],0)))
WHERE T0.[U_POAmendmentNo] >0 AND (DATEDIFF(DAY, T0.[UpdateDate],GETDATE())<1 )
***********************************************************************************************************************
Please guide me, if any one has an idea.
Regards
Sonil