Windchill PLM "Query Builder Reporting" Tips & Techniques Session Recording (West Coast)
- Oct 23, 2026 5:05 PM UTC
- 2 replies
- 10381 views
- Translate All
Check out this video on Using Windchill "Query Builder Reporting" from PTC Application Engineers
Presenters: Ryan Butcher (Solution Consulting, Fellow).
Original Date Presented: July 20, 2022
To dive deeper into the subject, check out Winchill Query Builder Tutorials
Watch Guide
Overview
This PLM Tips and Techniques webcast (running time 1:00:39), presented by Ryan Butcher of PTC, shows how to report on PTC Windchill data, starting with saved searches and out-of-the-box reports and moving on to building report templates with Query Builder. It is aimed at Windchill users and administrators who want to create their own reports, and includes live demos of filtering reports, live charts, and joining parts to documents and change requests to tasks.
Chapters
This video has chapters, also available from the player menu.
- 0:00 to 3:27: Welcome, agenda, and series schedule
- 3:27 to 8:06: Saved searches: preview, criteria, and reuse
- 8:06 to 13:23: Custom table views and grouping in search results
- 13:23 to 16:07: Out-of-the-box BOM reports, custom views, and export
- 16:07 to 18:45: Standard reports: Query Builder, Cognos, and Jasper
- 18:45 to 20:09: Q&A: custom headers in generated reports
- 20:09 to 21:39: Query Builder basics: the three main steps
- 21:39 to 26:50: My Saved Reports and filtering a report
- 26:50 to 31:21: Live charts, chart builder, and saving the report
- 31:21 to 35:45: Report Management and report template properties
- 35:45 to 41:17: Adding types and reportable items, then testing
- 41:17 to 47:07: Joining parts to documents (described-by link)
- 47:07 to 49:26: Q&A: template editor path and results table views
- 49:26 to 56:14: Multi-object report: change requests, tasks, owners
- 56:14 to 1:00:39: Shortcuts, learning tips, and closing Q&A
Key Takeaways
- A Windchill saved search works as a simple report: save the criteria once and rerun it. Administrators can save system-wide searches that are available to all users.
- Out-of-the-box report tables, such as the multi-level BOM report, have a View menu for custom column views, and the results can be exported as CSV, HTML, PDF, Excel, or XML.
- Every Query Builder report involves three things: Properties (name, description, and options), Tables and Joins (the object types and how they relate), and Select or Constrain (the attributes to report).
- To build report templates, a user needs access to at least the organization level. Query Builder opens from Site or Organizations, then Utilities, then Report Management.
- Show types in use filters the type list to types actually used in your system. In the demo, 2,963 types were listed, filtering on "part" gave 101, and Show types in use cut that to 47. Show joins in use works the same way for join types.
- Charts added to a report are live: selecting a value in a chart filters the results table.
- Query Builder report results have no View drop-down. To get a different layout, change or reorder the reportable items, or save a copy of the report.
How do I turn a Windchill saved search into a reusable report?
A Windchill saved search works as a simple, reusable report: define the criteria once in Advanced Search, run it to check the results, and save it under a name. Saved searches are listed under Search History and Saved Searches, and hovering over one previews its criteria; for searches you created, you can edit the criteria from that preview. Administrators can also save system-wide searches that are available to all users.
- Clear the object types: In Advanced Search, choose All Types and then clear it to remove the preselected types.
- Set the criteria: In the demo, the search looks for promotion requests in the Approved state. With all contexts selected, it covers all products, projects, and libraries.
- Run and check: Run the search and confirm the results are what you expect.
- Save the search: Save it with a descriptive name, in the demo "Approved PRs".
Watch: 3:27 to 8:06 (saved search preview, then building and saving the approved promotion request search)
How do I change the columns shown in Windchill search results?
Create a custom table view from the View menu above the Windchill search results to choose which columns the saved search reports. You can edit the default view with the pencil icon, copy it as a starting point, or create a new empty view and add only the columns you want. In the demo, a copy of the Default Promotion Request View gains an Owner column and then appears in the View menu as a new view.
- Open the view settings: From the View menu, choose to customize the view.
- Copy or create: Copy the default view as a starting point, or create a new view with an empty table.
- Add and arrange columns: Add the column, such as Owner, reposition it in the table, set sorting if needed, and click Finish.
Two more table tools help: the column drop-down can group the results by a field, such as Created By, and the table search box filters the rows, for example to one user's name.
Watch: 8:06 to 13:23 (creating the PR Owner view, grouping by Created By, and filtering the table)
What can I do with out-of-the-box BOM reports in Windchill?
Windchill includes several structure (BOM) reports, such as the multi-level BOM report, that you can customize and export. Each report table has a View menu, so you can change the column display of the default view or create several views and switch between them; in the demo, a Modified By column is added and the report refreshed. Once the report has run, you can export the list as CSV, HTML, PDF, Excel, or XML.
Watch: 13:23 to 16:07 (multi-level BOM report on a drone product structure, adding a column, and the export formats)
Where do I find the standard reports in Windchill?
Windchill standard reports are available from the Reports table in an individual context, or on your home page after you turn on Reports with the Customize button. Which reports you see, such as change, planning, and quality reports, depends on the solutions you use. Some standard reports were built with Query Builder, some with Cognos, the reporting tool previously coupled with Windchill, and some with Jasper Reports, the new reporting tool.
Watch: 16:07 to 18:45 (customizing the home page and browsing the change management and quality reports)
What are the main steps to create a report with Windchill Query Builder?
Every Windchill Query Builder report involves three main steps: set the properties, define the tables and joins, and choose what to select or constrain. The presenter covers Query Builder before Jasper Reports because it is foundational to creating a Jasper report as well.
- Properties: Give the report a name and description and set the other selectable options.
- Tables and Joins: Add the object types (tables) to include and join them to other object types from the database.
- Select or Constrain: Define the attributes from those object types that the report shows.
Watch: 20:09 to 21:39 (overview of the Query Builder process)
How do I filter a saved Query Builder report in Windchill?
Open the report from the Saved Reports table, enter criteria in its filter fields, and click Generate. The Saved Reports table can show your own saved reports or all saved reports exposed to the system. The demo uses a change notice dashboard that joins WTPart to the change notice object and returns 180 objects; filtering the change notice number on 007 with the "like" operator reduces the results to 6. Other operators include equal to, not equal to, greater than, null, and not null, and date fields have a date wizard for entering a range, such as a resolution date window.
Watch: 21:39 to 26:50 (reviewing the change notice dashboard criteria and filtering it)
How do I add a chart to a Windchill report?
Select New Chart to open the chart builder, pick the field for the first axis, and select Add chart to the table. Charts on a Windchill report are live: selecting a value in a chart filters the results table, which in the demo narrows the table to the 15 objects in one product. To keep the chart, save the report from the flyout.
- Open the chart builder: Select New Chart.
- Set the axis: Choose the field for the first axis, such as part context. A preview appears automatically.
- Format the chart: Set the maximum number of values, the font size, and data labels.
- Add the chart: Select Add chart to the table.
- Save: From the flyout, choose Save to create a new report, or Modify Report to replace the original.
Watch: 26:50 to 31:21 (filtering with live charts, building a part context chart, and saving the report)
How do I create a new report template in Windchill Query Builder?
Go to Site or your organization, then Utilities, then Report Management, and choose New Report Template. A user who builds reports with Query Builder needs access to at least the organization level. From the same Report Templates table, you can right-click an existing template to view the report or edit the template.
- Open Report Management: Go to Site (or Organizations), then Utilities, then Report Management.
- Create the template: Choose New Report Template and enter a name, such as Parts with Documents, and an optional description.
- Choose the options: Select the properties you need from the list below.
Options shown in the demo:
- Expose as a report: makes the report available to everyone from the Reports table.
- Add time to the date fields: includes the timestamp with dates in the report.
- Available for use with advanced search: lets users run the report as part of a related object search in Advanced Search.
- Use as a join model: lets other users start a new report from this one.
Watch: 31:21 to 35:45 (Report Management table and the report template properties)
How do I add object types and reportable items in Query Builder?
Add a type on the Tables and Joins tab, which becomes active once the template has a name, then pick its attributes on the Select or Constrain tab. The type list is long (2,963 types in the demo system), so filter it by name and select Show types in use: filtering on "part" returned 101 types, and Show types in use narrowed that to 47. On Select or Constrain, hold Ctrl to select several reportable items at once.
- Add a type: On Tables and Joins, add a new type, filter by name, select Show types in use, choose the type, and click OK. You can change its alias if you want.
- Pick reportable items: On Select or Constrain, Ctrl-select attributes such as name, number, last modified, and assembly mode.
- Apply and test: Click Apply, then View Report and Generate. With only the part type, the report returned every part in the system, more than 2,000 objects.
Watch: 35:45 to 41:17 (filtering to types in use and previewing the first parts report)
How do I join two object types in a Query Builder report?
To join two object types in Query Builder, drag from the small orange icon at the lower right of one object onto the other object, then choose the join type. In the demo, the Document type is added (68 types listed, 41 in use) and joined to Part; selecting Show joins in use leaves only one join type, the WTPart describe link. Hovering over a join arrow highlights the two objects it connects. After adding the document name and number as reportable items and clicking Apply, the report returns 160 objects: the parts that have at least one described-by document.
The same chart builder works on template reports; the demo adds a pie chart of assembly mode and uses it to filter to component-based parts.
Watch: 41:17 to 47:07 (creating the part-to-document join and adding a pie chart)
How do I build a Query Builder report of change requests, tasks, and owners?
Add the work item, WT change request, and part types, join them, and choose reportable items for each; a change request task is called a work item in Windchill. In the demo, the finished report returns 268 objects listing change requests, their tasks, and the task owners. The presenter notes the report could be extended to show where tasks are in the workflow.
- Add the types: Work item, WT change request (filter on "change"), and part.
- Join work item to change request: Use the primary business object join, the only one in use.
- Join change request to part: Use relevant request data, the only join available for that pair.
- Add reportable items: The work item, the work item owner's identity (ownership, then owner, then identity), the change request, and the part.
- Apply and generate: Click Apply, then View Report, then Generate.
Watch: 49:26 to 56:14 (building the three-object change request task report)
What are the best ways to learn Windchill Query Builder?
Start by editing existing reports to see which tables, joins, and reportable items they use. An object's details page also shows what related objects are called; for example, a change request's details show that its task is a work item. Filter to types and joins in use, and expect some trial and error: if a report doesn't return what you want, try a different reportable item or join type. As a shortcut, you can add a new object and its join in one step from an existing object, for example adding Document with the Described By link.
Watch: 56:14 to 58:58 (adding an object and join in one step, then the presenter's learning tips)
Frequently Asked Questions
Q: Can you make custom headers and parameter-driven title blocks in Windchill generated reports?
A: Yes, you can change headers, but it depends on how the report was created. You need the right level of access to edit the report, and you make the change in whichever reporting solution was used to create it. (answered at 18:51)
Q: Where do I open the report template editor (Query Builder) in Windchill?
A: You need access to an organization or to the site. Go to Organizations, then Utilities, then Report Management, or to Site, then Utilities, then Report Management. The Report Management table gives you access to the templates. (answered at 47:11)
Q: Can I change the results table view of a Query Builder report?
A: Not with a view drop-down, because Query Builder report results don't have one. Change the reportable items or their order instead, or save several reports, for example by copying an existing report and adding content. (answered at 48:18)
Q: Can a Windchill report results table show column headings vertically?
A: The presenter didn't believe so, but wasn't certain and offered to check. (answered at 59:00)
Q: Can you create custom macros for reportable items in Query Builder?
A: Yes. There are many ways to add reportable items and constraints that the session did not cover, and you can automate this or write queries programmatically. (answered at 59:19)
Links & Resources
- Managing Report Templates (support.ptc.com)
- Using Query Builder to Author Reports (support.ptc.com)
- Reports and Queries (support.ptc.com)
- Using JasperReports (support.ptc.com)
- Create a Report in Query Builder (tutorial) (learningconnector.ptc.com)
- PLM Tips and Techniques Webcast Series (West) (community.ptc.com)

