Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Alert query not working and getting alert

Hi experts

i had created an UDF and its type is Alphanumeric, i had created a query based on that UDF .(This is the UDF feild : T0.[U_IQId] )

when ever i change the data in this UDF. i need to get alert day wise

i had set the as that in the alert window

but the sys is not giving the msg . could u pls tell me what will be issue for that

i had attached both the alert window and the below given is the query

NB: IF there is any value existing in this UDF, and if we change it for the first time, it is no giving alert, but if we change it for the second time, it will pop up

i need to get the alert in the first time itself

pls help to sort it out

QUERY:

------------------------

SELECT distinct T0.[U_EMPOLD_ID] as'Employee ID', T0.[empID] as 'SAP ID', isnull(T0.[firstName],'')+' '+isnull(T0.[middleName],'')+' '+isnull(T0.[lastName],'') as 'Full Name', T2.[Remarks] AS 'Dept Name',

T0.[U_IQId]as 'New Iqama Id',T1.[U_IQId]as 'Old Iqama Id',T0.[U_SponsName] As 'Sponsor Name',T0.[U_JoinDate] As 'Enrollement Date',T1.[UpdateDate] as 'Update Date'

FROM OHEM T0

INNER JOIN OUDP T2 ON T0.dept=T2.Code

INNER JOIN AHEM T1 ON T0.empID = T1.EmpID

WHERE getdate() >= T1.[UpdateDate] AND (T1.[UpdateDate]+2) >= getdate() AND

T0.[U_IQId]<> T1.[U_IQId]

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

regards

Alert Window.jpg (47709 B)
Former Member
Not what you were looking for? View more on this topic or Ask a question