Filtering Collections

[AndrewKo]

I am trying to create a project report that filters out all tasks without a milestone and show all the milestone tasks and their percent complete.

The field I created:

displayname=Milestone Tracking

listdelimiter=<br>

listmethod=collected(tasks).list

textmode=true

type=iterate

valueexpression=CONCAT({milestone}.{name},"| ",{percentComplete},"%")

valueformat=HTML

and the filter:

tasks:milestoneID=0

tasks:milestoneID_Mod=notblank

For each project, I return all tasks instead of milestone tasks. Does anyone know how to filter out non-milestone tasks correctly?

Thank you,

[NRYNR]

My approach is a little different. Instead, I only filter on projects that have a milestone path ID.

milestonePathID=59a821d6001d691642ee19889233333d

milestonePathID_Mod=in

Then, as columns in the report, I grab the data. For example:

displayname=Plan

listdelimiter=<p>

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF({milestone}.{name}="Plan",CONCAT({percentComplete},"%"))

valueformat=HTML

displayname=Build

listdelimiter=<p>

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF({milestone}.{name}="Plan",CONCAT({percentComplete},"%"))

valueformat=HTML

displayname=Approval

listdelimiter=<p>

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF({milestone}.{name}="Approval",CONCAT({percentComplete},"%"))

valueformat=HTML

[AndrewKo]

Thank you Narayan, that worked nicely! [Andrew] [Koprowski] [Workfront Administrator] [Jackson National Life]

[NRYNR]

Excellent. Now you can build milestone reports and pull in whatever you wish off those milestone tasks. Pretty useful. Also, I forgot one thing...

Use the <div> listdelimiter instead. I hear it provides the best view of all in dashboards and in exports.

[BenettaPe]

Narayan, I hope this still works in 2020. As i need this type of project report today. Going to try it. Benetta Perry APS