Need a report to find document expiration date

[sburns]

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.

[Marco_Tosin]

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

[sburns]

Hi Marco,

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

Scott

[Marco_Tosin]

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

[STEVEG]

Hi @Marco_Tosin.

That page is great and I have used it several time.

Just wanted to let you know that the link for Date of PR changing states  is not valid anymore.  It shows Page Not Found.

[Marco_Tosin]

Hi Steve,

thanks for your kind words.

The link of that discussion came from the old community site.

I think you should point moderator to that error and force him/her to solve it.