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

We are happy to announce the new Windchill Customization board! Learn more.

Windchill Tips

Sort by:
I don't know if this is the right way, but since this group is growing, maybe we could work on this document to insert useful resource for reporting.   I leave the document open, so everyone can add other useful things.   Maybe you can vote up also these three ideas:   Possibility to load SQL statements in Query Builder Report in Windchill PDMLink   Report: PTC have to share what TS do about it with their customer   Set the query limit only for Reports in Windchill PDMLink       As you can read on this discussion, Albert Anderson gave us a link about Windchill UML Model Documentation - English   Another useful document about query builder from Albert Anderson Query Builder for Live Project Status Reports (NPI, Large Engineering Change, etc.)   Another article about UML from TS https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS188216&lang=en&source=community   I think it could be helpful also to catalogue report for argument, when it comes from other discussion, having a single source. In bold macro argument, below title of report (in parenthesis owner of the report) and then link to download report or to TS article.     At the end of this document you can download a presentation (from Rebecca French of PTC Global Services) It's very very old (Windchill 6.2), but it could be still useful for people who wants to take the first steps in the world of reporting.   Another document attached at the end, from Dax Williams (at PTC/User), is about creating a Windchill report interface in Excel.   TIPS and TRICKS   Documentation about relations in Query Builder in Windchill PDMLink https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS53948   Understanding database table relationships in Windchill to generate queries or build Windchill Reports https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS51689   How to expose Query Builder report at context level in Windchill PDMLink https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS42087   Automatic report creation (Mike Lockwood from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=16373 PTC Community Document: Automatic report creation   Below returns latest Iteration of each Revision (Mike Lockwood from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=11386 PTC Community Document: query builder Latest Revision   Explanation of tables that store build information between CAD Documents and Parts and the different "BuildType" values in Windchill PDMLink 10.1 (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS125790&lang=en&source=community   How to create a query builder report that accepts multiple inputs (PTC TS) https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS190138   How to enter multiple values when generating a Query builder report in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS162759&lang=en&source=community   How to get query builder report into Cognos, create report and push it back to Windchill PDMLink 10.1 (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS148905&lang=en&source=community   How to have Info*Engine query results be returned in a CSV file (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS187236&lang=en&source=community   How to hide the "Saved Reports" for particular user (PTC TS) https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS190136   How to load .QML reports into Windchill PDMLink 10.0 (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS113617&lang=en&source=community   How to load a Query Builder report exported as QML from the command line (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS187335&lang=en&source=community   How to make reports available to users in Windchill PDMLink 10 (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS182027&lang=en&source=community   How to run Query Builder report from Microsoft Excel in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS162869&lang=en&source=community   How to use the Custom Input Page for a QueryBuilder Report in Windchill PDMLink 10.1 (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS130739&lang=en&source=community   How to understand Change Management objects and their relations in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS63595&lang=en&source=community   How to use different date ranges as criteria in a Query Builder report in report manager (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS153996&lang=en&source=community   Improve Process Efficiency with Windchill Business Reporting (Vishal Arora from PTC/User) http://portal.ptcuser.org/p/do/sd/sid=727&fid=748&req=direct PTC Community Document: Improve Process Effiiciency with Windchill Business Reporting   List of "types" that one can select for building query builder reports (Mike Lockwood from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=10071 PTC Community Document: Types available in query builder   Multi-valued attributes display multiple times within a Query Builder report https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS53268   Overview of link objects in Windchill (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS131357&lang=en&source=community   Possibility to make reports in the query builder default to search in the current container https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS96881   Query Builder Report displays duplicate entries (PTC TS) https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS146646   Query Builder Report returns duplicate results when "Distinct" option is selected in the "SELECT Tree" (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS201994&lang=en&source=community   Query Builder Report shows duplicated row for the same Part in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS202500&lang=en&source=community   Query Builder Report Weirdness (From PTC/User) http://portal.ptcuser.org/p/fo/st/topic=16&post=121477#p121477 PTC Community Document: Query Builder Report Weirdness   Query builder report to fetch all the values of the multivalued attribute in single row (PTC TS) https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210938   Search on Windchill Report Builder are case sensitive though the Select criteria is "like" https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS168769   Where is the documentation for how to add Business Reporting to an existing Windchill installation? https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS115821   Windchill Business Reporting (Avinash Kor from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=9354 PTC Community Document: Windchill Business Reporting (Edited)   Windchill Database Relationships - CAD Document Parameters (Tom Uminn) Windchill Database Relationships - CAD Document Parameters   How to create bar chart report with number of records created in each month https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223720   Use of Options in the Select Tab of Report Manager https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS35281   Information regarding how to use the Query Builder functions https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS83196   How can a report be run on a schedule and emailed to a user in Windchill PDMLink? https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS140996   Query builder report to display "Comments" column of Object https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS157262   How to allow users to see all part numbers even though they do not have access to all parts? https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223072   How to add Info (Details Page) button and email links in query builder reports https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227239   Query Builder Criteria Logic for getting last month https://www.ptcusercommunity.com/thread/130187?sr=stream&ru=357802   Query builder decode function Query builder decode function   Using Java interfaces in QueryBuilder reports https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS33057   How to retrieve the Date with no Hours:Minutes:Seconds in Query builder report using the function https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS139088   Using Java Methods in Query Builder https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS114482   How to limit Access to Report Template https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS71222   How to specify the output format of a QML report https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS131663   How to find the new name of an object when only the old name is known? https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS239797   How to retrieve attribute and its value on an object using Report Management https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS115300   What tables are global attribute definitions and values stored https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS53787   How to generate IQY query for Report Manager reports https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS47169   Database tables references for Security Audit Reporting https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS31046   How to use Concatenate function in Criteria section of Report https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS241697   In Query Builder Report how to group the results https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS162153   How to make Report Template available for use with Advanced Search in Windchill 11 https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245106   How to make a Query Builder report to fetch all the related documents for a specific BOM https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245097   How to write a report that shows the association type between CAD Document and WTPart https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS17200   What are the steps to restrict visibility of Reports available on Saved Reports table for Users or Groups https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS244932   How to add a hyperlink to an object's Details page in Report Manager in Windchill PDMLink https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS82387   How to use QML reports upgraded from Windchill PDMLink 9.1 with Legacy Mode in Windchill PDMLink 11 https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246736   How to get the Checked out date of a CAD Document in a Report in Windchill https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246873   What is the relationship between WTUser, remoteobjectinfo and remoteobjectid tables in Windchill PDMLink database https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS94037   Restrict Access by Roles to Query Builder Reports https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249618   How to ensure Report Templates and Reports  are available for use in Advanced Search in Windchill PDMLink 11.0 https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245106     ADMINISTRATIVE REPORT (User/Roles/Group/ACL's/Generic Report for different object)   Access Policy Rules by Context (Dax Williams from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=2675   Display the roles of a user (Mike Lockwood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-35310-165974-28509/ContextTeams-Products.qml.zip https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-35310-165974-28510/User+Accounts.qml.zip   Extract policy rules (Mike Lockwood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-55886-251502-70950/ACLs+-+alternate+approach.qml.zip https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-55886-251502-70951/ACLs.xml   Explanation of tables that store build information between CAD Documents and Parts and the different "BuildType" values (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS125790&lang=en&source=community   Find rename objects (Lori Lee Sood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-50412-221716-56907/FindRenamedObjects.qml.zip   Global Attribute Enumeration https://www.ptcusercommunity.com/thread/119387?sr=stream&ru=281467   How to create a report that counts WTParts in a specific context with Query Builder in Windchill 10 (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS111896&lang=en&source=community   How to create query builder report of the empty folders in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS186510&lang=en&source=community   How to export all ACL's related to a specific user https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS123564   Last Login by user (Mike Lockwood) User Account - Last Login Report QML   List of users (Mike Lockwood from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=18287   OIR's (Mike Lockwood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-55759-250741-70657/OIRs.qml.zip   Policy rules (Darren Storey) http://portal.ptcuser.org/p/fo/do/download=1&fid=23549 https://www.ptc.com/appserver/cs/view/solution.jsp?n=CS116472&posno=9&q=export%20ACL&nav=ptcproductgroupshttps://www.ptcusercommunity.com/servlet/JiveServlet/download/6144-2-69351/ACL+compare2.qml.zip https://www.ptcusercommunity.com/servlet/JiveServlet/download/6144-2-69351/ACL+compare2.qml.zip   Policy rules (same format as displayed by Policy Administration applet) http://communities.ptc.com/docs/DOC-6567   Query Builder Report listing all the Teams of which a specified Group is a Member in Windchill PDMLink and Windchill ProjectLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS201550&lang=en&source=community   Query Builder Report to fetch the reassigned task's Status Description for Project Activity (PTC TS) https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS204338   Query builder report to fetch product, role and user from role https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS189509   Query builder report to fetch "last logged in" of users https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS220318   Query Builder Report to list all objects shared between projects https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209852   Query Builder report to show folders with associated domains https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS44018   Report with a list of Products having a specific role (Mike Lockwood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-56841-256758-72950/Context+Teams.qml.zip   Reporting - Groups and Users (Shreyas Atre from PTC/User) RE: Reporting - Groups and Users   Types and mapped attributes (Mike Lockwood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-55554-249262-69944/Types+and+mapped+attributes.qml.zi…   User login date (Dax Williams from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=15121 http://portal.ptcuser.org/p/fo/do/download=1&fid=15122   Product Team Listing (Steven Rector from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=27557   How to generate a Query builder report to display Maturity History of the object https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS28221   How to get "Download" event information in Security Audit Reporting https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS135740   Query Builder report to fetch latest version of WTDocument,EPMDocument and WTPart in Library Context for particular state https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS142076   QML Report to list all the Users in Organization https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS198022   How to list Classification Nodes and their related attributes https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS220979   QML report to retrieve the Distinguished Name of all Users https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS221494   Query builder report for listing prohibit publishing objects https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS226376   Is there a way to Search Check in comments for CAD or Documents https://www.ptcusercommunity.com/thread/130236?sr=stream&ru=364762   QML report to fetch all the objects that were renamed/renumbered in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS180898&lang=en&source=community             Link to report from Dax Williams taken from other documents in the community Action Item with Workflow Process https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111660/ACTION%20ITEM_Action%20Item%20with%20Workflow%20Process.qml.zip   Attribute Ids by Name https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111682/ADMINISTRATIVE_Attribute%20Ids%20by%20Name.qml.zip   Attribute Info https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111683/ADMINISTRATIVE_Attribute%20Info.qml.zip   Document Template Info https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111686/ADMINISTRATIVE_Document%20Template%20Info.qml.zip   User Login Audit https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111789/ADMINISTRATIVE_User%20Login%20Audit.qml.zip   User Login Totals https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111788/ADMINISTRATIVE_User%20Login%20Totals.qml.zip   User Specified Preferences https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111696/ADMINISTRATIVE_User%20Specified%20Preferences.qml.zip   Preferences https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111680/ADMINISTRATIVE_9.1%20Preferences.qml.zip   Quantity of Measure https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111692/ADMINISTRATIVE_Quantity%20of%20Measure.qml.zip   Report Manager Report List https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111693/ADMINISTRATIVE_Report%20Manager%20Report%20List.qml.zip   Team Template Info https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111694/ADMINISTRATIVE_Team%20Template%20Info.qml.zip   Part Version Scheme https://www.ptcusercommunity.com/servlet/JiveServlet/download/8682-1-111704/AUDIT_Part%20Version%20Scheme.qml.zip   Lifecycle Template Info https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111688/ADMINISTRATIVE_Lifecycle%20Template%20Info.qml.zip   Library_Product_Project Templates https://www.ptcusercommunity.com/servlet/JiveServlet/download/8681-1-111687/ADMINISTRATIVE_Library_Product_Project%20Templates.qml.zip   Total EPMDocuments and File Size by Context https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111791/ADMINISTRATIVE_Total%20EPMDocuments%20and%20File%20Size%20by%20Context.qml.zip   WTDocuments with File Size https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-1-111787/ADMINISTRATIVE_WTDocuments%20with%20File%20Size.qml.zip   How to display all WTParts with Successful ESI Distribution Target using a report https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS58679   Query builder report to fetch number of object in each Context https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS149816   Query builder report to retrieve the Team, Roles and Users associated to Variances https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229148   QML report to generate Access Control Lists applied in a specific context https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS146799   How to get the Name and Context from any object based on the file vault file name https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229938   How to prepare Query Builder report to generate the Product/Project/Library team members https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS28414   QML Report to generate Access Control Lists applied in a specific context https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS146799   Gather a report from WVS job monitor https://www.ptcusercommunity.com/ideas/6338   Query builder report to list all active users https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209700   How to generate a report listing the projects and tasks where a resource is used https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS98782   QML which gives list of activities (like checkin, checkout etc) performed through both std browser https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS151749   Query Builder Report listing additional information not contained in a security audit report https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS234696   How to get the Name and Context from any object based on the file vault file name https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229938   How to determine the number of WtPart in the Commonspace in Windchill https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS235473   QML report showing 'No Content association between the Drawing and WTPart' https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227183   How to identify users listed in the Usage and License Reporting https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS107490   Family tables with instances not at same revision as generic https://www.ptcusercommunity.com/thread/136958?sr=stream&ru=288561   Querybuilder report to display access available to users https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS162218   Report showing the OID for products, library and project https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS237841   Query builder report to fetch Distinguished Name of the user and user name https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS244704   Query Builder report to display WTParts having representations https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247241   Query builder report to fetch Choices and their associated WTPart in Windchill PDMLink https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247434   How to get a report of all Required attributes of a Classification Structure in Windchill PartsLink 11.0 https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247059   How to build a report to list all customer specific preferences in Windchill https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249136   How to create a report listing the resource allocation over multiple Projects in Windchill ProjectLink https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249153   How to determine if an attribute type defined in Windchill is used anywhere in Windchill PDMLink https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS175010   How to generate query builder report which displays user with associated subscriptions https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS23188     CHANGE MANAGEMENT (ECR, ECN, PR, ...) Change request that has no associated change notice (Lori Lee Sood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-50352-221824-56945/CRwithoutCN.qml.zip   Change Request Workflow Tasks (Lewis Lawrence from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=6456   Change Record Status - Open (Steven Rector from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=27558   Change Notice Report detailing Name, Description, Current Assignee, Total Days Open, Days for Current Task and Due Date (Don Senchuk) Change Notice Report.qml   Change Activity Report detailing Name, Description, Current Assignee, Total Days Open (for parent CN), Days for Current Task, Need Date (Don Senchuk) Change Task Report.qml   ECN and the count of WTParts for that ECN (Dax Williams from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=751   How to generate QML report for the ECN created in a 30 days using Query Builder (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS198747&lang=en&source=community   How to generate a report listing Change Notice task Comments in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS167392&lang=en&source=community   How to get "Promoted on" attribute into a Change Notice report https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS115668     https://www.ptcusercommunity.com/servlet/JiveServlet/download/423256-105730/ProblemReportComments.qml.zip   QML attached - outstanding change work items with related change objects (Darren Storey from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=24907 http://portal.ptcuser.org/x/fo/st/imagelb?fid=24908&topic=16   Query Builder report to get Affected End Item Parts added to Change Requests Affected End Item table (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS149307&lang=en&source=community   Query builder report of all the assignees of Change Notice/Change Activity in Windchill (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS179409&lang=en&source=community   Query Builder report for counting the Affected Objects in a Problem Report https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS213950   QML (total of 6) for getting affected and resulting object of CN (Shreyas Atre from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=21282   Report to return the objects in a Change Request (Shreyas Atre from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=20585   Released Part Version (Revisions) Linked to Changes (Lewis Lawrence from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=6504   How to add custom attributes to Change Notice Log report and Change Request Log report (PTC TS) https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS219369 Strictly speaking not a Query builder report, but rather a customization of the OOTB info*engine based report. Nevertheless I thought it was useful to add it here.   How to create a visual monitor report that shows open, in progress and complete Change Requests https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS224065   Query builder report to fetch problem report with associated part https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS226330   Change object Date Completed https://www.ptcusercommunity.com/thread/129761?sr=stream&ru=5134   QML report to fetch all Change Notice and their associated Team template https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS228394   How to generate a report listing Change Request and the affected objects? https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS52010   Query builder report to list Change notice with no affected objects https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS229390   Change Notice, Change Task, Votes, Assignee, Due Date, Completed Date, Last Modified Date https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS48714   What is the relationship between Change and Changeable Object https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS106301   QML report to retrieve ECNs and their related EPMDocuments https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS239710   Change Requests and their connected Problem Reports https://www.ptcusercommunity.com/thread/43627?sr=stream&ru=35352   How to get a list of all the ECNs in the Application for a particuar Need Date https://www.ptcusercommunity.com/thread/133770?sr=stream&ru=36103   Query builder report (QML) to fetch problem report with part https://support.ptc.com/appserver/cs/view/solution.jsp?source=subscription&n=CS226330   Report listing all Change Requests without an associated Change Notice https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS144673   Is it possible to link Problem Report and Nonconformance in Windchill PDMLink https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249232   Report listing Change Request and the affected objects https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS52010     EPMDoc REPORT All Checked Out CAD Docs with Workspace and User (Mike Lockwood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-56287-253837-71801/Checked+Out+CAD+Docs+with+Workspac…   Checked out CAD Documents (Christophe Laudou from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=3474   EPM Document and the Life Cycle Template the EPM Document is using (Shreyas Atre) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-52705-233403-62298/LCTEmplate.qml.zip https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-52705-233403-62297/LC+Join.png   EPMDoc that have been modified in a given period (Darren Storey from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=19547   EPMDocument Markup and Annotation Report by CAD Object and/or User (Dax Williams) https://www.ptcusercommunity.com/docs/DOC-7581   Getting the related Promotion Requests of a Drawing (Mike Lockwood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-56288-253820-71793/CAD+Doc+-+related+Promotion+Reques…   Link between EPMDocuments and WTParts (Tristan Owen) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-52705-250976-70777/EPMandWTPart.qml.zip   Link between EPM and Life Cycle template (Shreyas Atre from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=23403 http://portal.ptcuser.org/x/fo/st/imagelb?fid=23404&topic=16   How to create a Query Builder (QML) report which will list the instances associated with Generics of Family Tables (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS29111&lang=en&source=community   Numbers of  CAD documents (*.asm, *.prt) and their drawings (*.drw) [Tristan Owen] https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-39509-197193-47739/EPM_DrawingReference.qml.zip   Query to get downstream MPMLink parts from Design view WTParts (Mike Lockwood from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=14664   QML report showing ‘EPMDocument associated with the WTPart’ in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS23768&lang=en&source=community   Query Builder report that lists the size of CAD Documents and their location in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS42155&lang=en&source=community   Query Builder: Soft Type attributes for EPMDoc (NacNac Mott from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=18529 http://portal.ptcuser.org/p/fo/do/download=1&fid=18530   Query Builder report to fetch checked out objects in user's workspace https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS134496   Query builder report to fetch the EPMDocuments having annotation https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210700   QML report showing ‘EPMDocument associated with the WTPart’ for Content association (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS23768&lang=en&source=community   QML to find workspaces and CAD Doc's in them (Mike Lockwood) QML to find workspaces and CAD Doc's in them   Report from WTPart to EPMDocument including the family table values (Mike Lockwood from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=14665   Where Used (Latest Version of Objects) (Marc DeBower) Where Used (Latest Version of Objects)   Workspace creation, last modified, etc. (Mike Lockwood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-56658-256774-72916/Workspace+attributes.qml.zip   WTPart Object ID based on the EPM Document Object ID, Version and Iteration (Tristan Owen) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-52705-251287-70853/EPMandWTPart_IDandVersionLink.qml.…   WTParts with Associated Described By Documents (Mike Lockwood from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=14654   Query Builder report to list all the Publish EPMDocument in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS191374&lang=en&source=community   How to get a list of all family table instances with a status of "Unverified" or "Unknown" https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS40247   Query Builder Report to fetch the universally uploaded object https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227691   How to build a report for latest version of EPMDocuments https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS33305   How to add Promoted By and Promoted On in advanced search criteria https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS55947   Anyone have a way to find nested family tables? https://www.ptcusercommunity.com/thread/134675?sr=inbox&ru=369970   Query Builder Report which lists the user and workspace names for checked out versions of CAD Document https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS232560   How to get the latest EPM DOCrevision using Report Manager https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS184264   Family Table Report with Related WTParts https://www.ptcusercommunity.com/docs/DOC-8798?sr=stream&ru=3370   Report to list all drawings without primary content for CAD document https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS237391   How to create a query builder Report that shows Revision History of Drawings which is a soft type of EPM Document https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS236226   Report to fetch all EPM Documents having copied from representation https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223584   Report to generate all EPMDocument with all iteration of Lifecycle Template https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS143164   Find all EPM Documents without Visualisation https://www.ptcusercommunity.com/thread/127349?sr=stream&ru=6342   How to get the Checked out date of a CAD Document in a Report https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246873   How to build a report of objects added to workspaces https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS202379   All EPMdocuments with secondary attachments https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS249915   Query Builder report [QML] to list all Workspaces https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS250740     PROMOTION and WORKFLOW All the outstanding workflow work items for the current user (Darren Storey from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=24898   All the workflow tasks assigned to a user in Windchill PDMLink (Binesh Kumar) https://www.ptcusercommunity.com/servlet/JiveServlet/download/419101-104206/%20Assigned%20Tasks%20By%20User%20Name.qml.z…   All info of interest for all Workflow Activities from a give workflow template (Mike Lockwood from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=15994   Date of PR changing states (Lori Lee Sood) https://www.ptcusercommunity.com/servlet/JiveServlet/download/2034-49787-219926-56116/PR_States.qml.zip   How to generate QML report for the Tasks past deadline using Query Builder in Windchill PDMLink 10.2 (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS180709&lang=en&source=community   How to generate a report with events from workflow tasks in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS32218&lang=en&source=community   How to get an assigne name (in a role) from a workflow (Community) https://www.ptcusercommunity.com/message/426199?et=watches.email.thread#426199   In which database tables are stored the workflow execution objects? https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS214035   QML report returning runtime routing list for Setup Participants from a workflow https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210243   Query Builder report to fetch reassign information of a promotion request (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS162802&lang=en&source=community   Report to find out values of Promotion Preferences https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS215586   Report to list workflow tasks assigned to disconnected users in Windchill (PTC TS) https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS178728   Windchill Data Model for Workflow related objects in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS153902&lang=en&source=community   Query Builder Lifecycle History Example https://www.ptcusercommunity.com/docs/DOC-8716   Report showing date of last promotion https://www.ptcusercommunity.com/thread/135310?sr=stream&ru=263245   How to generate Query Builder report to display "Promoted on" attribute from the Maturity History table of an object https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS11566   How to retrieve records for delegation/reassignment https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS39534   Query builder report to fetch the Open Task assigned to User in a Product https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS246581     WTDOCUMENTS How to link betweeen a WTDocument and a Package (Lori Lee Sood) https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS131346&lang=en&source=community_US   How to create a "Query Builder" report listing all "Packages" with all "Document" in "Package Content" https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS219079   How to link WTDocument and its primary content (Binesh Kumar) Re: Report on WTDocument File   Info about the vaulted file on disk (Mike Lockwood) https://www.ptcusercommunity.com/servlet/JiveServlet/downloadBody/3088-102-1-3664/VaultedWTDocFiles.qml.zip   QML to generate URL for document (Shreyas Atre from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=23333   Query Builder report to display WTDocuments having representations (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS166540&lang=en&source=community   Query builder report to fetch all WTDocuments with no primary content (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS167918&lang=en&source=community   Query builder report to list Documents from folder https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS208539   Report to find WTDocuments went for Approval Routing in Windchill ProjectLink https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS207521   Report to search for Documents by Effectivity https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209206   What are the tables and joins required for generating a query builder report for Documents without any Primary Content and Attachments https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS209629   QML report to count the number of documents by different document types https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS216381   How to identify the template that was used to create documents https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS214070   Report all WTParts related to WTDocuments https://www.ptcusercommunity.com/thread/115318?sr=stream&ru=30733 https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS36007   How to create a report listing Documents Context, Name, Number, State, Latest Revision & Iteration, and Age https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS239335   File Name of a document from Query Builder https://www.ptcusercommunity.com/message/457256 https://www.ptcusercommunity.com/servlet/JiveServlet/download/457256-119614/_Document_Search.qml.zip   Report to generate BOM report with Described By and Referenced By Documents https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS238476   Report to get the document, its state and the role responsible to complete the task https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS245051   Query builder report to fetch document which is not related to any other document https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS247264   How to build a report for latest revision of WTDocuments https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS251987     WTPARTS   How to create a Where Used report for WTParts https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210416   How to report "Release Date" of WTPart? (from PTC/User) http://portal.ptcuser.org/p/fo/st/topic=16&post=122009#p122009   How to write a WTPart Where Used Report (Mike Lockwood) Report Manager: How to write a WTPart Where Used Report   How to determine the number of unique part numbers site wide (Tom Uminn) How to determine the number of unique part numbers site wide in Windchill?   How to get the bill of material (BOM) report for latest iteration of latest version for Document Object using Report Manager (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS200270&lang=en&source=community   QML Report to list all Part Instance with its Base Part (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS203321&lang=en&source=community   QML Report to list all WTPart of Specific View in Windchill PDMLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS198025&lang=en&source=community   QML Report to to show association between Deviation and it's associated WTPart https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS205475   Query builder report to fetch the display name and internal name of classification node in Windchill PartsLink (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS184338&lang=en&source=community   Query builder report to find all WTParts and their corresponding PartsLink classification nodes (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS129984&lang=en&source=community   Query builder report to list WTParts from folder https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS208537   Query Builder Report to list all the OEM part which do not have AML\AVL Part associated https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210102   Query builder report to fetch parts at level 0 in structure tab https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS215346   Which Database tables store classification attributes in Windchill PartsLink https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS172788   WTParts not been published to ERP system (Marco Tosin from PTC/User) http://portal.ptcuser.org/p/fo/do/download=1&fid=23280   QML report to query latest version of all WTParts https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS138336   How to get a query builder report for Classification details for Parts and/or Part Structure https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS145972   Query builder report to list WTParts of particular view https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS208737 https://www.ptcusercommunity.com/message/425216#425216   How to create a Query Builder report to list all Parts that do not have Parent Part https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS223922   How to select the latest revision of a Part in a Query Builder report https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS1171   How to get a report of the URL address of WTparts https://www.ptcusercommunity.com/thread/134395?sr=stream&ru=281467   Query to capture WTParts set to Released in the last 4 hours https://www.ptcusercommunity.com/thread/134896?sr=stream&ru=51671   Query builder report to fetch WTParts in a specific Org that have Part Master Default unit set to "as needed" https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS232193   Query builder report to find all WTParts and their corresponding PartsLink classification nodes https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS233215   Report to verify the details of changes in iterations of Part Instance using Described by Documents http://support.ptc.com/images/cs/articles/2014/10/20163203_G4Hv.qml   Query Builder report to list the Variances reported against Parts https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS234246   SuMa - Report to list the Manufacturer associated with the specific Context Organization https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS234911     TROUBLESHOOTING Change Requests not automatically associated with corresponding Problem Report https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS211530   Custom reports return error "wt.query.QueryException: Attribute "first" is not a member of class "class wt.org.WTUSER" after upgrading to Windchill PDMLink 10.2 https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS194425&lang=en&source=community   Failed to delete some report templates from Site>Utilities>Report Management https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS185149 Generating a report from Context > Reports > Change Request Logs caused MethodServer to crash with OutOfMemoryError https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS203309   Reports imported or created at Organization level are not available for non-admin users on Homepage https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS52000   Report Builder is inadvertently removing a condition from the subquery while attempting to modify the qml with user entered data https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS186246 Using Date Picker in a OOTB Report in a browser that is not in English results a "Timestamp format" Error https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS215342   Unable to save configuration of a legacy report in Windchill PDMLink 10.2 M020 (PTC TS) https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS188794&lang=en&source=community   When a variable is used in Select and Criteria section of Query Builder with Input Parameter, report page generated doesn't display alias name of variable in Input Parameters section https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS133386   Not able to Save reports having Chart using Organization Admin user giving secured action error https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS179575   Failed to export the results generated for Reports using Report Manager https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS204259   Information or Details page for Report Templates shows Creator attribute value as ???createdby??? where creator is not available https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS221397   Data monitor criteria filter for created on time of "Yesterday" not covering entire day https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS226634   In Report Builder, like operator does not returns exact searched string https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS224643   Report result will not be merged even select the "HTML (with merging)" in "Generate Legacy Mode Output" https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS222197   Soft types created at the organization level not available in Query Builder launched from "Site" > "Utilities" https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS227163   When searching for objects that have empty IBA with "not like" criteria, Query Builder and Search UI will give inconsistent results https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS159539   Not able to set up changeable filter criteria in Query Builder Approver Status field for attribute eventlist of type wt.workflow.definer.UserEventVector in Windchill https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS235453   Getting an error message as "Report can only be launched when Windchill Business Reporting is installed" in Windchill https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS124351   Data monitor against "Open Change Notices" report template status is "failed" https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS236920   Report to list Suppliers (Manufacturer) with their associated Documents https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS240978   Query Builder does not list the Display Name of Sourcing Status attribute values in Windchill PDMLink 11.0 https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS241420   Unable to run cognos reports in Windchill 10.2 https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS210583   Reports using macro CURRENT_TIME that used to work before update don’t work anymore in Windchill PDMLink 10.2 M030 https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS248659   Query Builder Report to get the list of parts which does not have any related document https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS251347   Upgraded reports where attributes with an enumerated list that were previously defined in the Criteria tab no longer display the enumerated list in the drop-down in Report Builder in Windchill 11.0 https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS252519   When user added java method then selected allow user to decide option all of column user is not able to generate report. https://support.ptc.com/appserver/cs/view/solution.jsp?source=community&n=CS253057
View full tip
With Windchill 11.0 one can use Query Builder queries to further refine search results.  For example refine the search to look at results based upon related objects.   This zip file contains two queries from 11.0 M020   Search with Parts - additional query to find parts that are on a Change Notice at a given state Reference Designator - Find parts on a BOM with a given reference designator.  For example - find a part (eg Name Capacitor*) that has a reference designator C16
View full tip
Recently a customer asked if it were possible to disable Owner association, and instead have the system default to using Contributing Image association between WTParts and CAD Documents.  I figured there might be others interested so I thought I would post the solution, as the steps to achieve this desired behavior might not be entirely obvious. Before doing so, however, I have to give credit to my colleague, Jennifer Pierron, for providing me with these steps. Here we go… In this case, the goal is disable Owner association for CAD assemblies and parts and display Contributing Image as the default association type in the Edit/Auto Associate UI.  You configure a set of Site preferences to accomplish this task.  I repeat - Site preferences.  These preferences cannot be set on a per-user or organization level basis. They apply across your entire installation. First, you need to establish which attributes you want to pass from CAD Documents to WTPart via the Contributing Image association.  This can be done by setting the Site preference EPM Service Preferences > Build Service Preferences > Contributing Image Attributes to * for all attributes, or you may specify individually using a list of attribute names.  If you do not specify any attributes, then the system defaults to using an Image association instead of a Contributing Image association. In effect, the preference settings in the following figure enable Contributing Image associations in your system. Next, configure the CAD Document types for which you do not want to build structure (disallow Owner associations).  In this example we disallow the building of structure for Creo Parts and Assemblies.  To accomplish this, we add CADCOMPONENT and CADASSEMBLY to the list of types for which building structure is excluded.  This is done by editing the preference Operations > Auto Associate > Disallow Structure CAD Document Types > Creo as shown in the following figure. As a final step, If you want to allow Auto-Associate to create parts, you need to set the value of the preference Operations > Auto Associate > Create New Part to Owner and Contributing Image as shown in the following figure. The default is to allow this for Owner association types only. Once these preferences have been set, when you perform an Edit Association, you should be presented something similar to the following. I hope you found this useful.
View full tip
Polaris strives to give a great end-to-end experience for its riders, from customized purchase options to enhanced safety features. To achieve this vision, Polaris is adopting a step-by-step approach to digital transformation through PLM. In this series of 10 technical demos, you'll see what Polaris has either currently implemented or is considering as a part of its PLM/digital transformation roadmap.    BOM Management and Global Platforms — Manage and link CAD data, bills of material, and visualization for a modular EBOM structure and generate options and variants for design verification and visualization Family Management — Plan product families and manage options, choices, and assignments in multi-year product structures Change Management — Manage change of a new option from EBOM to MBOM through process plans and work instructions Augmented Reality — Variant-specific AR design review and visualization and process plan visualization BOM Transformation — Associatively transform EBOM to MBOM and EBOM to SBOM with options and logic Manufacturing Process Planning — Concurrently develop mixed-model assembly process plans Role and Task-Based Access — Access digital product information based on the task and function within an organization BOM Costing Application — Create custom mashups of variant-specific cost tracking and roll-up Interference Detection — Develop variant-specific validations with DMU/interference analysis Visit: https://www.ptc.com/en/products/plm/everyday-innovation/innovator-spotlight-polaris/polaris-plm-demonstrations to check out this great demo series - we hope this gives you some inspiration in your own digital transformation initiatives.  
View full tip
An example of uploading multiple representations to one CreoView session rather then having to start new sessions for each one.   I was adding as a comment on a Product Idea but it was not letting embed it so I added this a separate video and linked it.  The idea is the following:     (view in My Videos)    
View full tip
Check out this video on Using Windchill "Windchill For You" from PTC Application Engineers Presenters: Ryan Butcher (Solution Consulting, Fellow). Original Date Presented: November 15, 2023   To dive deeper into the subject, check out What's New in Windchill PLM  
View full tip
About this event: The CAD-Driven BOM The part-centric methodology orchestrated by Windchill is an integral component to the digital thread, enabling enterprises to realize their digital transformation goals.  A model-based approach of driving the creation of the eBOM from native CAD data delivers an automated mechanism providing a highly visual BOM to the extended enterprise.  Although this may sound simple enough, CAD design decisions don’t always match the way engineering expects the BOM to be structured.  Managing these complex associations while keeping information and changes synchronized, whether made in CAD or to the BOM, can prove challenging. Join presenter Steve Shaw, PLM Solutions Director, on March 11 th  at 10 am EST, for this Tech Tips session where he will: Explore the recent improvements to the tools and capabilities available in Windchill’s CAD integration and BOM management; Demonstrate how these tools and capabilities can help streamline the process, identify differences, and manage the connection between CAD and the engineering BOM; Explain how to synchronize all of the information back to the BOM for downstream consumption and visibility. You won’t want to miss it so Register Today! 
View full tip
Windchill Extensions from SiliconExpert Ensure Design Viability By SiliconExpert and PTC   Garbage in.  Garbage out.  The familiar computer science concept refers to the fact that the resulting output is dependent on the quality of the input.    The same is true for industrial design.  Complex product designs are dependent on the components required to build them.  An otherwise beautiful design can turn to garbage when composed of parts that are non-compliant or become obsolete.      Windchill PLM software reduces the time to industrialization by digitizing and connecting your enterprise across the globe.  Product design is a complex process that requires information from a myriad of sources.     Windchill Extensions from SiliconExpert help ensure the long-term viability of your designs.   As a leading development and administrative support suite, SiliconExpert is unifying semiconductor and mechanical parts management from design to end of life.  SiliconExpert’s team of electronics engineers are available to answer system questions as well as maintain a current database of data points to ensure users are confident in the components which make up their designs.      SiliconExpert CONNECT    SiliconExpert CONNECT is embedded into Windchill, providing access to trusted design and component libraries.  It identifies potential risk from lifecycle classification and compliance information, while providing crosses, stock levels, and pricing data. This means your engineers get access to reliable data when they need it in order to drive their decisions and streamline design processes.    With SiliconExpert CONNECT, engineers can search and validate orderable part numbers using the SiliconExpert validation algorithm, resulting in a list of standard parts.  You can also analyze your bill of materials and identify parts that might put your design at risk.  With the click of a button, proprietary algorithms give you a thorough risk review by part and allow you to cross reference replacement parts.  All known form-fit-function cross-references and supplier replacements for a manufacturer part number can then be found.    SiliconExpert Synch    With SiliconExpert Synch, your engineer’s designs are synchronized with the parts in an information repository. Engineers can initiate synchronization from a part, a folder page or a search, and obtain new information regarding compliance, availability and price. This ensures their design has the most current data available.          SiliconExpert electronic engineers stand behind this information, since their relationships with suppliers enhance the accuracy of a part’s expected availability as well as its regulatory compliance.  When this information is updated, SiliconExpert Synch makes it possible for designs to update regularly as well.    State of the art technology and machine learning play a part in enhancing information. Through SiliconExpert, data points provide insights into material prices and availability in order to adjust parts’ forecasts.     Integration with Windchill provides visibility at every stage of the life cycle, ensuring the right parts for your design, saving time and money by preventing errors. This eliminates “garbage” from entering your designs and ensures pristine outcomes.    Try the SiliconExpert CONNECT Starter in the Windchill Extension Center and render live data in the Windchill interface, allowing your engineers to monitor a part or a BoM to check for compliance, obsolescence, end of life, and more.  The Starter extension is limited to 200 parts, but does not require a SiliconExpert license.  It’s a great first-look at the value SiliconExpert brings to Windchill.    To learn more about SiliconExpert extensions, visit the PTC Windchill Extension Center at  https://windchill-extensions.ptc.com/home
View full tip
In this example Change Associations are used to define that a Prototype CN (Soft typed) will have a single Change Task - Prototype Change Task that is defined as the default change task for this type of Change Notice.   With Windchill 11.0 M010 and onwards you can define which Change Task types are allowed and created for a type of Change Notice.  This is allow followed with Change Task templates.  Together this helps to error proof your process and reduce clicks for the user.
View full tip