I don't believe the previous solutions will work. That query:
1) assumes that the Work Order has not been closed yet;
2) that the person who changed the status to Complete was the last person to make a change to the Work Order
but you said that the completed Work Orders are sent to another department for closure.
I'm assuming that by 'the person who completed the Work Order' you mean 'the person who used the Change Status function to change the Status to COMP' -- not something else, such as "last person who recorded Labor Actuals.' If so, the data you need is in the WOSTATUS table, which doesn't have a UI screen that would show you multiple Work Orders at once. To get the data you want, you'll need direct access to the database, or write a report (e.g. with BIRT), or create an application within Maximo based on the WOSTATUS table.
A good starting point, for use with either querying the database directly or for a report, would be this query:
SELECT changeby, COUNT(wonum)
FROM wostatus
WHERE changedate > getdate() - 180 AND status = 'COMP' AND siteid = 'yoursiteid'
GROUP BY changeby;
------------------------------
Travis Herron
Pensacola Christian College
------------------------------
Original Message:
Sent: 08-21-2023 03:45
From: Usama Alvi
Subject: Filter work order closure on who 'completed' the work order
Hi, thank you for the response. However, apologies that I'm not able to understand how to perform this 'select' that you refer to. . .
------------------------------
Usama Alvi
ATBF
Original Message:
Sent: 08-08-2023 14:22
From: Adam Bearden
Subject: Filter work order closure on who 'completed' the work order
Hi Osama,
I don't have a filter but I have a select that will bring up work orders, status and changeby.
select wonum, status, changeby
from workorder
where ((woclass = 'WORKORDER' or woclass = 'CONTRACT' or woclass = 'ACTIVITY') and historyflag = 0 and siteid = 'mysite')and status = 'COMP' and changedate <= to_timestamp ('2023-02-01 00:00:00.000' , 'YYYY-MM-DD HH24:MI:SS.FF')and statusdate <= to_timestamp ('2017-04-01 00:00:00.000' , 'YYYY-MM-DD HH24:MI:SS.FF');
Let me know if this helps, thanks.
Adam
------------------------------
A.S. Bearden, GDIT
'ADAM'
Original Message:
Sent: 08-01-2023 02:58
From: Usama Alvi
Subject: Filter work order closure on who 'completed' the work order
Hi,
I'm currently analyzing who among my team members completed the most work orders in a duration, however, I am unable to find a filter to show which user 'completes' any specific work order. I wish a filter could show a complete list of work orders completed in past 6 months with name of user who completed the WO.
The completed work orders are then routed to another department for verification and closure.
Maximo Version: 7.6.1.
Regards
Osama
#Analytics
------------------------------
Usama Alvi
ATBF
------------------------------