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

[jfrankovich]

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

[BineshKumar1]

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.