cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Is there a way to get Implementation Plan task sequence number on a QueryBuilder report?

jfrankovich
10-Marble

Is there a way to get Implementation Plan task sequence number on a QueryBuilder report?

I am trying to generate a report in QueryBuilder (10.2) that will list all of the Implementation Plan tasks of a CN (just like the Imp Plan tab) and I would like to show the Sequence number. I thought I had it figured out when I found wt.change2.changeplanning.ChangePlan.Sequence but that is not it. (all results are zeros) Then I found  wt.change2.changeplanning.ChangePlanActivity.Sequence, but that doesn't appear to be it either, although looking at the raw tables, there appear to be valid sequence numbers there, just not for my activities.

Does anyone have any idea how to extract that data in QueryBuilder?

Thanks,

John

1 REPLY 1

If we link it to change plan, it should get you the right result. If we do a direct link it does not return summary activity.

Query_Builder_-_ChangeNoticeTask.png

Top Tags