Hello, Can anyone please help me figure out the query via ODBC, to get open work orders, their routing steps, including showing routing step completion? I cannot find the table where that might be stored. Work orders are on Transaction table:

SELECT * FROM  transaction AS t  where t.recordtype = 'workorder'

Work order completions are also on same table:

SELECT * FROM  transaction AS t  where t.recordtype = 'workordercompletion'

I cannot find the list of routing steps saved on the work order (completed yet or not). Thank you!