Expand my Community achievements bar.

SOLVED

View Column showing parent tasks only as list

Avatar

Level 2

On a Report View Column I only want to show the parent task name and not every single subtask how do I write that?
listmethod=nested(tasks,indent).lists. (WRONG)

 

displayname=Project Tasks Names
listdelimiter=<p>
listmethod=nested(tasks).lists.  (WORKS FINE)
textmode=true
type=iterate
valuefield=name
valueformat=HTML

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

You need to replace valuefield with a valueexpression that will only list parent tasks.

displayname=Parent Tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({numberOfChildren}>0,{name},"")
valueformat=HTML

 

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

View solution in original post

8 Replies

Avatar

Correct answer by
Community Advisor

You need to replace valuefield with a valueexpression that will only list parent tasks.

displayname=Parent Tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({numberOfChildren}>0,{name},"")
valueformat=HTML

 

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

Avatar

Level 2

Thank you,  that somewhat worked BUT if I have a project that has 3 tasks & 2 without any subtasks then it returns null fro 5 &6?
(5 & 6) are Parent Tasks without any subtasks

 

Tom2600_1-1676648969110.png

 

Avatar

Community Advisor

If you want to list parent tasks as well as tasks without children, this will work:

displayname=Parent Tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(ISBLANK({parentID}),{name},"")
valueformat=HTML

 

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

Avatar

Level 2

THANK YOU!!! This is exactly what I needed to show!

Avatar

Level 2

If I wanted to create a report that shows these groupings

 

Portfolio name

Program name

Project name

And these Columns shown...

Task name

Assignment(s)

Due on

Do I need to write this in Text Mode only or are they OOTB in lookups?

Avatar

Community Advisor

It depends on what kind of report you are making. 

It looks like a Task report. If so, everything you've listed can be done out of the box. If this task report is meant only for parent tasks as mentioned in the earlier thread, you can include "Task >> Parent ID = is blank" in your filter rule.

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

Avatar

Level 2

Thanks, where I am having the issue is Filtering and showing all tasks INCLUDING Parent > Sub Parent > Sub Sub Parent > Task 

I want to show all 4 levels in my report, I tried txt below in bold but the parents still don't show.

groupID=6351714c00134bd9cdf6464d54f185fb
groupID_Mod=in
parentID_Mod=notblank
numberOfChildren=0
numberOfChildren_Mod=eq

plannedStartDate=$$TODAY
plannedStartDate_Mod=between
plannedStartDate_Range=$$TODAYb+2w
project:name=QUE
project:name_Mod=cinotcontains

Avatar

Level 2

I also need to figure out how to show any task that should be worked on (based on planned start date and duration) and future task that are 2 weeks out.

SORRY I know alot of questions here!