Reference Task's collection in project report | Community
Skip to main content
Lawson02
January 2, 2025
Solved

Reference Task's collection in project report

  • January 2, 2025
  • 2 replies
  • 877 views

Is it possible to reference a task's collection in a project report? Yes I know that I can just make a task report for this but I would like to get to know the syntax and what the limitations are before creating a whole new report.

Best answer by Kurt_Jones

The screenshot I posted was an example of what I wanted it to look like, this is what I have currently

 


Lawson02, there's not a way to make these iterated lists be clickable that's the downside of needing textmode for expressions to pull data.  But I wonder if you could do a shared column with one column being your textmode and a second column being the category name and you could use advanced options to do formatting where text says Click Here for that category name field.  So it would look something like this once merged.  Here's link to shared col setup, https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/view-merge-columns.  Again, its a thought, I've never done this with category name but I have with other fields.

 

Sampling Form

CLICK HERE

2 replies

Kurt_Jones
Community Advisor
Community Advisor
January 3, 2025

Lawson02, yes, you can do this but you'll need to do textmode.  This link, https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/reference-collections-report, gives a good example of the format to show tasks in a project report like you need.

Lawson02
Lawson02Author
January 3, 2025

Yes I read this article, do I reference a task's collection using nested(tasks:objectcategories).list?

Kurt_Jones
Community Advisor
Community Advisor
January 3, 2025

Lawson, here's a sample from my environment we use to help.  This is using a valueexpression but should give you an idea on what the syntax looks like.

 

Collection Example:  Show only Development milestone tasks in format “task name – task status”

displayname=Development

valueformat=HTML

listdelimiter=<p>

textmode=true

valueexpression=IF({milestone}.{name}="Development",CONCAT({name}," - ",{progressStatus}))

type=iterate

listmethod=nested(tasks).lists

kautuk_sahni
Community Manager
Community Manager
September 1, 2025

@lawson02 Just checking in. Were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could benefit the community. Thanks again for being part of the conversation!

Kautuk Sahni