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

Collections ValueExpression and Parent Data

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?

skyehansen
skyehansenAccepted solution
Level 4
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.

View reply

4 replies

skyehansen
skyehansen
Level 4
July 31, 2025

that isn't possible at this time. 

Translate
ChrisFrancis93
ChrisFrancis93Author
New Participant
July 31, 2025

Thanks.  Boo but thanks for the quick reply.

Translate
skyehansen
skyehansenAccepted solution
Level 4
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.

Translate
Terms & ConditionsAccessibility statement

Loading footer...