How to show the EPM document status in sql query

[MS_10217933]

Version: Windchill 12.1

Use Case: I would like to query all EPM documents with the status 'new' using an SQL query. I want to see all objects marked as 'new' within a workspace that have not been checked in yet.

Description:

Unfortunately, the column 'statecheckoutinfo' does not provide the desired result for me. I want to identify new objects in the SQL query.

[Marco_Tosin]

You can use a query builder report to get an SQL query.

This is a report that might be right for you.

How to get the new object list that are uploaded but not checked-in from Workspace in Windchill PDMLink

Here you can read how to use a report to get your query

How to get the SQL statement of the Query Builder Report

[joe_morton · Accepted solution]

Keep in mind the database will only see New items that have been Uploaded. From the client side, there may be more New items that have not been Uploaded that won't appear in any query.