Next Subtask Column in Task Report

Question

I have built a task report that is pulling in tasks that have a specific custom form field on them. The tasks with the custom form field are parent tasks with the name of the deliverable, so there are lots of subtasks. I would like to add a column that lists the next subtask that is ready. I want to be able to see which subtask is next. I have done this on project reports before, but that text mode doesn't work in this report.

This is what I use on my project reports....

description=Tasks Ready to Start
displayname=Next Task(s)
listdelimiter=<div>
listmethod=nested(tasks).lists
type=iterate
valueexpression=IF({canStart}&&{status}!='CPL'&&{status}!='NOT'&&{numberOfChildren}=0,CONCAT("•",{name}))
valueformat=HTML

listmethod=nested(tasks).liststype=iteratevalueexpression=IF({canStart}&&{status}!='CPL'&&{status}!='NOT'&&{numberOfChildren}=0,CONCAT("•",{name}))valueformat=HTML

skyehansen · Accepted Answer

If you look at the API explorer, the collection of tasks under your parent task will be referred to as "children" so it might be as simple as changing your "nested(tasks)" line to "nested(children)". I don't know if I should point out that this only acts on the next level down, so if you have grandchildren tasks or great-grandchildren tasks, you may observe that these tasks are left out.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded