Skip to Content
0
Sep 26, 2011 at 08:32 AM

Alert management

29 Views

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