Need a Pending Work query in Windchill
Dear PTC Gurus,
I've been starting to create some smaller Queries for new reports for the users and am making progress learning the tool, but one request is a bit of a brain-bender for me on how to set up the logic: I need to make a query that will find all of the pending user tasks on an active Workflow that have not yet been started.
I know that the system only creates a User Task object the moment that task is reached in an active workflow, it doesn't create the whole potential set the instant the WF starts since that would be very inefficient, and I've made other queries that reference the created workflow tasks.
So how do I get a query to find all actively running Workflows, go inside them, find all of the user tasks that have not yet been started or disabled and subsequently the Participant roles for them, cross-reference that to the Members list on the parent object the workflow is working on, filter out non-standard tasks such as one called "Rework Change Task" and display the results by username, role, task name, parent object and host context?
Please advise (and good luck),
Daryl