SQL for folder path and product context

[jfrankovich]

Does anyone know the correct SQL to find the folder path and product context of an object? In particular, we are trying to take an EPMdocument (latest iteration) and find the current product context and folder path for that object.

We can do it in QueryBuilder, but the SQL that it shows does not seem to get the desired results.

Thanks,

John Frankovich

The GSI Group LLC

[jfrankovich]

Does anyone know the correct SQL to find the folder path and product context of an object? In particular, we are trying to take an EPMdocument (latest iteration) and find the current product context and folder path for that object.

We can do it in QueryBuilder and get the folder path and container without any problem, but the SQL that it shows in View SQL does not seem to get the desired results. It only gives numbers and class types. It is not clear what table to reference to get the full folder path and container name resolved.

Thanks,

John Frankovich

[skasoverskiy]

Windchill contexts are stored in WTLibrary and PDMLinkProduct tables. Windchill folders are stored in SubFolder table, EPMDocument iterations are stored in EPMDocument table. That's all tables you will need. In case of SubFolder table you will need to do some recursion.