Report to identify cross-project dependencies | Community
Skip to main content
A
AnnaHolder
Level 4
October 24, 2024
Solved

Report to identify cross-project dependencies

  • October 24, 2024
  • 1 reply
  • 619 views

I've built a report using the filter described on this post Solved: Report to identify cross-project dependencies - Adobe Experience League Community - 496229

 

On my report columns I'd like to be able to see the name of the Cross Project, as well as the name of the predecessor task. Any tips on how to accomplish this? 

 

 

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 TealeMc4

Hi Anna, 

 

I've used this text mode code previously and it will show you the cross project condition with the unicode icons and the name and task name. 

 

displayname=Cross Project Predecessors Project and Task
listdelimiter=<p>
listmethod=nested(predecessors).lists
textmode=true
type=iterate
usewidths=true
valueexpression=IF({predecessor}.{project}.{ID}={successor}.{project}.{ID},"",IF({predecessor}.{project}.{condition}='AR',CONCAT('🌕 ',{predecessor}.{project}.{name},'; task',{predecessor}.{taskNumber},' - ',{predecessor}.{name},'- ',{predecessor}.{status}),IF({predecessor}.{project}.{condition}='IT',CONCAT('🔴',{predecessor}.{project}.{name},'; task',{predecessor}.{taskNumber},' - ',{predecessor}.{name},'- ',{predecessor}.{status}), CONCAT('✔',{predecessor}.{project}.{name},'; task',{predecessor}.{taskNumber},' - ',{predecessor}.{name},' - ',{predecessor}.{status})) ))
valueformat=HTML
width=250

 

I hope this helps,

Teale

1 reply

T
TealeMc4Accepted solution
Level 2
October 24, 2024

Hi Anna, 

 

I've used this text mode code previously and it will show you the cross project condition with the unicode icons and the name and task name. 

 

displayname=Cross Project Predecessors Project and Task
listdelimiter=<p>
listmethod=nested(predecessors).lists
textmode=true
type=iterate
usewidths=true
valueexpression=IF({predecessor}.{project}.{ID}={successor}.{project}.{ID},"",IF({predecessor}.{project}.{condition}='AR',CONCAT('🌕 ',{predecessor}.{project}.{name},'; task',{predecessor}.{taskNumber},' - ',{predecessor}.{name},'- ',{predecessor}.{status}),IF({predecessor}.{project}.{condition}='IT',CONCAT('🔴',{predecessor}.{project}.{name},'; task',{predecessor}.{taskNumber},' - ',{predecessor}.{name},'- ',{predecessor}.{status}), CONCAT('✔',{predecessor}.{project}.{name},'; task',{predecessor}.{taskNumber},' - ',{predecessor}.{name},' - ',{predecessor}.{status})) ))
valueformat=HTML
width=250

 

I hope this helps,

Teale

    A
    AnnaHolderAuthor
    Level 4
    October 24, 2024

    This is perfect, thank you so much Teale!

    Terms & ConditionsAccessibility statement

    Loading footer...