IC SunsetThe developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this community and its apps will no longer be available. More details available on our FAQ.
Topic
  • 5 replies
  • Latest Post - ‏2019-10-08T14:05:17Z by jasonverly
newMaximo
newMaximo
10 Posts

Pinned topic Maximo escalation send notification every 3 month

‏2019-10-01T08:14:54Z | condition escalation maximo

Hi all experts,

Appreciate for some help.

I need to send email notification to user when the workorder with status for example 'WAPPR' is not routed for every 3 month from the status date.

For this, i have set up an escalation

condition: status = 'WAPPR' 

Schedule: Every 24 hours
Elapsed time attribute: STATUSDATE

Elapsed time interval: 90 

Interval Unit of Measure: days
Repeat: Y
Escalation Point Condition: Empty

How i'm supposed to put in the Escalation Point Condition to send notification every 3 month which will be checked everyday.

 

Thank you. Regards

Updated on 2019-10-01T08:16:11Z at 2019-10-01T08:16:11Z by newMaximo
  • jasonverly
    jasonverly
    283 Posts

    Re: Maximo escalation send notification every 3 month

    ‏2019-10-01T13:21:09Z  

    Can you give some additional detail on the work order process. Is the WO continuously routed every 3 months or hasn't moved out of WAPPR in the last 3 months?

  • newMaximo
    newMaximo
    10 Posts

    Re: Maximo escalation send notification every 3 month

    ‏2019-10-01T23:59:40Z  

    Can you give some additional detail on the work order process. Is the WO continuously routed every 3 months or hasn't moved out of WAPPR in the last 3 months?

    Hi Jason,

     

    Yes the condition is when the WO hasn't moved out of WAPPR in the last 3 months. An email notification will be send to user for every 3 month from the status date.

    Thank you. Regards.

  • winterZZR1400
    winterZZR1400
    37 Posts

    Re: Maximo escalation send notification every 3 month

    ‏2019-10-02T08:41:24Z  

    Try in the condition (not Escalation Point Condition) STATUS = 'WAPPR' and STATUSDATE < (SYSDATE-90) plus anything else you need. That should send it the first time. Don't repeat or they will get an email every time the escalation runs. I can't think of an elegant way of repeating except another escalation with STATUSDATE < (SYSDATE - 180) etc. Depends how long you expect this problem to go on for. 

    Unless you play with DateDiff and rounding  or MOD and make it occur when the result is divisible by 90 and then tick repeat.

    Updated on 2019-10-02T08:43:41Z at 2019-10-02T08:43:41Z by winterZZR1400
  • winterZZR1400
    winterZZR1400
    37 Posts

    Re: Maximo escalation send notification every 3 month

    ‏2019-10-02T09:29:13Z  

    Try in the Condition MOD(((statusdate - sysdate)- MOD(statusdate - sysdate,1))/90,1)= 0

  • jasonverly
    jasonverly
    283 Posts

    Re: Maximo escalation send notification every 3 month

    ‏2019-10-08T14:05:17Z  

    I tried Winter's solution and found on SQL server this didn't work because the statusdate to getdate() was a very specific number and getting that to be MOD of 90 caused it to miss. I switchted the MOD to be on the date value of statusdate and getdate. This allows the escalation to fire off everyday, but catch a WO every 30d.