Bug #51 (New): Windchill Max Object Version Query with Links

Olivier Feutseu
2026-04-30T18:37:46Z

Create a SQL SELECT query for Windchill to retrieve all objects with their maximum (latest) version/iteration across all relevant object types, including their associated links (e.g. OwnerLinks, ContentLinks, DescribeLinks, etc.).

The query should identify the latest revision for each object, join the necessary link tables, and return a consolidated result set showing object metadata together with its relationships. It should be optimized for performance and ensure that only the highest available versions are included.