Thursday 14 February 2019

Result set as alternate of Inbox Assignment | Maximo

Create a result set as an alternate solution of Inbox Assignment; 
A logged in see thoes records which are assigned to him for a specific application.


create a save a query for SR:


ticketuid in (select wfinstance.ownerid from wfinstance join wfassignment on wfinstance.wfid=wfassignment.wfid and wfinstance.active = 1 and wfassignment.assignstatus='ACTIVE' and wfassignment.app='PLUSGSR' and assigncode in (:&USERNAME&))

Save it as Assigned_SR

create a result set on start center and attach this query with SR application, add your desired attributes to display.

and done :)

1 comment:

  1. Hi Abdul Qadeer, came across your suggestion as an alternate of inbox assignment. Recently I came up with similar solution but for work order tracking applicaiton. The below query would do the same I believe:

    workorderid in (select ownerid from wfassignment where app = 'WOTRACK' and assignstatus = 'ACTIVE' and origperson = (select personid from maxuser where upper(userid) = upper(:user) ))

    ReplyDelete