Added link in the TIPS and TRICKS section:
How to create a query builder report that accepts multiple inputs (PTC TS)
How to hide the "Saved Reports" for particular user (PTC TS)
Query Builder Report displays duplicate entries (PTC TS)
Query builder report to fetch all the values of the multivalued attribute in single row (PTC TS)
Added link as shown below.
TIPS and TRICKS
Multi-valued attributes display multiple times within a Query Builder report
Possibility to make reports in the query builder default to search in the current container
Search on Windchill Report Builder are case sensitive though the Select criteria is "like"
Where is the documentation for how to add Business Reporting to an existing Windchill installation?
ADMINISTRATIVE REPORT (User/Roles/Group/ACL's)
Global Attribute Enumeration
How to export all ACL's related to a specific user
Query builder report to fetch product, role and user from role
Query builder report to fetch "last logged in" of users
Query Builder Report to list all objects shared between projects
Query Builder report to show folders with associated domains
How to get "Promoted on" attribute into a Change Notice report
Query Builder report for counting the Affected Objects in a Problem Report
Query Builder report to fetch checked out objects in user's workspace
Query builder report to fetch the EPMDocuments having annotation
PROMOTION and WORKFLOW
In which database tables are stored the workflow execution objects?
QML report returning runtime routing list for Setup Participants from a workflow
Report to find out values of Promotion Preferences
Query builder report to list Documents from folder
Report to find WTDocuments went for Approval Routing in Windchill ProjectLink
Report to search for Documents by Effectivity
What are the tables and joins required for generating a query builder report for Documents without any Primary Content and Attachments
How to create a Where Used report for WTParts
QML Report to to show association between Deviation and it's associated WTPart
Query builder report to list WTParts from folder
Query Builder Report to list all the OEM part which do not have AML\AVL Part associated
Query builder report to fetch parts at level 0 in structure tab
Which Database tables store classification attributes in Windchill PartsLink
Change Requests not automatically associated with corresponding Problem Report
Failed to delete some report templates from Site>Utilities>Report Management
Generating a report from Context > Reports > Change Request Logs caused MethodServer to crash with OutOfMemoryError
Reports imported or created at Organization level are not available for non-admin users on Homepage
Report Builder is inadvertently removing a condition from the subquery while attempting to modify the qml with user entered data
Using Date Picker in a OOTB Report in a browser that is not in English results a "Timestamp format" Error
Added link as shown below
TIPS and TRICKS
How to create bar chart report with number of records created in each month
Use of Options in the Select Tab of Report Manager
Information regarding how to use the Query Builder functions
How can a report be run on a schedule and emailed to a user in Windchill PDMLink?
Query builder report to display "Comments" column of Object
How to allow users to see all part numbers even though they do not have access to all parts?
How to add Info (Details Page) button and email links in query builder reports
Query Builder Criteria Logic for getting last month
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
How to get "Download" event information in Security Audit Reporting
Query Builder report to fetch latest version of WTDocument,EPMDocument and WTPart in Library Context for particular state
QML Report to list all the Users in Organization
How to list Classification Nodes and their related attributes
QML report to retrieve the Distinguished Name of all Users
Query builder report for listing prohibit publishing objects
Is there a way to Search Check in comments for CAD or Documents
How to create a visual monitor report that shows open, in progress and complete Change Requests
Query builder report to fetch problem report with associated part
Change object Date Completed
How to get a list of all family table instances with a status of "Unverified" or "Unknown"
Query Builder Report to fetch the universally uploaded object
How to build a report for latest version of EPMDocuments
QML report to count the number of documents by different document types
QML report to query latest version of all WTParts
How to get a query builder report for Classification details for Parts and/or Part Structure
Query builder report to list WTParts of particular view
How to create a Query Builder report to list all Parts that do not have Parent Part
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
Not able to Save reports having Chart using Organization Admin user giving secured action error
Failed to export the results generated for Reports using Report Manager
Information or Details page for Report Templates shows Creator attribute value as ???createdby??? where creator is not available
Data monitor criteria filter for created on time of "Yesterday" not covering entire day
In Report Builder, like operator does not returns exact searched string
Report result will not be merged even select the "HTML (with merging)" in "Generate Legacy Mode Output"
Soft types created at the organization level not available in Query Builder launched from "Site" > "Utilities"
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?
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.
I just posted a large amount of reports to the group. I do believe there are a few in regards to process and activity completion time. Please take a look at these reports and see if one can be modified to meet your need.
Added link to reports taken from Dax Williams documents.
Action Item with Workflow Process
Attribute Ids by Name
Document Template Info
User Login Audit
User Login Totals
User Specified Preferences
Quantity of Measure
Report Manager Report List
Team Template Info
Part Version Scheme
Lifecycle Template Info
Total EPMDocuments and File Size by Context
WTDocuments with File Size