Report to identify cross-project dependencies | Community
Skip to main content
Level 4
Oct 24, 2024 1:44 PM UTC
Solved

Report to identify cross-project dependencies

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.
TealeMc4Accepted solution
Level 2
Oct 24, 2024 2:33 PM UTC

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

2 replies

TealeMc4Accepted solution
Level 2
Oct 24, 2024 2:33 PM UTC

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

Translate
Level 4
Oct 24, 2024 3:32 PM UTC

This is perfect, thank you so much Teale!

Translate