How to show the EPM document status in sql query

Forum|Forum|1 year ago
June 10, 2024
2 replies
940 views

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.

Document Mgmt

Best answer by joe_morton

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.

MarcoTosin

21-Topaz I

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

joe_morton

Answer

18-Opal

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.

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded