Skip to main content
S
sburns1-Visitor
1-Visitor
February 23, 2018
Question

Need a report to find document expiration date

  • February 23, 2018
  • 1 reply
  • 3635 views

We have WT Documents with an attribute called EXPIRATION_DATE, and is populated with a date yyyy-mm-dd.

The WT document is located within a Product.

I want to create a report that will search a Product for all documents and display the expiration date.

Other fields would also like to be shown, like name, number, description, title, state, revision.

 

Can someone out there help me with how to use Query Builder, if in fact that is the best way to accomplish this??

 

After I receive the report I want to modify it to list all those documents which expire in 10, 30 and 90 days from a date. This could be done in Excel.. no need for help with this.

 

Thank you in advance.

1 reply

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
February 26, 2018

Take a look at this document https://community.ptc.com/t5/Windchill-Questions/Resource-for-reporting/td-p/448738

 

In it you can find lots of reports ready to use, divided in sections.

 

This report could be helpful for your needs https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS239335

 

 

 

Marco
    S
    sburns1-VisitorAuthor
    1-Visitor
    March 2, 2018

    Hi Marco,

    This is really great information you've passed along to me, thank you so much for it.

    Scott

    Marco Tosin
    21-Topaz I
    Marco Tosin21-Topaz I
    21-Topaz I
    March 2, 2018

    Hi Scott,

    I've spent days writing that document and collecting information with the intention to help people in not doing the same thing, so I'm happy if someone has found my job useful.

     

    Have a nice wee-end

    Marco
    Terms & ConditionsCookie settingsAccessibility statement