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

Collections ValueExpression and Parent Data

  • July 31, 2025
  • 1 reply
  • 351 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
New Member
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.