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
解決済み

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

  • February 8, 2024
  • 1 の返信
  • 943 ビュー

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

このトピックへの返信は締め切られました。
ベストアンサー 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 の返信

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_Miller作成者
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?

契約条件Accessibility statement

Loading footer...