Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
I see you tried using Alerts, however you need to use AGGR to determine which CASE's are due.
See attachment
I see you tried using Alerts, however you need to use AGGR to determine which CASE's are due.
See attachment
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 |
You need to create separate alerts, then use Set Analysis to create an alert for Group TestA and Group TestB
{<Group={'Test A'}>}
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.
Hi Paul,
Should i apply the set analysis in the mail recipients alert. Can you pls give a example.