cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

How to show the EPM document status in sql query

MS_10217933
5-Regular Member

How to show the EPM document status in sql query

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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. 

View solution in original post

2 REPLIES 2

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

 

 

Marco

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. 

Top Tags