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

[Marco_Tosin]

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.

[uai]

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]

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]

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

Rebuilding that in the generator is just bad!

[mschulze]

Enabling SQL Scripts would increase the flexibility.

[AAgrawal_92]

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?