Maximo Open Forum

SELECT wonum 
FROM workorder 
WHERE wonum NOT IN (SELECT wonum FROM woancestor)​

Is that what you are asking for?

Hi Travis,

There is a flaw in your query.  The WORKORDER object exists at the site level.  So, the work order number could be repeated in each site.  You need to involve the SITEID.  I generally find an EXISTS or in this case, a NOT EXISTS statement is much less costly and is faster, but just crafting the SQL statement to involve the fields involved in an index will also be faster.  I've included a version here.


SELECT wonum

SELECT wonum FROM workorder WHERE wonum NOT IN (SELECT wonum FROM woancestor)​

I believe Integrity Checker will also report these.  It might be a good idea to run this in case there are other issues lurking.  I don't recall if it lists the workorders, but you can see the SQL used in the log. 😊

SELECT wonum FROM workorder WHERE wonum NOT IN (SELECT wonum FROM woancestor)​