Displaying a Specific Milestone Due Date In A Column (Task Report) | Adobe Higher Education
Skip to main content
Eric_D_Miller
Eric_D_Miller
Level 5
February 8, 2024
Beantwortet

Displaying a Specific Milestone Due Date In A Column (Task Report)

  • February 8, 2024
  • 1 Antwort
  • 943 Ansichten

Hello,

 

I am attempting to display the due date of a specific Milestone in a column. I can achieve this in a Project report with the below code but it does not work in a Task report. Can anyone help me with what I am doing wrong?

 

displayname=XX
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({milestoneID}="XX"&&{status}!="CPL",CONCAT({plannedCompletionDate}),IF({milestoneID}="XX"&&{status}="CPL",CONCAT("✔️ | ",{plannedCompletionDate})))
valueformat=HTML

 

Thank you,

Eric

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von skyehansen

is it possible that you have filtered this particular type of task out of your report?


oh, nevermind. I think I see what you're trying to do. I thought you were saying that if a particular task you're listing is a milestone, you'd want to see certain information. Instead, I am GUESSING what you're saying is that if you're showing a particular task, you would like to go back through the project and somewhere else in the project, pull the milestone ID.

 

OK, so start over, and you just want to change one line in your original blob.

listmethod=nested(tasks).lists

 

That line is calling a collection of tasks within each task. You don't have or want this. So instead, call on all the tasks in your project this way:

listmethod=nested(project.tasks).lists

 

1 Antwort

skyehansen
Community Advisor
skyehansenCommunity Advisor
February 8, 2024

I think if you just take out many of the lines, this should work. I would just start with displayname, valueexpression and valueformat.

Eric_D_Miller
Eric_D_MillerAutor
Level 5
February 8, 2024
displayname=Creative Build Due textmode=true valueexpression=IF({milestoneID}="6422f69500133a81222849087f94e22e"&&{status}!="CPL",CONCAT({plannedCompletionDate}),IF({milestoneID}="6422f69500133a81222849087f94e22e"&&{status}="CPL",CONCAT(" | ",{plannedCompletionDate}))) valueformat=HTML

This returned no data in the column. I did confirm that this Milestone does exist in the project. This is a Task Report if that helps.

skyehansen
Community Advisor
skyehansenCommunity Advisor
February 8, 2024

is it possible that you have filtered this particular type of task out of your report?

Allgemeine NutzungsbedingungenAccessibility statement

Loading footer...