Skip to main content
4-Participant
September 12, 2025
Question

Query Builder not returning Assigned Activities in sub-workflow

  • September 12, 2025
  • 2 replies
  • 223 views

I am using Windchill PDMLink Release 13.0 and Datecode with CPS 13.0.2.3

I am generating a report of assigned tasks, but none of the tasks running in a sub-workflow (a workflow running inside another workflow) appear in the report. I am using the "Wf Assigned Activity" type in the report and it works for all other tasks in that workflow. The tasks in the sub-workflow are also assigned. If I use the "Wf Activity" type I can see those tasks in the report, but I get extraneous data and then can't get assigned user information that I need. Is there another relationship I need in Query Builder to get tasks in a sub-workflow?

2 replies

avillanueva
23-Emerald I
23-Emerald I
September 12, 2025

Can you show your query definition? Screen shots of setup?

18-Opal
September 30, 2025

Hello jschuster,

I think you need to use the wfRequesterACTIVITY table that relates the parent workflow (WfProcess) to its child (WfProcess).

Let me know how it helps.

Also workItem is related to wfAssignedActivity, that is associated to the child workflow.

KR,

Charles.