Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Community
- PLM
- Windchill Tips
- Resource for reporting
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
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
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)
Extract policy rules (Mike Lockwood)
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)
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)
Reporting - Groups and Users (Shreyas Atre from PTC/User)
RE: Reporting - Groups and Users
Types and mapped attributes (Mike Lockwood)
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
Attribute Ids by Name
Attribute Info
Document Template Info
User Login Audit
User Login Totals
User Specified Preferences
Preferences
Quantity of Measure
Report Manager Report List
Team Template Info
Part Version Scheme
Lifecycle Template Info
Library_Product_Project Templates
Total EPMDocuments and File Size by Context
WTDocuments with File Size
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)
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 Activity Report detailing Name, Description, Current Assignee, Total Days Open (for parent CN), Days for Current Task, Need Date (Don Senchuk)
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
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)
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-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)
Link between EPMDocuments and WTParts (Tristan Owen)
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]
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)
WTPart Object ID based on the EPM Document Object ID, Version and Iteration (Tristan Owen)
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)
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)
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)
Info about the vaulted file on disk (Mike Lockwood)
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
Comments
Aug 12, 2015
12:22 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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?
Aug 13, 2015
10:09 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Aug 13, 2015
10:09 AM
It is working now. 
Thanks!
Aug 25, 2015
05:40 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Sep 02, 2015
11:17 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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)
Sep 25, 2015
04:59 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Sep 25, 2015
04:59 PM
Added Below Link
How to link WTDocument and its primary content (Binesh Kumar)
Sep 29, 2015
11:31 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Sep 29, 2015
11:31 AM
Oct 02, 2015
01:41 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Oct 02, 2015
01:41 PM
Added Link:
Where Used (Latest Version of Objects) (Marc DeBower)
Oct 04, 2015
10:36 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Oct 13, 2015
04:57 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Oct 16, 2015
08:20 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
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
Jan 29, 2016
03:49 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Feb 03, 2016
11:04 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Feb 03, 2016
11:25 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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.
Feb 03, 2016
11:31 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Feb 03, 2016
11:31 AM
Thanks Marco, will do that now
Feb 03, 2016
01:18 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Feb 03, 2016
01:18 PM
Feb 04, 2016
02:28 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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.
Feb 04, 2016
11:44 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Feb 04, 2016
11:44 AM
Hi Dax, thanks for these. These will come in useful!
Feb 09, 2016
11:18 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Feb 09, 2016
11:18 AM
Added link to reports taken from Dax Williams documents.
ADMINISTRATIVE REPORT
Action Item with Workflow Process
Attribute Ids by Name
Attribute Info
Document Template Info
User Login Audit
User Login Totals
User Specified Preferences
Preferences
Quantity of Measure
Report Manager Report List
Team Template Info
Part Version Scheme
Lifecycle Template Info
Library_Product_Project Templates
Total EPMDocuments and File Size by Context
WTDocuments with File Size
Apr 19, 2016
12:28 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Apr 19, 2016
12:28 PM
Using DECODE Function in Query Builder
Apr 27, 2016
05:57 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Jul 12, 2016
04:05 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Dec 21, 2016
07:51 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Mar 22, 2017
02:35 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Mar 22, 2017
08:52 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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.
Aug 04, 2017
08:44 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Aug 04, 2017
08:46 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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?
EPMDoc REPORT
How to search for a CAD object that is in a particular workspace?
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
File downloads from CAD Attachments
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
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
Oct 13, 2017
08:14 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Oct 13, 2017
08:20 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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.
Oct 13, 2017
08:23 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Oct 13, 2017
08:23 AM
Oh bad news for this good document
Thanks Marco
Oct 13, 2017
08:31 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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.
May 18, 2018
09:09 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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.
Mar 05, 2019
11:57 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Mar 05, 2019
11:57 AM
Aug 19, 2019
04:16 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Aug 19, 2019
04:16 PM
It seems most of the Links are broken. Anybody know the redirects?
Aug 30, 2019
08:18 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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.
Apr 26, 2021
07:48 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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
Apr 26, 2021
07:53 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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.
Apr 26, 2021
07:56 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Apr 26, 2021
07:56 AM
I believe that all links to ptcuser.org were broken when they move to the new site
Apr 26, 2021
08:05 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Apr 26, 2021
08:05 AM
Marco
In 2015! Does the content exist at a different link, or was it all lost?
thanks -- Rick
Apr 26, 2021
08:12 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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.
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.
Apr 29, 2021
11:31 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
Apr 29, 2021
11:31 AM
Done.
thanks Marco!
cheers -- Rick
May 28, 2021
05:49 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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?
May 28, 2021
05:58 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
May 28, 2021
05:58 AM
Take a look at this article: Where are reference designators stored in Windchill PDMLink?
Jun 02, 2021
06:12 AM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Notify Moderator
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:
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
- « Previous
-
- 1
- 2
- Next »
