Topic
7 replies Latest Post - ‏2012-12-17T15:19:03Z by SystemAdmin
wikin
wikin
37 Posts
ACCEPTED ANSWER

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
    186 Posts
    ACCEPTED ANSWER

    Re: SR notification with an Interactive Workflow

    ‏2012-12-13T11:54:14Z  in response to wikin
    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
      37 Posts
      ACCEPTED ANSWER

      Re: SR notification with an Interactive Workflow

      ‏2012-12-13T13:20:28Z  in response to P.Heath
      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
        186 Posts
        ACCEPTED ANSWER

        Re: SR notification with an Interactive Workflow

        ‏2012-12-13T13:36:16Z  in response to wikin
        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
          37 Posts
          ACCEPTED ANSWER

          Re: SR notification with an Interactive Workflow

          ‏2012-12-13T17:21:32Z  in response to P.Heath
          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
            186 Posts
            ACCEPTED ANSWER

            Re: SR notification with an Interactive Workflow

            ‏2012-12-13T20:48:26Z  in response to wikin
            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
              37 Posts
              ACCEPTED ANSWER

              Re: SR notification with an Interactive Workflow

              ‏2012-12-17T09:41:51Z  in response to P.Heath
              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
                ACCEPTED ANSWER

                Re: SR notification with an Interactive Workflow

                ‏2012-12-17T15:19:03Z  in response to wikin
                Hi Wikin,

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