Next Subtask Column in Task Report

[JHulet]

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

[skyehansen · Accepted solution]

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.

 

[JHulet]

Thank you! Adding children does work, but you are right, it does not show if there are grandchildren or great-grandchildren tasks. 

[Doug_Den_Hoed__AtAppStore]

Hi @JHulet,

If, in addition to seeing just the Children Tasks that Can Start, you'd also like to see all Tasks (including grandchildren, great-grandchildren, siblings, cousins, etc.), I invite you to consider this thread.

Regards,

Doug