Topic
  • 7 replies
  • Latest Post - ‏2012-12-17T15:19:03Z by SystemAdmin
wikin
wikin
41 Posts

Pinned topic SR notification with an Interactive Workflow

‏2012-12-13T11:14:39Z |
Hi,

I have created an interactive Workflow in Service Request Applikation ( see attachment).
When the workflow routes a service Request is created, an email (SR notification) will be sent to any User’s. In the condition I have a sql statement, that checked the COMMLOG table, whether an email has ever been sent. If no ( If in commlog table is not entry for the sr. ticketuid) then an email should be sent. It works. But when I create from SR a Change or Problem or an Incident (related Ticket) then the email notification not be sent out.
What's here wrong ?

Thanks for your help !
Updated on 2012-12-17T15:19:03Z at 2012-12-17T15:19:03Z by SystemAdmin
  • P.Heath
    P.Heath
    199 Posts

    Re: SR notification with an Interactive Workflow

    ‏2012-12-13T11:54:14Z  
    Add COMMLOG.OWNERTABLE to your sql statement.

    Best regards,
    Paul Heath Armengol

    Methodology Consultant & Maximo/Rational Tools Administrator
    COSTAISA S.A.
    Barcelona, Spain
  • wikin
    wikin
    41 Posts

    Re: SR notification with an Interactive Workflow

    ‏2012-12-13T13:20:28Z  
    • P.Heath
    • ‏2012-12-13T11:54:14Z
    Add COMMLOG.OWNERTABLE to your sql statement.

    Best regards,
    Paul Heath Armengol

    Methodology Consultant & Maximo/Rational Tools Administrator
    COSTAISA S.A.
    Barcelona, Spain
    Hello Paul,
    thanks for you answer. I my sql statment I have already commlog.ownertable. This is my sql statment

    (status!='CLOSED') and (exists (select * from maximo.commlog where ownertable='SR' and ownerid=:ticketuid and subject like '%aufgenommen'))

    Best Regards and Thanks
  • P.Heath
    P.Heath
    199 Posts

    Re: SR notification with an Interactive Workflow

    ‏2012-12-13T13:36:16Z  
    • wikin
    • ‏2012-12-13T13:20:28Z
    Hello Paul,
    thanks for you answer. I my sql statment I have already commlog.ownertable. This is my sql statment

    (status!='CLOSED') and (exists (select * from maximo.commlog where ownertable='SR' and ownerid=:ticketuid and subject like '%aufgenommen'))

    Best Regards and Thanks
    Workflows, and comm. templates for that matter, are object specific. That means that a WF for SRs does not work for INCs or PROBs.

    Best regards,
    Paul Heath Armengol

    Methodology Consultant & Maximo/Rational Tools Administrator
    COSTAISA S.A.
    Barcelona, Spain
  • wikin
    wikin
    41 Posts

    Re: SR notification with an Interactive Workflow

    ‏2012-12-13T17:21:32Z  
    • P.Heath
    • ‏2012-12-13T13:36:16Z
    Workflows, and comm. templates for that matter, are object specific. That means that a WF for SRs does not work for INCs or PROBs.

    Best regards,
    Paul Heath Armengol

    Methodology Consultant & Maximo/Rational Tools Administrator
    COSTAISA S.A.
    Barcelona, Spain
    Hi, P.Heath,

    thanks for your answer. I have so tried:

    (status!='CLOSED') and (exists (select from maximo.commlog where (ownertable='SR' and ownerid=:ticketuid) or (ownertable='PROBLEM' and ownerid=:ticketuid) )) But it did not work.

    Can it ever work with such a Workflow ?

    Best Regards and thanks
  • P.Heath
    P.Heath
    199 Posts

    Re: SR notification with an Interactive Workflow

    ‏2012-12-13T20:48:26Z  
    • wikin
    • ‏2012-12-13T17:21:32Z
    Hi, P.Heath,

    thanks for your answer. I have so tried:

    (status!='CLOSED') and (exists (select from maximo.commlog where (ownertable='SR' and ownerid=:ticketuid) or (ownertable='PROBLEM' and ownerid=:ticketuid) )) But it did not work.

    Can it ever work with such a Workflow ?

    Best Regards and thanks
    No it won't, like I said WFs only work on one specific object, so you have to create a WF for each type of object.

    I would recommend using escalations (also specific to each object) to fulfil your needs.

    Best regards,
    Paul Heath Armengol

    Methodology Consultant & Maximo/Rational Tools Administrator
    COSTAISA S.A.
    Barcelona, Spain
  • wikin
    wikin
    41 Posts

    Re: SR notification with an Interactive Workflow

    ‏2012-12-17T09:41:51Z  
    • P.Heath
    • ‏2012-12-13T20:48:26Z
    No it won't, like I said WFs only work on one specific object, so you have to create a WF for each type of object.

    I would recommend using escalations (also specific to each object) to fulfil your needs.

    Best regards,
    Paul Heath Armengol

    Methodology Consultant & Maximo/Rational Tools Administrator
    COSTAISA S.A.
    Barcelona, Spain
    Hi PHeatch,

    Thanks for your answer. I do not understand it anyway. I want to send a notification only for sr, even if I make a change from an SR - I want to send a notifikation ONLY for SR.
    Best Regards and Thanks
  • SystemAdmin
    SystemAdmin
    5842 Posts

    Re: SR notification with an Interactive Workflow

    ‏2012-12-17T15:19:03Z  
    • wikin
    • ‏2012-12-17T09:41:51Z
    Hi PHeatch,

    Thanks for your answer. I do not understand it anyway. I want to send a notification only for sr, even if I make a change from an SR - I want to send a notifikation ONLY for SR.
    Best Regards and Thanks
    Hi Wikin,

    Write a escalation which will sa=can your required crieteria and send the email notification...