Maximo

Column that groups parent and child WOs?

  • 1.  Column that groups parent and child WOs?

    Posted Thu November 19, 2020 02:55 PM
    Edited by User1971 Thu November 19, 2020 03:34 PM
    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.