Maximo Open Forum

 View Only

  • 1.  Filter work order closure on who 'completed' the work order

    Posted 08-01-2023 06:53

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


  • 2.  RE: Filter work order closure on who 'completed' the work order

    Posted 08-08-2023 14:22

    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


  • 3.  RE: Filter work order closure on who 'completed' the work order

    Posted 08-21-2023 05:18

    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


  • 4.  RE: Filter work order closure on who 'completed' the work order

    Posted 08-22-2023 01:24

    In Work Order Application, Click on Advance Search Drop Down -> Where Clause. Inside the same paste the SQL which is shared by Adam

    Again the query needs to be modified as per the database which you are using,  also the query shared by Adam will only bring work orders which have status COMP.

    If you have work orders which were completed in the last 6 months and then moved to some other status (e.g. CLOSE) the shared query won't bring those work orders



    ------------------------------
    Invading Moss
    N/A
    ------------------------------

    Original Message


  • 5.  RE: Filter work order closure on who 'completed' the work order

    Posted 08-22-2023 12:37

    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


Related Content