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

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

Query Builder Lifecycle History Example

JeffZemsky
17-Peridot

Query Builder Lifecycle History Example

Example of a report showing how to calculate Days in a Lifecycle state.  This uses older UIs, but the methodology is the same in newer Query Builder

5 REPLIES 5
STEVEG
21-Topaz I
(To:JeffZemsky)

Very nice.  Thank you Jeff.

Thank you for this powerpoint presentation showing how to calculate Days in a Lifecycle state.

You wouldnt perhaps have this in a QML format.?

I am using Windchill Release: 12.1.2.9 and I am not having success creating a report on how to calculate Days in a Lifecycle state.

What you show on your last slide is exactly what I need.

Markh74_0-1721822398387.png

 

 

You have to use example in slide 1 (database function Subtract)

 

Marco_Tosin_0-1721823499637.png

 

 

Marco

Hi there

I do not have this interface. What version of Windchill is this.?

Markh74_0-1721823768275.png

 

As Jeff wrote:

 

Marco_Tosin_0-1721823891174.png

 

You have to choose Database Function "Subtract" on select tab and then two date.

 

 

Marco
Announcements


Top Tags