Skip to main content
1-Visitor
October 24, 2016
Question

How to add the open review task in the change notice to a report?

  • October 24, 2016
  • 0 replies
  • 989 views

The report that was create is able to show all the open task for a Change Notice except the review task.

Used tables

wt.workflow.engine.WfActivitywt.workflow.engine.WfActivitywt.workflow.engine.WfActivity
Work Itemwt.workflow.work.WorkItemWork Item
Userwt.org.WTUserUser
Contextwt.inf.container.WTContainerContext
Change Notice (wt.change2.WTChangeOrder2)wt.change2.WTChangeOrder2

Change Notice (wt.change2.WTChangeOrder2)

Used Joins

Work ItemSourcewt.workflow.engine.WfActivity
Work ItemOwnership.OwnerUser
wt.workflow.engine.WfActivityContextContext
Work ItemPrimary Business ObjectChange Notice (wt.change2.WTChangeOrder2)

Used criteria

Work.Item.Completed By Is null.

When running the report all the open task are displayed except the review task..

Does somebody has any idea what is special to the review task?