cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Resource for reporting

100% helpful (1/1)

I don't know if this is the right way, but since this group is growing, maybe we could work on this document to insert useful resource for reporting.

 

I leave the document open, so everyone can add other useful things.

 

Maybe you can vote up also these three ideas:

 

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

 

Report: PTC have to share what TS do about it with their customer

 

Set the query limit only for Reports in Windchill PDMLink

 

 

 

As you can read on this discussion, Albert Anderson gave us a link about Windchill UML Model Documentation - English

 

Another useful document about query builder from Albert Anderson

Query Builder for Live Project Status Reports (NPI, Large Engineering Change, etc.)

 

Another article about UML from TS

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS188216&lang=en&source=community

 

I think it could be helpful also to catalogue report for argument, when it comes from other discussion, having a single source.

In bold macro argument, below title of report (in parenthesis owner of the report) and then link to download report or to TS article.

 

 

At the end of this document you can download a presentation (from Rebecca French of PTC Global Services)

It's very very old (Windchill 6.2), but it could be still useful for people who wants to take the first steps in the world of reporting.

 

Another document attached at the end, from Dax Williams (at PTC/User), is about creating a Windchill report interface in Excel.

 

TIPS and TRICKS

 

Documentation about relations in Query Builder in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS53948

 

Understanding database table relationships in Windchill to generate queries or build Windchill Reports

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS51689

 

How to expose Query Builder report at context level in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS42087

 

Automatic report creation (Mike Lockwood from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=16373

PTC Community Document: Automatic report creation

 

Below returns latest Iteration of each Revision (Mike Lockwood from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=11386

PTC Community Document: query builder Latest Revision

 

Explanation of tables that store build information between CAD Documents and Parts and the different "BuildType" values in Windchill PDMLink 10.1 (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS125790&lang=en&source=community

 

How to create a query builder report that accepts multiple inputs (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS190138

 

How to enter multiple values when generating a Query builder report in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS162759&lang=en&source=community

 

How to get query builder report into Cognos, create report and push it back to Windchill PDMLink 10.1 (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS148905&lang=en&source=community

 

How to have Info*Engine query results be returned in a CSV file (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS187236&lang=en&source=community

 

How to hide the "Saved Reports" for particular user (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS190136

 

How to load .QML reports into Windchill PDMLink 10.0 (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS113617&lang=en&source=community

 

How to load a Query Builder report exported as QML from the command line (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS187335&lang=en&source=community

 

How to make reports available to users in Windchill PDMLink 10 (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS182027&lang=en&source=community

 

How to run Query Builder report from Microsoft Excel in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS162869&lang=en&source=community

 

How to use the Custom Input Page for a QueryBuilder Report in Windchill PDMLink 10.1 (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS130739&lang=en&source=community

 

How to understand Change Management objects and their relations in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS63595&lang=en&source=community

 

How to use different date ranges as criteria in a Query Builder report in report manager (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS153996&lang=en&source=community

 

Improve Process Efficiency with Windchill Business Reporting (Vishal Arora from PTC/User)

http://portal.ptcuser.org/p/do/sd/sid=727&fid=748&req=direct

PTC Community Document: Improve Process Effiiciency with Windchill Business Reporting

 

List of "types" that one can select for building query builder reports (Mike Lockwood from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=10071

PTC Community Document: Types available in query builder

 

Multi-valued attributes display multiple times within a Query Builder report
https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS53268

 

Overview of link objects in Windchill (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS131357&lang=en&source=community

 

Possibility to make reports in the query builder default to search in the current container

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS96881

 

Query Builder Report displays duplicate entries (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS146646

 

Query Builder Report returns duplicate results when "Distinct" option is selected in the "SELECT Tree" (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS201994&lang=en&source=community

 

Query Builder Report shows duplicated row for the same Part in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS202500&lang=en&source=community

 

Query Builder Report Weirdness (From PTC/User)

http://portal.ptcuser.org/p/fo/st/topic=16&post=121477#p121477

PTC Community Document: Query Builder Report Weirdness

 

Query builder report to fetch all the values of the multivalued attribute in single row (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210938

 

Search on Windchill Report Builder are case sensitive though the Select criteria is "like"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS168769

 

Where is the documentation for how to add Business Reporting to an existing Windchill installation?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS115821

 

Windchill Business Reporting (Avinash Kor from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=9354

PTC Community Document: Windchill Business Reporting (Edited)

 

Windchill Database Relationships - CAD Document Parameters (Tom Uminn)

Windchill Database Relationships - CAD Document Parameters

 

How to create bar chart report with number of records created in each month

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223720

 

Use of Options in the Select Tab of Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS35281

 

Information regarding how to use the Query Builder functions

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS83196

 

How can a report be run on a schedule and emailed to a user in Windchill PDMLink?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS140996

 

Query builder report to display "Comments" column of Object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS157262

 

How to allow users to see all part numbers even though they do not have access to all parts?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223072

 

How to add Info (Details Page) button and email links in query builder reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227239

 

Query Builder Criteria Logic for getting last month

https://www.ptcusercommunity.com/thread/130187?sr=stream&ru=357802

 

Query builder decode function

Query builder decode function

 

Using Java interfaces in QueryBuilder reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS33057

 

How to retrieve the Date with no Hours:Minutes:Seconds in Query builder report using the function

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS139088

 

Using Java Methods in Query Builder

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS114482

 

How to limit Access to Report Template

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS71222

 

How to specify the output format of a QML report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS131663

 

How to find the new name of an object when only the old name is known?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS239797

 

How to retrieve attribute and its value on an object using Report Management

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS115300

 

What tables are global attribute definitions and values stored

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS53787

 

How to generate IQY query for Report Manager reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS47169

 

Database tables references for Security Audit Reporting

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS31046

 

How to use Concatenate function in Criteria section of Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS241697

 

In Query Builder Report how to group the results

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS162153

 

How to make Report Template available for use with Advanced Search in Windchill 11

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245106

 

How to make a Query Builder report to fetch all the related documents for a specific BOM

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245097

 

How to write a report that shows the association type between CAD Document and WTPart

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS17200

 

What are the steps to restrict visibility of Reports available on Saved Reports table for Users or Groups

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS244932

 

How to add a hyperlink to an object's Details page in Report Manager in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS82387

 

How to use QML reports upgraded from Windchill PDMLink 9.1 with Legacy Mode in Windchill PDMLink 11

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246736

 

How to get the Checked out date of a CAD Document in a Report in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246873

 

What is the relationship between WTUser, remoteobjectinfo and remoteobjectid tables in Windchill PDMLink database

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS94037

 

Restrict Access by Roles to Query Builder Reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249618

 

How to ensure Report Templates and Reports  are available for use in Advanced Search in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245106

 

 

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

 

Access Policy Rules by Context (Dax Williams from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=2675

 

Display the roles of a user (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-35310-165974-28509/ContextTeams-Products.qml.zip

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-35310-165974-28510/User+Accounts.qml.zip

 

Extract policy rules (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-55886-251502-70950/ACLs+-+alternate+approach.qml.zip

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-55886-251502-70951/ACLs.xml

 

Explanation of tables that store build information between CAD Documents and Parts and the different "BuildType" values (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS125790&lang=en&source=community

 

Find rename objects (Lori Lee Sood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-50412-221716-56907/FindRenamedObjects.qml.zip

 

Global Attribute Enumeration

https://www.ptcusercommunity.com/thread/119387?sr=stream&ru=281467

 

How to create a report that counts WTParts in a specific context with Query Builder in Windchill 10 (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS111896&lang=en&source=community

 

How to create query builder report of the empty folders in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS186510&lang=en&source=community

 

How to export all ACL's related to a specific user

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS123564

 

Last Login by user (Mike Lockwood)

User Account - Last Login Report QML

 

List of users (Mike Lockwood from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=18287

 

OIR's (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-55759-250741-70657/OIRs.qml.zip

 

Policy rules (Darren Storey)

http://portal.ptcuser.org/p/fo/do/download=1&fid=23549

https://www.ptc.com/appserver/cs/view/solution.jsp?n=CS116472&posno=9&q=export%20ACL&nav=ptcproductgroupshttps://www.ptcusercommunity.com/servlet/JiveServlet/download/6144-2-69351/ACL+compare2.qml.zip

https://www.ptcusercommunity.com/servlet/JiveServlet/download/6144-2-69351/ACL+compare2.qml.zip

 

Policy rules (same format as displayed by Policy Administration applet)

http://communities.ptc.com/docs/DOC-6567

 

Query Builder Report listing all the Teams of which a specified Group is a Member in Windchill PDMLink and Windchill ProjectLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS201550&lang=en&source=community

 

Query Builder Report to fetch the reassigned task's Status Description for Project Activity (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS204338

 

Query builder report to fetch product, role and user from role

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS189509

 

Query builder report to fetch "last logged in" of users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS220318

 

Query Builder Report to list all objects shared between projects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209852

 

Query Builder report to show folders with associated domains

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS44018

 

Report with a list of Products having a specific role (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-56841-256758-72950/Context+Teams.qml.zip

 

Reporting - Groups and Users (Shreyas Atre from PTC/User)

RE: Reporting - Groups and Users

 

Types and mapped attributes (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-55554-249262-69944/Types+and+mapped+attributes.qml.zi…

 

User login date (Dax Williams from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=15121

http://portal.ptcuser.org/p/fo/do/download=1&fid=15122

 

Product Team Listing (Steven Rector from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=27557

 

How to generate a Query builder report to display Maturity History of the object

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS28221

 

How to get "Download" event information in Security Audit Reporting

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS135740

 

Query Builder report to fetch latest version of WTDocument,EPMDocument and WTPart in Library Context for particular state

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS142076

 

QML Report to list all the Users in Organization

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS198022

 

How to list Classification Nodes and their related attributes

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS220979

 

QML report to retrieve the Distinguished Name of all Users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS221494

 

Query builder report for listing prohibit publishing objects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS226376

 

Is there a way to Search Check in comments for CAD or Documents

https://www.ptcusercommunity.com/thread/130236?sr=stream&ru=364762

 

QML report to fetch all the objects that were renamed/renumbered in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS180898&lang=en&source=community

 

  •           Link to report from Dax Williams taken from other documents in the community

Action Item with Workflow Process

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111660/ACTION%20ITEM_Action%20Item%20with%20Workflow%20Process.qml.zip

 

Attribute Ids by Name

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111682/ADMINISTRATIVE_Attribute%20Ids%20by%20Name.qml.zip

 

Attribute Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111683/ADMINISTRATIVE_Attribute%20Info.qml.zip

 

Document Template Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111686/ADMINISTRATIVE_Document%20Template%20Info.qml.zip

 

User Login Audit

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111789/ADMINISTRATIVE_User%20Login%20Audit.qml.zip

 

User Login Totals

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111788/ADMINISTRATIVE_User%20Login%20Totals.qml.zip

 

User Specified Preferences

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111696/ADMINISTRATIVE_User%20Specified%20Preferences.qml.zip

 

Preferences

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111680/ADMINISTRATIVE_9.1%20Preferences.qml.zip

 

Quantity of Measure

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111692/ADMINISTRATIVE_Quantity%20of%20Measure.qml.zip

 

Report Manager Report List

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111693/ADMINISTRATIVE_Report%20Manager%20Report%20List.qml.zip

 

Team Template Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111694/ADMINISTRATIVE_Team%20Template%20Info.qml.zip

 

Part Version Scheme

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8682-1-111704/AUDIT_Part%20Version%20Scheme.qml.zip

 

Lifecycle Template Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111688/ADMINISTRATIVE_Lifecycle%20Template%20Info.qml.zip

 

Library_Product_Project Templates

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111687/ADMINISTRATIVE_Library_Product_Project%20Templates.qml.zip

 

Total EPMDocuments and File Size by Context

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111791/ADMINISTRATIVE_Total%20EPMDocuments%20and%20File%20Size%20by%20Context.qml.zip

 

WTDocuments with File Size

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111787/ADMINISTRATIVE_WTDocuments%20with%20File%20Size.qml.zip

 

How to display all WTParts with Successful ESI Distribution Target using a report

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS58679

 

Query builder report to fetch number of object in each Context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS149816

 

Query builder report to retrieve the Team, Roles and Users associated to Variances

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229148

 

QML report to generate Access Control Lists applied in a specific context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS146799

 

How to get the Name and Context from any object based on the file vault file name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229938

 

How to prepare Query Builder report to generate the Product/Project/Library team members

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS28414

 

QML Report to generate Access Control Lists applied in a specific context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS146799

 

Gather a report from WVS job monitor

https://www.ptcusercommunity.com/ideas/6338

 

Query builder report to list all active users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209700

 

How to generate a report listing the projects and tasks where a resource is used

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS98782

 

QML which gives list of activities (like checkin, checkout etc) performed through both std browser

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS151749

 

Query Builder Report listing additional information not contained in a security audit report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS234696

 

How to get the Name and Context from any object based on the file vault file name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229938

 

How to determine the number of WtPart in the Commonspace in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS235473

 

QML report showing 'No Content association between the Drawing and WTPart'

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227183

 

How to identify users listed in the Usage and License Reporting

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS107490

 

Family tables with instances not at same revision as generic

https://www.ptcusercommunity.com/thread/136958?sr=stream&ru=288561

 

Querybuilder report to display access available to users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS162218

 

Report showing the OID for products, library and project

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS237841

 

Query builder report to fetch Distinguished Name of the user and user name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS244704

 

Query Builder report to display WTParts having representations

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247241

 

Query builder report to fetch Choices and their associated WTPart in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247434

 

How to get a report of all Required attributes of a Classification Structure in Windchill PartsLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247059

 

How to build a report to list all customer specific preferences in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249136

 

How to create a report listing the resource allocation over multiple Projects in Windchill ProjectLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249153

 

How to determine if an attribute type defined in Windchill is used anywhere in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS175010

 

How to generate query builder report which displays user with associated subscriptions

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS23188

 

 

CHANGE MANAGEMENT (ECR, ECN, PR, ...)


Change request that has no associated change notice (Lori Lee Sood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-50352-221824-56945/CRwithoutCN.qml.zip

 

Change Request Workflow Tasks (Lewis Lawrence from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=6456

 

Change Record Status - Open (Steven Rector from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=27558

 

Change Notice Report detailing Name, Description, Current Assignee, Total Days Open, Days for Current Task and Due Date (Don Senchuk)

Change Notice Report.qml

 

Change Activity Report detailing Name, Description, Current Assignee, Total Days Open (for parent CN), Days for Current Task, Need Date (Don Senchuk)

Change Task Report.qml

 

ECN and the count of WTParts for that ECN (Dax Williams from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=751

 

How to generate QML report for the ECN created in a 30 days using Query Builder (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS198747&lang=en&source=community

 

How to generate a report listing Change Notice task Comments in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS167392&lang=en&source=community

 

How to get "Promoted on" attribute into a Change Notice report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS115668

 

 

https://www.ptcusercommunity.com/servlet/JiveServlet/download/423256-105730/ProblemReportComments.qml.zip

 

QML attached - outstanding change work items with related change objects (Darren Storey from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=24907

http://portal.ptcuser.org/x/fo/st/imagelb?fid=24908&topic=16

 

Query Builder report to get Affected End Item Parts added to Change Requests Affected End Item table (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS149307&lang=en&source=community

 

Query builder report of all the assignees of Change Notice/Change Activity in Windchill (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS179409&lang=en&source=community

 

Query Builder report for counting the Affected Objects in a Problem Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS213950

 

QML (total of 6) for getting affected and resulting object of CN (Shreyas Atre from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=21282

 

Report to return the objects in a Change Request (Shreyas Atre from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=20585

 

Released Part Version (Revisions) Linked to Changes (Lewis Lawrence from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=6504

 

How to add custom attributes to Change Notice Log report and Change Request Log report (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS219369

Strictly speaking not a Query builder report, but rather a customization of the OOTB info*engine based report. Nevertheless I thought it was useful to add it here.

 

How to create a visual monitor report that shows open, in progress and complete Change Requests

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS224065

 

Query builder report to fetch problem report with associated part

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS226330

 

Change object Date Completed

https://www.ptcusercommunity.com/thread/129761?sr=stream&ru=5134

 

QML report to fetch all Change Notice and their associated Team template

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS228394

 

How to generate a report listing Change Request and the affected objects?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS52010

 

Query builder report to list Change notice with no affected objects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229390

 

Change Notice, Change Task, Votes, Assignee, Due Date, Completed Date, Last Modified Date

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS48714

 

What is the relationship between Change and Changeable Object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS106301

 

QML report to retrieve ECNs and their related EPMDocuments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS239710

 

Change Requests and their connected Problem Reports

https://www.ptcusercommunity.com/thread/43627?sr=stream&ru=35352

 

How to get a list of all the ECNs in the Application for a particuar Need Date

https://www.ptcusercommunity.com/thread/133770?sr=stream&ru=36103

 

Query builder report (QML) to fetch problem report with part

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS226330

 

Report listing all Change Requests without an associated Change Notice

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS144673

 

Is it possible to link Problem Report and Nonconformance in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249232

 

Report listing Change Request and the affected objects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS52010

 

 

EPMDoc REPORT

All Checked Out CAD Docs with Workspace and User (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-56287-253837-71801/Checked+Out+CAD+Docs+with+Workspac…

 

Checked out CAD Documents (Christophe Laudou from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=3474

 

EPM Document and the Life Cycle Template the EPM Document is using (Shreyas Atre)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-52705-233403-62298/LCTEmplate.qml.zip

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-52705-233403-62297/LC+Join.png

 

EPMDoc that have been modified in a given period (Darren Storey from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=19547

 

EPMDocument Markup and Annotation Report by CAD Object and/or User (Dax Williams)

https://www.ptcusercommunity.com/docs/DOC-7581

 

Getting the related Promotion Requests of a Drawing (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-56288-253820-71793/CAD+Doc+-+related+Promotion+Reques…

 

Link between EPMDocuments and WTParts (Tristan Owen)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-52705-250976-70777/EPMandWTPart.qml.zip

 

Link between EPM and Life Cycle template (Shreyas Atre from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=23403

http://portal.ptcuser.org/x/fo/st/imagelb?fid=23404&topic=16

 

How to create a Query Builder (QML) report which will list the instances associated with Generics of Family Tables (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS29111&lang=en&source=community

 

Numbers of  CAD documents (*.asm, *.prt) and their drawings (*.drw) [Tristan Owen]

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-39509-197193-47739/EPM_DrawingReference.qml.zip

 

Query to get downstream MPMLink parts from Design view WTParts (Mike Lockwood from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=14664

 

QML report showing ‘EPMDocument associated with the WTPart’ in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS23768&lang=en&source=community

 

Query Builder report that lists the size of CAD Documents and their location in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS42155&lang=en&source=community

 

Query Builder: Soft Type attributes for EPMDoc (NacNac Mott from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=18529

http://portal.ptcuser.org/p/fo/do/download=1&fid=18530

 

Query Builder report to fetch checked out objects in user's workspace

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS134496

 

Query builder report to fetch the EPMDocuments having annotation

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210700

 

QML report showing ‘EPMDocument associated with the WTPart’ for Content association (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS23768&lang=en&source=community

 

QML to find workspaces and CAD Doc's in them (Mike Lockwood)

QML to find workspaces and CAD Doc's in them

 

Report from WTPart to EPMDocument including the family table values (Mike Lockwood from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=14665

 

Where Used (Latest Version of Objects) (Marc DeBower)

Where Used (Latest Version of Objects)

 

Workspace creation, last modified, etc. (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-56658-256774-72916/Workspace+attributes.qml.zip

 

WTPart Object ID based on the EPM Document Object ID, Version and Iteration (Tristan Owen)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-52705-251287-70853/EPMandWTPart_IDandVersionLink.qml.…

 

WTParts with Associated Described By Documents (Mike Lockwood from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=14654

 

Query Builder report to list all the Publish EPMDocument in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS191374&lang=en&source=community

 

How to get a list of all family table instances with a status of "Unverified" or "Unknown"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS40247

 

Query Builder Report to fetch the universally uploaded object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227691

 

How to build a report for latest version of EPMDocuments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS33305

 

How to add Promoted By and Promoted On in advanced search criteria

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS55947

 

Anyone have a way to find nested family tables?

https://www.ptcusercommunity.com/thread/134675?sr=inbox&ru=369970

 

Query Builder Report which lists the user and workspace names for checked out versions of CAD Document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS232560

 

How to get the latest EPM DOCrevision using Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS184264

 

Family Table Report with Related WTParts

https://www.ptcusercommunity.com/docs/DOC-8798?sr=stream&ru=3370

 

Report to list all drawings without primary content for CAD document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS237391

 

How to create a query builder Report that shows Revision History of Drawings which is a soft type of EPM Document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS236226

 

Report to fetch all EPM Documents having copied from representation

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223584

 

Report to generate all EPMDocument with all iteration of Lifecycle Template

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS143164

 

Find all EPM Documents without Visualisation

https://www.ptcusercommunity.com/thread/127349?sr=stream&ru=6342

 

How to get the Checked out date of a CAD Document in a Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246873

 

How to build a report of objects added to workspaces

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS202379

 

All EPMdocuments with secondary attachments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249915

 

Query Builder report [QML] to list all Workspaces

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS250740

 

 

PROMOTION and WORKFLOW

All the outstanding workflow work items for the current user (Darren Storey from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=24898

 

All the workflow tasks assigned to a user in Windchill PDMLink (Binesh Kumar)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/419101-104206/%20Assigned%20Tasks%20By%20User%20Name.qml.z…

 

All info of interest for all Workflow Activities from a give workflow template (Mike Lockwood from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=15994

 

Date of PR changing states (Lori Lee Sood)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-49787-219926-56116/PR_States.qml.zip

 

How to generate QML report for the Tasks past deadline using Query Builder in Windchill PDMLink 10.2 (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS180709&lang=en&source=community

 

How to generate a report with events from workflow tasks in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS32218&lang=en&source=community

 

How to get an assigne name (in a role) from a workflow (Community)

https://www.ptcusercommunity.com/message/426199?et=watches.email.thread#426199

 

In which database tables are stored the workflow execution objects?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS214035

 

QML report returning runtime routing list for Setup Participants from a workflow

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210243

 

Query Builder report to fetch reassign information of a promotion request (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS162802&lang=en&source=community

 

Report to find out values of Promotion Preferences

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS215586

 

Report to list workflow tasks assigned to disconnected users in Windchill (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS178728

 

Windchill Data Model for Workflow related objects in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS153902&lang=en&source=community

 

Query Builder Lifecycle History Example

https://www.ptcusercommunity.com/docs/DOC-8716

 

Report showing date of last promotion

https://www.ptcusercommunity.com/thread/135310?sr=stream&ru=263245

 

How to generate Query Builder report to display "Promoted on" attribute from the Maturity History table of an object

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS11566

 

How to retrieve records for delegation/reassignment

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS39534

 

Query builder report to fetch the Open Task assigned to User in a Product

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246581

 

 

WTDOCUMENTS

How to link betweeen a WTDocument and a Package (Lori Lee Sood)

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS131346&lang=en&source=community_US

 

How to create a "Query Builder" report listing all "Packages" with all "Document" in "Package Content"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS219079

 

How to link WTDocument and its primary content (Binesh Kumar)

Re: Report on WTDocument File

 

Info about the vaulted file on disk (Mike Lockwood)

https://www.ptcusercommunity.com/servlet/JiveServlet/downloadBody/3088-102-1-3664/VaultedWTDocFiles.qml.zip

 

QML to generate URL for document (Shreyas Atre from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=23333

 

Query Builder report to display WTDocuments having representations (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS166540&lang=en&source=community

 

Query builder report to fetch all WTDocuments with no primary content (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS167918&lang=en&source=community

 

Query builder report to list Documents from folder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS208539

 

Report to find WTDocuments went for Approval Routing in Windchill ProjectLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS207521

 

Report to search for Documents by Effectivity

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209206

 

What are the tables and joins required for generating a query builder report for Documents without any Primary Content and Attachments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209629

 

QML report to count the number of documents by different document types

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS216381

 

How to identify the template that was used to create documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS214070

 

Report all WTParts related to WTDocuments

https://www.ptcusercommunity.com/thread/115318?sr=stream&ru=30733

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS36007

 

How to create a report listing Documents Context, Name, Number, State, Latest Revision & Iteration, and Age

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS239335

 

File Name of a document from Query Builder

https://www.ptcusercommunity.com/message/457256

https://www.ptcusercommunity.com/servlet/JiveServlet/download/457256-119614/_Document_Search.qml.zip

 

Report to generate BOM report with Described By and Referenced By Documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS238476

 

Report to get the document, its state and the role responsible to complete the task

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245051

 

Query builder report to fetch document which is not related to any other document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247264

 

How to build a report for latest revision of WTDocuments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS251987

 

 

WTPARTS

 

How to create a Where Used report for WTParts

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210416

 

How to report "Release Date" of WTPart? (from PTC/User)

http://portal.ptcuser.org/p/fo/st/topic=16&post=122009#p122009

 

How to write a WTPart Where Used Report (Mike Lockwood)

Report Manager: How to write a WTPart Where Used Report

 

How to determine the number of unique part numbers site wide (Tom Uminn)

How to determine the number of unique part numbers site wide in Windchill?

 

How to get the bill of material (BOM) report for latest iteration of latest version for Document Object using Report Manager (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS200270&lang=en&source=community

 

QML Report to list all Part Instance with its Base Part (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS203321&lang=en&source=community

 

QML Report to list all WTPart of Specific View in Windchill PDMLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS198025&lang=en&source=community

 

QML Report to to show association between Deviation and it's associated WTPart

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS205475

 

Query builder report to fetch the display name and internal name of classification node in Windchill PartsLink (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS184338&lang=en&source=community

 

Query builder report to find all WTParts and their corresponding PartsLink classification nodes (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS129984&lang=en&source=community

 

Query builder report to list WTParts from folder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS208537

 

Query Builder Report to list all the OEM part which do not have AML\AVL Part associated

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210102

 

Query builder report to fetch parts at level 0 in structure tab

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS215346

 

Which Database tables store classification attributes in Windchill PartsLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS172788

 

WTParts not been published to ERP system (Marco Tosin from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=23280

 

QML report to query latest version of all WTParts

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS138336

 

How to get a query builder report for Classification details for Parts and/or Part Structure

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS145972

 

Query builder report to list WTParts of particular view

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS208737

https://www.ptcusercommunity.com/message/425216#425216

 

How to create a Query Builder report to list all Parts that do not have Parent Part

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223922

 

How to select the latest revision of a Part in a Query Builder report

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS1171

 

How to get a report of the URL address of WTparts

https://www.ptcusercommunity.com/thread/134395?sr=stream&ru=281467

 

Query to capture WTParts set to Released in the last 4 hours

https://www.ptcusercommunity.com/thread/134896?sr=stream&ru=51671

 

Query builder report to fetch WTParts in a specific Org that have Part Master Default unit set to "as needed"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS232193

 

Query builder report to find all WTParts and their corresponding PartsLink classification nodes

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS233215

 

Report to verify the details of changes in iterations of Part Instance using Described by Documents

http://support.ptc.com/images/cs/articles/2014/10/20163203_G4Hv.qml

 

Query Builder report to list the Variances reported against Parts

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS234246

 

SuMa - Report to list the Manufacturer associated with the specific Context Organization

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS234911

 

 

TROUBLESHOOTING

Change Requests not automatically associated with corresponding Problem Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS211530

 

Custom reports return error "wt.query.QueryException: Attribute "first" is not a member of class "class wt.org.WTUSER" after upgrading to Windchill PDMLink 10.2

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS194425&lang=en&source=community

 

Failed to delete some report templates from Site>Utilities>Report Management

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS185149

Generating a report from Context > Reports > Change Request Logs caused MethodServer to crash with OutOfMemoryError

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS203309

 

Reports imported or created at Organization level are not available for non-admin users on Homepage

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS52000

 

Report Builder is inadvertently removing a condition from the subquery while attempting to modify the qml with user entered data

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS186246

Using Date Picker in a OOTB Report in a browser that is not in English results a "Timestamp format" Error

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS215342

 

Unable to save configuration of a legacy report in Windchill PDMLink 10.2 M020 (PTC TS)

https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS188794&lang=en&source=community

 

When a variable is used in Select and Criteria section of Query Builder with Input Parameter, report page generated doesn't display alias name of variable in Input Parameters section

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS133386

 

Not able to Save reports having Chart using Organization Admin user giving secured action error

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS179575

 

Failed to export the results generated for Reports using Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS204259

 

Information or Details page for Report Templates shows Creator attribute value as ???createdby??? where creator is not available

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS221397

 

Data monitor criteria filter for created on time of "Yesterday" not covering entire day

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS226634

 

In Report Builder, like operator does not returns exact searched string

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS224643

 

Report result will not be merged even select the "HTML (with merging)" in "Generate Legacy Mode Output"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS222197

 

Soft types created at the organization level not available in Query Builder launched from "Site" > "Utilities"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227163

 

When searching for objects that have empty IBA with "not like" criteria, Query Builder and Search UI will give inconsistent results

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS159539

 

Not able to set up changeable filter criteria in Query Builder Approver Status field for attribute eventlist of type wt.workflow.definer.UserEventVector in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS235453

 

Getting an error message as "Report can only be launched when Windchill Business Reporting is installed" in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS124351

 

Data monitor against "Open Change Notices" report template status is "failed"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS236920

 

Report to list Suppliers (Manufacturer) with their associated Documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS240978

 

Query Builder does not list the Display Name of Sourcing Status attribute values in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS241420

 

Unable to run cognos reports in Windchill 10.2

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210583

 

Reports using macro CURRENT_TIME that used to work before update don’t work anymore in Windchill PDMLink 10.2 M030

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS248659

 

Query Builder Report to get the list of parts which does not have any related document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS251347

 

Upgraded reports where attributes with an enumerated list that were previously defined in the Criteria tab no longer display the enumerated list in the drop-down in Report Builder in Windchill 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS252519

 

When user added java method then selected allow user to decide option all of column user is not able to generate report.

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS253057

Was this tip helpful? Yes No
Comments
ryankelley
‎Aug 12, 2015 12:22 PM
‎Aug 12, 2015 12:22 PM

Brain - the PTC/USER development team got back to me with a fix, can you try some of the resources provided above and let me know if they've successfully resolved the issue on their end?

byork
‎Aug 13, 2015 10:09 AM
‎Aug 13, 2015 10:09 AM

It is working now. 

Thanks!

Marco_Tosin
‎Aug 25, 2015 05:40 AM
‎Aug 25, 2015 05:40 AM

Added below links to Tips and Tricks section:

 

Documentation about relations in Query Builder in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS53948

 

Understanding database table relationships in Windchill to generate queries or build Windchill Reports

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS51689

 

How to expose Query Builder report at context level in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS42087

BineshKumar1
‎Sep 02, 2015 11:17 AM
‎Sep 02, 2015 11:17 AM

Added below links

Report to list workflow tasks assigned to disconnected users in Windchill (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS178728

All the workflow tasks assigned to a user in Windchill PDMLink (Binesh Kumar)

https://www.ptcusercommunity.com/servlet/JiveServlet/download/419101-104206/%20Assigned%20Tasks%20By%20User%20Name.qml.z…

BineshKumar1
‎Sep 25, 2015 04:59 PM
‎Sep 25, 2015 04:59 PM

Added Below Link

How to link WTDocument and its primary content (Binesh Kumar)

Re: Report on WTDocument File

mdebower
‎Sep 29, 2015 11:31 AM
‎Sep 29, 2015 11:31 AM

Added link:

Last Login by user (Mike Lockwood)

User Account - Last Login Report QML

mdebower
‎Oct 02, 2015 01:41 PM
‎Oct 02, 2015 01:41 PM

Added Link:

Where Used (Latest Version of Objects) (Marc DeBower)

Where Used (Latest Version of Objects)

JørnAHansen
‎Oct 04, 2015 10:36 AM
‎Oct 04, 2015 10:36 AM

‌Added link in the CHANGE MANAGEMENT section:

How to add custom attributes to Change Notice Log report and Change Request Log report

Marco_Tosin
‎Oct 13, 2015 04:57 AM
‎Oct 13, 2015 04:57 AM

Added link in the TIPS and TRICKS section:

 

How to create a query builder report that accepts multiple inputs (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS190138

 

How to hide the "Saved Reports" for particular user (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS190136

 

Query Builder Report displays duplicate entries (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS146646

 

Query builder report to fetch all the values of the multivalued attribute in single row (PTC TS)

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210938

Marco_Tosin
‎Oct 16, 2015 08:20 AM
‎Oct 16, 2015 08:20 AM

Added link as shown below.

 

TIPS and TRICKS

Multi-valued attributes display multiple times within a Query Builder report
https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS53268

 

Possibility to make reports in the query builder default to search in the current container

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS96881

 

Search on Windchill Report Builder are case sensitive though the Select criteria is "like"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS168769

Where is the documentation for how to add Business Reporting to an existing Windchill installation?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS115821

 

 

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's)

Global Attribute Enumeration

enumerations - PTC Community

 

How to export all ACL's related to a specific user

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS123564

 

Query builder report to fetch product, role and user from role

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS189509

 

Query builder report to fetch "last logged in" of users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS220318

 

Query Builder Report to list all objects shared between projects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209852

 

Query Builder report to show folders with associated domains

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS44018

 

 

CHANGE MANAGEMENT

How to get "Promoted on" attribute into a Change Notice report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS115668

 

Query Builder report for counting the Affected Objects in a Problem Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS213950

 

 

EPMDoc REPORT

Query Builder report to fetch checked out objects in user's workspace

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS134496

 

Query builder report to fetch the EPMDocuments having annotation

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210700

 

PROMOTION and WORKFLOW

In which database tables are stored the workflow execution objects?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS214035

 

QML report returning runtime routing list for Setup Participants from a workflow

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210243

 

Report to find out values of Promotion Preferences

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS215586

 

WTDOCUMENTS

Query builder report to list Documents from folder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS208539

 

Report to find WTDocuments went for Approval Routing in Windchill ProjectLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS207521

 

Report to search for Documents by Effectivity

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209206

 

What are the tables and joins required for generating a query builder report for Documents without any Primary Content and Attachments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209629

 

WTPARTS

How to create a Where Used report for WTParts

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210416

 

QML Report to to show association between Deviation and it's associated WTPart

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS205475

 

Query builder report to list WTParts from folder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS208537

 

Query Builder Report to list all the OEM part which do not have AML\AVL Part associated

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210102

 

Query builder report to fetch parts at level 0 in structure tab

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS215346

 

Which Database tables store classification attributes in Windchill PartsLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS172788

 

TROUBLESHOOTING

 

Change Requests not automatically associated with corresponding Problem Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS211530

 

Failed to delete some report templates from Site>Utilities>Report Management

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS185149

 

Generating a report from Context > Reports > Change Request Logs caused MethodServer to crash with OutOfMemoryError

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS203309

 

Reports imported or created at Organization level are not available for non-admin users on Homepage

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS52000

 

Report Builder is inadvertently removing a condition from the subquery while attempting to modify the qml with user entered data

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS186246

 

Using Date Picker in a OOTB Report in a browser that is not in English results a "Timestamp format" Error

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS215342

Marco_Tosin
‎Jan 29, 2016 03:49 AM
‎Jan 29, 2016 03:49 AM

Added link as shown below

 

TIPS and TRICKS

How to create bar chart report with number of records created in each month

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223720

 

Use of Options in the Select Tab of Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS35281

 

Information regarding how to use the Query Builder functions

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS83196

 

How can a report be run on a schedule and emailed to a user in Windchill PDMLink?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS140996

 

Query builder report to display "Comments" column of Object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS157262

 

How to allow users to see all part numbers even though they do not have access to all parts?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223072

 

How to add Info (Details Page) button and email links in query builder reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227239

 

Query Builder Criteria Logic for getting last month

Query Builder Criteria Logic for getting last mont... - PTC Community

 

 

 

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

 

How to generate a Query builder report to display Maturity History of the object

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS28221

 

How to get "Download" event information in Security Audit Reporting

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS135740

 

Query Builder report to fetch latest version of WTDocument,EPMDocument and WTPart in Library Context for particular state

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS142076

 

QML Report to list all the Users in Organization

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS198022

 

How to list Classification Nodes and their related attributes

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS220979

 

QML report to retrieve the Distinguished Name of all Users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS221494

 

Query builder report for listing prohibit publishing objects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS226376

 

Is there a way to Search Check in comments for CAD or Documents

Solved: Is there a way to Search Check in comments for CAD... - PTC Community

 

 

 

CHANGE MANAGEMENT

How to create a visual monitor report that shows open, in progress and complete Change Requests

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS224065

 

Query builder report to fetch problem report with associated part

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS226330

 

Change object Date Completed

Solved: Change object Date Completed - PTC Community

 

 

 

EPMDoc REPORT

How to get a list of all family table instances with a status of "Unverified" or "Unknown"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS40247

 

Query Builder Report to fetch the universally uploaded object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227691

 

How to build a report for latest version of EPMDocuments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS33305

 

 

 

WTDOCUMENTS

QML report to count the number of documents by different document types

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS216381

 

 

 

WTPARTS

QML report to query latest version of all WTParts

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS138336

 

How to get a query builder report for Classification details for Parts and/or Part Structure

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS145972

 

Query builder report to list WTParts of particular view

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS208737

Solved: Report to list WTParts of particular view - PTC Community

 

How to create a Query Builder report to list all Parts that do not have Parent Part

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223922

 

 

 

TROUBLESHOOTING

When a variable is used in Select and Criteria section of Query Builder with Input Parameter, report page generated doesn't display alias name of variable in Input Parameters section

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS133386

 

Not able to Save reports having Chart using Organization Admin user giving secured action error

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS179575

 

Failed to export the results generated for Reports using Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS204259

 

Information or Details page for Report Templates shows Creator attribute value as ???createdby??? where creator is not available

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS221397

 

Data monitor criteria filter for created on time of "Yesterday" not covering entire day

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS226634

 

In Report Builder, like operator does not returns exact searched string

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS224643

 

Report result will not be merged even select the "HTML (with merging)" in "Generate Legacy Mode Output"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS222197

 

Soft types created at the organization level not available in Query Builder launched from "Site" > "Utilities"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227163

cmckenna
‎Feb 03, 2016 11:04 AM
‎Feb 03, 2016 11:04 AM

Hi,

I'm looking to build a report that gives me the number of days spent at each state for each Change Notice. Can anyone recommend how to do this using functions within the Query Builder?

Thanks

Conor

Marco_Tosin
‎Feb 03, 2016 11:25 AM
‎Feb 03, 2016 11:25 AM

Conor,

I suggest you a couple of things.

First: you should create a dedicated discussion with your request, because you made it in an article.

Second: if you can't get an answer in few days, and have an active maintenance, you should also submit your request to PTC support.

Many of the reports linked in my document are taken from article written by TS.

cmckenna
‎Feb 03, 2016 11:31 AM
‎Feb 03, 2016 11:31 AM

Thanks Marco, will do that now

dwilliams
‎Feb 03, 2016 01:18 PM
‎Feb 03, 2016 01:18 PM

Hi ,

  I just posted a large amount of reports to the group. I do believe there are a few in regards to process and activity completion time. Please take a look at these reports and see if one can be modified to meet your need.


‌, Please feel free to add these to the document as needed.

Best Regards,

Dax

Marco_Tosin
‎Feb 04, 2016 02:28 AM
‎Feb 04, 2016 02:28 AM

Hi Dax,

thanks for sharing your reports.

I'll take a look into them and then I'll link your reports in my document.

cmckenna
‎Feb 04, 2016 11:44 AM
‎Feb 04, 2016 11:44 AM

Hi Dax, thanks for these. These will come in useful!

Marco_Tosin
‎Feb 09, 2016 11:18 AM
‎Feb 09, 2016 11:18 AM

Added link to reports taken from Dax Williams documents.

ADMINISTRATIVE REPORT

Action Item with Workflow Process

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111660/ACTION%20ITEM_Action%20Item%20with%20Workflow%20Process.qml.zip

Attribute Ids by Name

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111682/ADMINISTRATIVE_Attribute%20Ids%20by%20Name.qml.zip

Attribute Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111683/ADMINISTRATIVE_Attribute%20Info.qml.zip

Document Template Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111686/ADMINISTRATIVE_Document%20Template%20Info.qml.zip

User Login Audit

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111789/ADMINISTRATIVE_User%20Login%20Audit.qml.zip

User Login Totals

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111788/ADMINISTRATIVE_User%20Login%20Totals.qml.zip

User Specified Preferences

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111696/ADMINISTRATIVE_User%20Specified%20Preferences.qml.zip

Preferences

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111680/ADMINISTRATIVE_9.1%20Preferences.qml.zip

Quantity of Measure

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111692/ADMINISTRATIVE_Quantity%20of%20Measure.qml.zip

Report Manager Report List

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111693/ADMINISTRATIVE_Report%20Manager%20Report%20List.qml.zip

Team Template Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111694/ADMINISTRATIVE_Team%20Template%20Info.qml.zip

Part Version Scheme

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8682-1-111704/AUDIT_Part%20Version%20Scheme.qml.zip

Lifecycle Template Info

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111688/ADMINISTRATIVE_Lifecycle%20Template%20Info.qml.zip

Library_Product_Project Templates

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111687/ADMINISTRATIVE_Library_Product_Project%20Templates.qml.zip

Total EPMDocuments and File Size by Context

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111791/ADMINISTRATIVE_Total%20EPMDocuments%20and%20File%20Size%20by%20Context.qml.zip

WTDocuments with File Size

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111787/ADMINISTRATIVE_WTDocuments%20with%20File%20Size.qml.zip

rfried
‎Apr 19, 2016 12:28 PM
‎Apr 19, 2016 12:28 PM

Using DECODE Function in Query Builder

Re: Query builder decode function - PTC Community

Marco_Tosin
‎Apr 27, 2016 05:57 AM
‎Apr 27, 2016 05:57 AM

Added some other reports:

 

TIPS and TRICKS

 

Using Java interfaces in QueryBuilder reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS33057

 

How to use the Custom Input Page for a QueryBuilder Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS130739

 

How to retrieve the Date with no Hours:Minutes:Seconds in Query builder report using the function

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS139088

 

Using Java Methods in Query Builder

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS114482

 

 

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

 

How to display all WTParts with Successful ESI Distribution Target using a report

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS58679

 

Query builder report to fetch number of object in each Context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS149816

 

Query builder report to retrieve the Team, Roles and Users associated to Variances

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229148

 

QML report to generate Access Control Lists applied in a specific context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS146799

 

How to get the Name and Context from any object based on the file vault file name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229938

 

How to prepare Query Builder report to generate the Product/Project/Library team members

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS28414

 

QML Report to generate Access Control Lists applied in a specific context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS146799

 

Gather a report from WVS job monitor

Gather a report from WVS job monitor - PTC Community

 

Query builder report to list all active users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209700

 

How to generate a report listing the projects and tasks where a resource is used

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS98782

 

QML which gives list of activities (like checkin, checkout etc) performed through both std browser

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS151749

 

Query Builder Report listing additional information not contained in a security audit report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS234696

 

How to get the Name and Context from any object based on the file vault file name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229938

 

How to determine the number of WtPart in the Commonspace in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS235473

 

 

CHANGE MANAGEMENT

 

QML report to fetch all Change Notice and their associated Team template

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS228394

 

How to generate a report listing Change Request and the affected objects?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS52010

 

Query builder report to list Change notice with no affected objects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229390

 

Change Notice, Change Task, Votes, Assignee, Due Date, Completed Date, Last Modified Date

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS48714

 

What is the relationship between Change and Changeable Object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS106301

 

 

 

EPMDoc REPORT

 

PROMOTION and WORKFLOW

How to add Promoted By and Promoted On in advanced search criteria

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS55947

 

Anyone have a way to find nested family tables?

Anyone have a way to find nested family tables? - PTC Community

 

Query Builder Report which lists the user and workspace names for checked out versions of CAD Document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS232560

 

How to get the latest EPM DOCrevision using Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS184264

 

Family Table Report with Related WTParts

Family Table Report with Related WTParts - PTC Community

 

 

PROMOTION and WORKFLOW

 

Query Builder Lifecycle History Example

Query Builder Lifecycle History Example - PTC Community

 

Report showing date of last promotion

Report showing date of last promotion - PTC Community

 

 

WTDOCUMENTS

 

How to identify the template that was used to create documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS214070

 

Report all WTParts related to WTDocuments

Report all WTParts related to WTDocuments - PTC Community

 

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS36007

 

 

WTPARTS

 

How to select the latest revision of a Part in a Query Builder report

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS1171

 

How to get a report of the URL address of WTparts

Solved: How to get a report of the URL address of WTparts? - PTC Community

 

Query to capture WTParts set to Released in the last 4 hours

Query to capture WTParts set to Released in the la... - PTC Community

 

Query builder report to fetch WTParts in a specific Org that have Part Master Default unit set to "as needed"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS232193

 

Query builder report to find all WTParts and their corresponding PartsLink classification nodes

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS233215

 

Report to verify the details of changes in iterations of Part Instance using Described by Documents

http://support.ptc.com/images/cs/articles/2014/10/20163203_G4Hv.qml

 

Query Builder report to list the Variances reported against Parts

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS234246

 

SuMa - Report to list the Manufacturer associated with the specific Context Organization

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS234911

 

 

TROUBLESHOOTING

 

When searching for objects that have empty IBA with "not like" criteria, Query Builder and Search UI will give inconsistent results

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS159539

 

Not able to set up changeable filter criteria in Query Builder Approver Status field for attribute eventlist of type wt.workflow.definer.UserEventVector in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS235453

 

Getting an error message as "Report can only be launched when Windchill Business Reporting is installed" in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS124351

Marco_Tosin
‎Jul 12, 2016 04:05 AM
‎Jul 12, 2016 04:05 AM

Added some other reports:

 

TIPS and TRICKS

How to limit Access to Report Template

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS71222

 

How to specify the output format of a QML report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS131663

 

How to find the new name of an object when only the old name is known?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS239797

 

How to retrieve attribute and its value on an object using Report Management

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS115300

 

What tables are global attribute definitions and values stored

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS53787

 

How to generate IQY query for Report Manager reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS47169

 

Database tables references for Security Audit Reporting

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS31046

 

How to use Concatenate function in Criteria section of Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS241697

 

 

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

QML report showing 'No Content association between the Drawing and WTPart'

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227183

 

How to identify users listed in the Usage and License Reporting

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS107490

 

Family tables with instances not at same revision as generic

query builder report - family tables with instance... - PTC Community

 

 

Querybuilder report to display access available to users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS162218

 

 

CHANGE MANAGEMENT

QML report to retrieve ECNs and their related EPMDocuments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS239710

 

Change Requests and their connected Problem Reports

Solved: Report Manager - PTC Community

 

How to get a list of all the ECNs in the Application for a particuar Need Date

https://www.ptcusercommunity.com/thread/133770?sr=stream&ru=36103

 

 

EPMDoc REPORT

Report to list all drawings without primary content for CAD document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS237391

 

How to create a query builder Report that shows Revision History of Drawings which is a soft type of EPM Document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS236226

 

Report to fetch all EPM Documents having copied from representation

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223584

 

Report to generate all EPMDocument with all iteration of Lifecycle Template

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS143164

 

Find all EPM Documents without Visualisation

https://www.ptcusercommunity.com/thread/127349?sr=stream&ru=6342

 

 

WTDOCUMENTS

How to create a report listing Documents Context, Name, Number, State, Latest Revision & Iteration, and Age

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS239335

 

File Name of a document from Query Builder

https://www.ptcusercommunity.com/message/457256

https://www.ptcusercommunity.com/servlet/JiveServlet/download/457256-119614/_Document_Search.qml.zip

 

 

TROUBLESHOOTING

Data monitor against "Open Change Notices" report template status is "failed"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS236920

 

Report to list Suppliers (Manufacturer) with their associated Documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS240978

 

Query Builder does not list the Display Name of Sourcing Status attribute values in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS241420

Marco_Tosin
‎Dec 21, 2016 07:51 AM
‎Dec 21, 2016 07:51 AM

Added some Christmas gift reports

 

TIPS and TRICKS

 

In Query Builder Report how to group the results

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS162153

 

How to make Report Template available for use with Advanced Search in Windchill 11

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245106

 

How to make a Query Builder report to fetch all the related documents for a specific BOM

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245097

 

How to write a report that shows the association type between CAD Document and WTPart

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS17200

 

What are the steps to restrict visibility of Reports available on Saved Reports table for Users or Groups

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS244932

 

How to add a hyperlink to an object's Details page in Report Manager in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS82387

 

How to use QML reports upgraded from Windchill PDMLink 9.1 with Legacy Mode in Windchill PDMLink 11

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246736

 

How to get the Checked out date of a CAD Document in a Report in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246873

 

What is the relationship between WTUser, remoteobjectinfo and remoteobjectid tables in Windchill PDMLink database

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS94037

 

Restrict Access by Roles to Query Builder Reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249618

 

How to ensure Report Templates and Reports  are available for use in Advanced Search in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245106

 

 

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

 

Report showing the OID for products, library and project

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS237841

 

Query builder report to fetch Distinguished Name of the user and user name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS244704

 

Query Builder report to display WTParts having representations

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247241

 

Query builder report to fetch Choices and their associated WTPart in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247434

 

How to get a report of all Required attributes of a Classification Structure in Windchill PartsLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247059

 

How to build a report to list all customer specific preferences in Windchill

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249136

 

How to create a report listing the resource allocation over multiple Projects in Windchill ProjectLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249153

 

How to determine if an attribute type defined in Windchill is used anywhere in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS175010

 

How to generate query builder report which displays user with associated subscriptions

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS23188

 

 

CHANGE MANAGEMENT (ECR, ECN, PR, ...)

 

Query builder report (QML) to fetch problem report with part

https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS226330

 

Report listing all Change Requests without an associated Change Notice

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS144673

 

Is it possible to link Problem Report and Nonconformance in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249232

 

Report listing Change Request and the affected objects

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS52010

 

 

EPMDoc REPORT

 

How to get the Checked out date of a CAD Document in a Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246873

 

How to build a report of objects added to workspaces

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS202379

 

All EPMdocuments with secondary attachments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249915

 

Query Builder report [QML] to list all Workspaces

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS250740

 

 

PROMOTION and WORKFLOW

 

How to generate Query Builder report to display "Promoted on" attribute from the Maturity History table of an object

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS11566

 

How to retrieve records for delegation/reassignment

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS39534

 

Query builder report to fetch the Open Task assigned to User in a Product

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246581

 

 

WTDOCUMENTS

 

Report to generate BOM report with Described By and Referenced By Documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS238476

 

Report to get the document, its state and the role responsible to complete the task

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245051

 

Query builder report to fetch document which is not related to any other document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247264

 

How to build a report for latest revision of WTDocuments

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS251987

 

 

TROUBLESHOOTING

Unable to run cognos reports in Windchill 10.2

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210583

 

Reports using macro CURRENT_TIME that used to work before update don’t work anymore in Windchill PDMLink 10.2 M030

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS248659

 

Query Builder Report to get the list of parts which does not have any related document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS251347

 

Upgraded reports where attributes with an enumerated list that were previously defined in the Criteria tab no longer display the enumerated list in the drop-down in Report Builder in Windchill 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS252519

 

When user added java method then selected allow user to decide option all of column user is not able to generate report.

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS253057

ljeyachandran
‎Mar 22, 2017 02:35 AM
‎Mar 22, 2017 02:35 AM

Hi,

I have a requirement as follows

1. There are 2 document objects used in windchill (say Doc1 and Doc2). Doc2 can be created only when there is Doc1 (i.e. Doc2 can be created from details page of Doc1, The Doc1 number will be added as an attribute value in Doc2)

2. I wanted to create a report such that the output should show the value of Doc1 number and Doc2 number but with the condition that the Doc1 number should be in output even though Doc2 is not created.

Any suggestions would be helpful.

Regards,

Logeshwar.J 

Marco_Tosin
‎Mar 22, 2017 08:52 AM
‎Mar 22, 2017 08:52 AM

Please open a specific discussion with your request.

This way other people could reply if possible.

You have written your comment in a document that it's already very long.

Marco_Tosin
‎Aug 04, 2017 08:44 AM
‎Aug 04, 2017 08:44 AM

Added some reports (summer edition)

 

TIPS and TRICKS

How to get a date as today in query builder?

how to get a date as today in query builder? - PTC Community

 

 

How to generate a Query Builder report that lists the values of soft type attributes associated to an object

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS99727

 

Is it possible to enable Legacy Mode for Query Builder reports

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS112323

 

How can an Outer Join be used when creating a QML report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS125561

 

How to access a calculated attribute in Query Builder 

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS126453

 

Is it possible to add some text in particular HTML report page

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS195857

 

Query Builder reports containing the function LOWER are not working properly

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS238773

 

How to use QML reports upgraded from Windchill PDMLink 9.1 with Legacy Mode in Windchill PDMLink 11

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246736

 

How to import QML into report management in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS256736

 

How to add context criteria to query builder qml report on EPMDocuments for filtering results

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS259441

 

How to create custom macro to use in Query Builder Report

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS260538

 

How to set the output of a report directly to CSV, XML or xls in Windchill PDMLink 11.0?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS260941

 

How enable SQL button in QML in Windchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS264488

 

How to add a sub-type drop-down list of a parent type on report builder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS267881

 

 

ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)

 

Is it possible to create a Query Builder report for a ProjectLink Routing?

Solved: Is it possible to create a Query Builder report fo... - PTC Community

 

 

How to create report of user checkins?

Solved: How to create report of user checkins? - PTC Community

 

 

Can’t search for Documents created/modified by deleted users

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS17742

 

Query Builder Report for WTObject with the associated IBAs

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS20298

 

How to generate a report to which will accept the user name and will generate a list of Context with the role name in which he is a part of 

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS59086

 

How to list all user enable in a report 

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS106475

 

Report to list network details corresponding to a Context

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS167040

 

Query all workflows to determine for class/method used in them

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS168660

 

Report to fetch the Event Manager Conflicts records

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS213042

 

QML to get the WTPart and EPMDocuments association type along with the Promotion Request number 

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS261567

 

Report to list the attachment download from CAD Document by user

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS267220

Marco_Tosin
‎Aug 04, 2017 08:46 AM
‎Aug 04, 2017 08:46 AM

Summer edition second part

 

CHANGE MANAGEMENT (ECR, ECN, PR, ...)

 

How to extract the Affected Objects and Resulting Objects associated to a Change Task using Report Manager

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS112463

 

Report showing Reassignment History for Change Task

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS143170

 

How to fetch Change task sequence with Change task name

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS191007

 

Query Builder report to fetch the change task with no attachment

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS263438

 

QML to list change notice along with change task information

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS264939

 

Is there a way to get Implementation Plan task sequence number on a QueryBuilder report?

https://community.ptc.com/t5/Windchill/Is-there-a-way-to-get-Implementation-Plan-task-sequence-number/td-p/356591?ru=281467&sr=stream

 

EPMDoc REPORT

 

How to search for a CAD object that is in a particular workspace?

https://community.ptc.com/t5/Windchill/How-to-search-for-a-CAD-object-that-is-in-a-particular-workspace/td-p/363648

 

QML for Drawing >> related objects, Format

https://community.ptc.com/t5/Windchill/qml-for-Drawing-gt-gt-related-objects-Format/td-p/47220

 

QML report - Formats where referenced (drawings)

https://community.ptc.com/t5/Windchill/qml-report-Formats-where-referenced-drawings/td-p/317336

 

How are Representations stored in the database and how are EPMDocuments linked to them

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS17670

 

How to get the new object list that are uploaded but not checked-in from Workspace

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS20630

 

Query Builder Report to fetch CAD Documents for which viewable is not present

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS149329

 

Report that shows lists of all the Objects has Representation or Viewable with File Size

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS165565

 

Report of the latest version of all drawings at any State

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS255899

 

Query Builder report that mimics "References" table on "EPMDocument"

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS258372

 

Report listing all models having a drawing reference

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS267362

 

Find Missing CAD Representations within a Specified Date Range

https://community.ptc.com/t5/Windchill/Find-Missing-CAD-Representations-within-a-Specified-Date-Range/td-p/447526

 

File downloads from CAD Attachments

https://community.ptc.com/t5/Windchill/query-builder-report-file-downloads-from-CAD-Attachments/td-p/184248

 

PROMOTION and WORKFLOW

 

How to link SignatureLink and Workflow Process table and fetch data from them

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS258046

 

WTDOCUMENTS

 

How to make a report to fetch the IBA value for all documents

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247369

 

Report to fetch the Primary Content URL details of the Document

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS262052

 

WTPARTS

 

How to create Report that shows link between Parent Part and Part Child?

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS263165

 

Overview of WTPartUsageLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS266445

 

A query that will list all WTParts in the system along with the folder they are stored in

https://community.ptc.com/t5/Windchill/A-query-that-will-list-all-WTParts-in-the-system-along-with-the/td-p/66710?ru=321881&sr=stream

 

TROUBLESHOOTING

Query Builder cannot find and add custom attributes to a report

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS157493

 

When using the function "System Date" on Select tab of Query Builder, "System Date" is not the same as the server's true time

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS178058

 

Chart displays maximum of 25 values in Query Builder

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS200763

 

Query Builder reports containing the function LOWER are not working properly

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS000238773

 

In report template, the case insensitive option doesn't work on IBA gets invalid result

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS244230

 

When user added java method then selected allow user to decide option all of column user is not able to generate report.

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS253057

 

In Query Builder, the character "&" in the name of a Report Template generates a NullPointerException exception when using the report in another report in Windchill PDMLink 11.0

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS251516

 

QML Object "role.fullDisplay" is not valid on class "Role Principal Map". The property "fullDisplay" is not valid on "wt.project.Role" 

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS261768

 

Saved Reports executed from Data Monitor showing status as Executing

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS261779

 

Query builder report errors with An Aggregate may not appear in a where clause unless it is in a subquery contained in a Having clause or a select list, and the column being aggregated is an outer reference when ran in WIndchill PDMLink

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS264090

 

Report failed to launch with Exception PropertyDescriptor not found for 'versionIdentifier.versionSortId' attribute in the class: wt.part.WTPart

https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS266961

Vincent-Kulak
‎Oct 13, 2017 08:14 AM
‎Oct 13, 2017 08:14 AM

Hi Marco

 

This link

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

is incorrect

 

Must be ==> https://communities.ptc.com/ideas/4634

Marco_Tosin
‎Oct 13, 2017 08:20 AM
‎Oct 13, 2017 08:20 AM

Hi Vincent,

thanks for your comment, but at the moment I cannot modify the link because of the limitation of the new site.

 

I just tried and it says that it's not possible because text is more than 20,000 digit long.

 

 

Vincent-Kulak
‎Oct 13, 2017 08:23 AM
‎Oct 13, 2017 08:23 AM

Oh bad news for this good document

 

Thanks Marco

Marco_Tosin
‎Oct 13, 2017 08:31 AM
‎Oct 13, 2017 08:31 AM

Yes, I agree with you.

Don't know if Jamie Lee could do something to avoid this behavior.

 

Otherwise I have to split this document to more than one, but at the moment I haven't enough time to do it.

 

 

MikeGenovese
‎May 18, 2018 09:09 AM
‎May 18, 2018 09:09 AM

Trying to create a Report that will show all open Change Notices and the Tasks associated with them based on a certain list of Products and Users Assigned to those tasks.

 

Example

I want to input the following criteria into the report

     Products (Clock, Can-Opener, Computer-Drive)

and

     Users (Clark, Lois, Bruce)

and

      based on the Open State (of the Change Notice)

show me all CNs with their associated tasks based on the Product and User.

 

Marco_Tosin
‎Mar 05, 2019 11:57 AM
‎Mar 05, 2019 11:57 AM

This is the right link

 

https://community.ptc.com/t5/Windchill-Ideas/Possibility-to-load-SQL-statements-in-Query-Builder-Report-in/idi-p/460592

BillRyan
‎Aug 19, 2019 04:16 PM
‎Aug 19, 2019 04:16 PM

It seems most of the Links are broken.   Anybody know the redirects?

Marco_Tosin
‎Aug 30, 2019 08:18 AM
‎Aug 30, 2019 08:18 AM

Hi Bill, you can have more info on this issue looking at this discussion https://community.ptc.com/t5/Community-Feedback/Links-to-attachments-on-the-quot-Resource-on-Reporting-quot/m-p/539674

 

As you can read on it, I'm working to divide my original document in more documents, because of the limit of 20,000 characters.

 

I'm also verifying all the links, removing those that are broken and correcting the others that were changed when there was the two big migrations in the past.

 

Obviously this in not my main job, so it will take a while to verify hundreds of links and write the new documents.

rleir
‎Apr 26, 2021 07:48 AM
‎Apr 26, 2021 07:48 AM

Hi all,

The links to ptcuser seem to be broken. For example:

 

List of users (Mike Lockwood from PTC/User)

http://portal.ptcuser.org/p/fo/do/download=1&fid=18287

 

And the topics are hard to search for on ptcuser. Please help!

thanks -- Rick

rleir
‎Apr 26, 2021 07:53 AM
‎Apr 26, 2021 07:53 AM

Page cannot be found

Sorry, the page you are looking for cannot be found and might have been removed, had its name changed, or is temporarily unavailable. It is recommended that you start again from the homepage. Feel free to contact us if the problem persists or if you cannot find what you’re looking for.
Marco_Tosin
‎Apr 26, 2021 07:56 AM
‎Apr 26, 2021 07:56 AM
I believe that all links to ptcuser.org were broken when they move to the new site
rleir
‎Apr 26, 2021 08:05 AM
‎Apr 26, 2021 08:05 AM

Marco

In 2015!  Does the content exist at a different link, or was it all lost?

thanks -- Rick

Marco_Tosin
‎Apr 26, 2021 08:12 AM
‎Apr 26, 2021 08:12 AM
Hi Rick,

this information is not in my availability, you have to ask the ptcuser.org site administrator.

Please open a thread in the PTC community with what you need, so it's easier to give you an answer.
rleir
‎Apr 29, 2021 11:31 AM
‎Apr 29, 2021 11:31 AM

Done.

thanks Marco!

cheers -- Rick

SK_9492778
‎May 28, 2021 05:49 AM
‎May 28, 2021 05:49 AM

I have imported Single level BOM report https://www.ptc.com/it/support/article/CS000072503 which shows occurences and their reference designators as own results. Instead of this I would only like to have BOM lines (without occurences) and have Reference designator range (Same as available in product structure browser, e.g. "C1-C5,C8")  as column but I can't find the reference designator range as attribute from the reportable item: wt.part.WTPartUsageLink. Does anyone know how to show the reference designator range in single level BOM report?

Marco_Tosin
‎May 28, 2021 05:58 AM
‎May 28, 2021 05:58 AM

Take a look at this article: Where are reference designators stored in Windchill PDMLink?

 

https://www.ptc.com/it/support/article/CS293967

SK_9492778
‎Jun 02, 2021 06:12 AM
‎Jun 02, 2021 06:12 AM

I am able to get Reference designator from Part Uses occurence (like mentioned in the linked article) but in this case each reference designator is shown as separate row. I want to have results where all reference designators with the same child part number/line number are listed in same row

 

Current result when I use Part uses occurence and Uses Name:

image

I would like to see this in same row in format (same as reference designator range is shown in product structure browser)

190000068    500    R4,R47

CM_10720949
‎Oct 31, 2024 07:38 AM
‎Oct 31, 2024 07:38 AM

Hello guys, 

I'm wondering if I can achieve this with query builder.

 

Basically I'm building a report on wtparts,  counting the "where used" 

 

I'm using outer join to count also the ones with 0 "where used"

 

My issue comes when I try to filter to get only the latest version/iteration of the design view.

Specifically what brakes the query buider is the classic subquery where we search for the max version sortid in order to filter it. 

 

This triggers a 0RA-01799: a column may not be outer-joined to a subquery.

 

Any idea?

I can achieve this by querying directly the DB, but I'd really lke to know if any of you has a workaround using the query builder.

 

 

 

 

avillanueva
‎Oct 31, 2024 08:38 AM
‎Oct 31, 2024 08:38 AM

I instead of replying a very old thread, I suggest creating a new topic in the Windchill discussions area. This makes it easy for folks to answer your specific question.

CM_10720949
‎Nov 04, 2024 08:23 AM
‎Nov 04, 2024 08:23 AM

well, I've posted here because this is the main resource related to query builder and reporting, and I don't particularly like to scatter infos across multiple places, but I will create a new topic if noone responds in a few days.

 

thx

Version history
Last update:
‎Sep 19, 2014 05:38 AM
Updated by:
21-Topaz I
Labels (1)
Attachments