Collections ValueExpression and Parent Data | Community
Skip to main content
ChrisFrancis93
Level 2
July 31, 2025
Solved

Collections ValueExpression and Parent Data

  • July 31, 2025
  • 1 reply
  • 356 views

I have built a task report.  I am accessing the Predecessor collection as follows:

displayname=Predecessor Planned Lag
listdelimiter=<p>
listmethod=nested(predecessors).lists
type=iterate
valuefield=predecessor:actualCompletionDate
valueformat=HTML

but what I would really love to do is get the WEEKDAYDIFF of the predecessor Actual completion Date and the current task actualStartDate

 

displayname=Predecessor Planned Lag
listdelimiter=<p>
listmethod=nested(predecessors).lists
type=iterate
valueexpression=WEEKDAYDIFF({predecessor}.{actualCompletionDate}, {CURRENT TASK ACTUAL START DATE})
valueformat=HTML

 

Is it possible to reference a field on the current object within a collection field like this, and if so, how?

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 skyehansen

haha I hear ya. I think you should think about other dates that might serve the same purpose. Have you looked into using the current task's handoff date? I feel like the handoff date is the date it was handed off from the predecessors, and that would keep you on task without looking upstream into collections.

1 reply

skyehansen
Community Advisor and Adobe Champion
July 31, 2025

that isn't possible at this time. 

ChrisFrancis93
Level 2
July 31, 2025

Thanks.  Boo but thanks for the quick reply.

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
July 31, 2025

haha I hear ya. I think you should think about other dates that might serve the same purpose. Have you looked into using the current task's handoff date? I feel like the handoff date is the date it was handed off from the predecessors, and that would keep you on task without looking upstream into collections.