Query Builder not returning Assigned Activities in sub-workflow

[jschuster]

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?

[avillanueva]

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

[cgautier]

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.