Expand my Community achievements bar.

SOLVED

Report to identify cross-project dependencies

Avatar

Level 4

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? 

 

AnnaHolder_0-1729777461529.png

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 2

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

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

Avatar

Level 4

This is perfect, thank you so much Teale!