Maximo Open Forum

 View Only
  • 1.  Search workorder records not inserted in woancestor through query

    Posted 11-01-2022 11:54
    Does anyone have query to find the missing records of woancestor table that are present in workorder but its entry is not made woancestor table by system.

    #WorkManagement

    ------------------------------
    Ramesh Kumar
    student
    ------------------------------


  • 2.  RE: Search workorder records not inserted in woancestor through query

    Posted 11 days ago
    SELECT wonum 
    FROM workorder 
    WHERE wonum NOT IN (SELECT wonum FROM woancestor)​

    Is that what you are asking for?



    ------------------------------
    Travis Herron
    Pensacola Christian College
    ------------------------------