Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X
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.
Solved! Go to 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.
You can use a query builder report to get an SQL query.
This is a report that might be right for you.
Here you can read how to use a report to get your query
How to get the SQL statement of the Query Builder Report
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.