Maximo Open Forum

 View Only
  • 1.  Work order details reporting object structure

    Posted 05-01-2025 11:18

    We are trying to get the work log for a parent work order where the class is both workorder and activity. Has anyone setup the reporting object structure to pull both classes?


    #MaximoApplicationSuite

    ------------------------------
    Crawford Moore
    V2X
    ------------------------------


  • 2.  RE: Work order details reporting object structure

    Posted 05-05-2025 09:29
    Edited by Stevie Holloway 05-05-2025 09:30

    Hi,

    You might try the following:
     
    Create a relationship on the WORKORDER object with a Child Object of WORKLOG. Add a where clause similar to recordkey=:wonum and class=:woclass and siteid=:siteid
     
    Create a WORKORDER Object Structure with WORKLOG as a child object.



    ------------------------------
    Stevie Holloway
    Tufts University
    ------------------------------



  • 3.  RE: Work order details reporting object structure

    Posted 05-06-2025 19:35

    Hi Crawford

    The only bit of your use case I don't quite understand is the "for a parent work order" and "both workorder and activity"

    Are you wanting to run the report from a task work order to get its parent's work log, or are you running the report from the work order with children and want their work logs, plus the parent's?

    This is a screenshot from an ad hoc report where I have added the work log object

    All you have to do, as suggested by Stevie, is enhance the REP_WORKORDER object, like I have to link the work log.  In this case, I will get the work log from the parent.



    ------------------------------
    Craig Kokay
    Principal Consultant
    COSOL

    email: craig.kokay@cosol.global
    #IBMChampion
    ------------------------------



  • 4.  RE: Work order details reporting object structure

    Posted 05-06-2025 19:53
    I am wanting to the log from both the parent and task on the report. Since the class for the parent is workorder and the task is activity the current join does not work when you query for only the parent.

    Sent from my Verizon, Samsung Galaxy smartphone
    Get Outlook for Android