Maximo Open Forum

Hi everybody 

need to have a query in Service Request application 

retrieve all SRs records with WF active & assigned to user 'X'

Hi Ali Sartwai,

Please try the below query

select * from sr 
inner join dbo.wfassignment wa  on wa.ownerid=sr.ticketuid and wa.ownertable='SR'
and wa.assignstatus='ACTIVE' and wa.assigncode='<userid>' and wa.app='<AppName>';

Thanks!

Sankar