Maximo User Groups / Conferences

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
------------------------------

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.
------------------------------