how to set the alert

[Former Member]

Hi All,

Based on the below criteria i want to set the alert

Select U_SDate,U_EDate from [@PROJ_DET]
=====================================

U_Sdate             U_Edate
-------------            -------------
1)2008-10-01       2008-11-01
2)2008-10-02       2008-12-25

so, in the first row the project planned is 30 days..so i want to set a alert like if the current date comes to 2008-10-10(i,e before 20 days)....i should show a alert....can anybody suggest me some ideas like how to set these alert before completion of the project before 20days of U_Edate.

regards,

shangai.

[Former Member]

Hi

You can use Alerts Management.

-

---

1) Create and save your query in Query Generator

Make it in the Main Menu / Reports / Query Generator

2) Create Alert in Alerts Management.

See Main Menu / Administration / Alerts Management.

Use the query created in 1).

Hope this note help you.

Regards

Sierdna S.

Edited by: Sierdna S on Oct 10, 2008 11:16 AM

[Former Member]

hi sierdna,

i know hoe to go & set the alert & also for partiular user..but i want the particular query to take the only U_EDate before 20 days completion....

regards,

shangai

[Former Member]

Set other search criteria.

Select U_SDate,U_EDate from [@PROJ_DET]
Where U_SDate > GetDate()
And Code = 'ADD_CODE_HERE'

Regards

Sierdna S.

[Former Member]

hi sierdna,

Based on the query i have taken 2 fields

Select B.ProjectName,A.EmployeeName from [@PRJ_DET] A inner join [@PRJ_MST] B on A.code=b.code Where (U_EDate)-(GetDate())<=20

Project Name        Employee name
==========        ============
Sample1                John
Sample2                Micheal
SAmlpe3                David

so,in the alert i want to display the project name end date is going to comlpete.......how to set the alert.........can anybody tell me

regards,

shangai.