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

The PTC Community email address has changed to community-mailer@ptc.com. Learn more.

Possibility to load SQL statements in Query Builder Report in Windchill PDMLink

Possibility to load SQL statements in Query Builder Report in Windchill PDMLink

I have read this CS on Technical Support https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS177264&lang=en, so I created this idea because it could be helpful, in some cases, build a SQL report and then load it into query builder.

6 Comments
PTCModerator
Emeritus
Status changed to: Acknowledged
 
uai
9-Granite
9-Granite

For me it's a real pain to do any query with the report generator - just providing a possibility to load sql would be really helpful.

Marco_Tosin
20-Turquoise

In this document there are lots of report ready to use https://community.ptc.com/t5/Windchill-Tips/Resource-for-reporting/m-p/448738#M208

 

You can also look at this TS article https://www.ptc.com/en/support/article/CS328887

 

TimoHügel
4-Participant

This would be so helpful as we have the SQL queries ready to go.

Rebuilding that in the generator is just bad!

mschulze
12-Amethyst

Enabling SQL Scripts would increase the flexibility.

AAgrawal_92
6-Contributor

I am trying to create a count function that counts the number of ECRs for which atleast one work item was given a 'Rework' vote, that way I can count how many ECRs were reworked atleast once and then divide that by total ECRs.

 

first pass yield = 1- (ECRs reworked atleast once/Total number of ECRs)

 

The problem I am facing is because the ECR is linked to work item as a PBO, the counts of ECRs is including each work item of a given ECR where the Rework vote was given.

Also, calculating this ratio seems almost impossible.

Do we need to just download the data and do the calculation in an external tool?