Maximo User Groups / Conferences

 View Only

  • 1.  Query on WORKLOG field in SR

    Posted 04-12-2022 17:07
    Edited by Maryann Wood 04-12-2022 17:17
    We have the Log tab in our SR Main Application.  

    I would like to add to my query - where worktype = '%'

    Basically SR where there is a worklog. 

    What needs to be added to this - 
    (ei_workgroup = 'CM' and status = 'ASGN')

    Thanks.

    ------------------------------
    Maryann Wood
    Chelan PUD
    ------------------------------


  • 2.  RE: Query on WORKLOG field in SR

    Posted 04-13-2022 09:02
    Hi Maryann,
    I think you are looking for something like this "ei_workgroup = 'CM' and status = 'ASGN' and exists(select 1 from worklog where class = 'SR' and recordkey = ticketid)"

    ------------------------------
    Adam Ames
    Kwik Trip, Inc.
    ------------------------------

    Original Message


Related Content