How can i send automatic mail based on data selection

[#1]

Hi all,

I need to apply the below logic in the uploaded sample QV.

Based on the column (Remaining time) , if it is less than 2(hr) automatic mail needs to be sent to the team (Group) with the subject as ticket number(Case Id) .

The above logic will be checked based on on open or reload of the application. Please suggest your idea. 

CASE ID	Remaining_Time	Group
IM740410	1	Test A
IM741550	2	Test A
IM741556	4	Test C
IM741644	4	Test A

[p_verkooijen · Accepted solution]

I see you tried using Alerts, however you need to use AGGR to determine which CASE's are due.

See attachment

[#3]

Hi Paul,

Thanks a lot for the logic that you have used. It is exactly the same that i wished as, can you please help me out in one more logic in the application ,

How can i set the mail recipients automatically based on satisfying the above conditions. So that in mail recipient (alert) field it is not necessary to enter all the mail ids.

IM743087	2	Test A	abcd@gmail.com
IM743097	1	Test D	abcd@hotmail.com
IM743163	1	Test D	abcd@hotmail.com
IM743293	2	Test D	abcd@hotmail.com
IM743297	1	Test D	abcd@hotmail.com
IM743298	1	Test D	abcd@hotmail.com
IM743299	1	Test D	abcd@hotmail.com
IM743300	1	Test D	abcd@hotmail.com
IM743301	1	Test D	abcd@hotmail.com
IM743302	1	Test D	abcd@hotmail.com
IM743375	1	Test D	abcd@hotmail.com
IM743376	1	Test D	abcd@hotmail.com

[p_verkooijen]

You need to create separate alerts, then use Set Analysis to create an alert for Group TestA and Group TestB

{<Group={'Test A'}>}

[DavidFoster1]

I know you have a solution to your question, but I would recommend that you look at third party reporting options like NPrinting for this kind of work instead of using alerts. Alerts require the document to be open in desktop or in IE client, which is a 'stop gap' type of approach.. Whereas something like NPrinting can be set to run on a formal scheduled batch process.

You also can have greater flexibility about the information contained in the emails if you dont rely on Alerts' limited options.

[#6]

Hi Paul,

Should i apply the set analysis in the mail recipients alert. Can you pls give a example.