Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Column that groups parent and child WOs?

    Posted Thu November 19, 2020 02:55 PM
    Edited by System Admin Wed March 22, 2023 11:49 AM
    Maximo 7.6.1.2:

    Is there a single column in WORKORDER that can be used to group parent WOs and their children together? (not tasks)
    This would be helpful for ordering WOs in queries.

    I can do this with SQL via the COALESCE() function (Oracle):
    • order by coalesce(parent, wonum)

    But it would be handy if there were a single column that I could use (without doing a calculation).

    Thanks.
    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Column that groups parent and child WOs?

    Posted Tue November 30, 2021 02:36 AM
    I think the ancestor table could probably be used for this.
    Original Message