Hour based alert

[terp_michael]

Hi,

I have a requirement to set up an alert that must be sent if a business transaction, in my case Service Request, has not been updated for 48 hours.

I have set up the date rule and date type and created an action, but how do I set up the start condition ?

I cannot find a way to set a condition that says "when system date and time = 48 hour date and time", have any of you done something like this ?

best regards

Michael

[VishnAndr · Accepted solution]

Hello Michael.

The way to achieve your needs is create a date type which will calculate "last update + 48 hours" (let's name it 'lud48'). So every time your Service Request is updated this date will be updated too.

After this maintenance of starting condition will be much easier: "current date/time >= lud48'.

Hope this will help.

[terp_michael]

Hi Andrei and Robert,

Thank you for the tips. I had already done what you suggested or at least something similar, but I guess I should have written more details. I have awarded you points for the attention.

I have defined 2 date types, "today's date and time" (TDT) and TDT + 48 hours (TDT48) and their respective date rules. They are set, when I create the Service Request, however, they do not get updated, when changes are done even though the "Determine Date only Once" is not flagged in the date profile entry. This is my first problem, I guess it could be solved by a "set date" function called at order_save.

I have also set up a job to process the alerts, but I have a problem with the start condition. I haven´t been able to find a variable for my expression, but I can see there is an FM in the System Fields to determine UTC, that is the only one I can find that has both date and time in the same variable. UTC is 1 hour from the server, so I can adjust that in the date rule, I will try that.

One last question; Shouldn't current date/time be <= TDT48, we have passed the 48 hours, TDT is newer than the date set 48 hours ago ?

Best regards

Michael

[robert_kunstelj]

Create action that is processed by report. In action set condition to "if current date is larger then creation date + 2 days". Next you have to schedule a job to trigger alert if the condition is met.