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
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
THANK YOU!!! This is exactly what I needed to show!
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies