View Column showing parent tasks only as list | Community
Skip to main content
T
Tom2600
Level 2
February 17, 2023
Solved

View Column showing parent tasks only as list

  • February 17, 2023
  • 1 reply
  • 1716 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by William--

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

 

1 reply

William--
Community Advisor
William--Community AdvisorAccepted solution
Community Advisor
February 17, 2023

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
    T
    Tom2600Author
    Level 2
    March 13, 2023

    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?

    T
    Tom2600Author
    Level 2
    March 14, 2023

    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


    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!

    Terms & ConditionsAccessibility statement

    Loading footer...