IC SunsetThe developerWorks Connections Platform is now in read-only mode and content is only available for viewing. No new wiki pages, posts, or messages may be added. Please see our FAQ for more information. The developerWorks Connections platform will officially shut down on March 31, 2020 and content will no longer be available. More details available on our FAQ. (Read in Japanese.)
Topic
  • 6 replies
  • Latest Post - ‏2019-11-05T19:00:45Z by SoCalSun
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

  • jasonverly
    jasonverly
    285 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
    38 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.

  • winterZZR1400
    winterZZR1400
    38 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
    285 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. 

  • SoCalSun
    SoCalSun
    659 Posts

    Re: Maximo escalation send notification every 3 month

    ‏2019-11-05T19:00:45Z  

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

    You're using Oracle? If the field is a date/time and not just date, you can use the trunc() function to truncate the time portion to make it a date field. 

    You might run into some oddness with time zone changes if the time is midnight with statusdate potentially. Make sure to test those edge cases.