Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Combining report columns so only the resolving object name is displayed

Avatar

Level 1

I'm trying to build a report that includes the name of the original Issue/Request and the resolving object (which could be a Project or a Task). When I combine the columns, however, I can't figure out how to display the Issue name when there isn't a resolving Task or Project.

Topics

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

2 Replies

Avatar

Community Advisor

I think there is something missing in this question, but with this code

column.1.displayname=
column.1.linkedname=direct
column.1.namekey=name
column.1.querysort=name
column.1.sharecol=true
column.1.textmode=true
column.1.valuefield=name
column.1.valueformat=HTML
column.2.sharecol=true
column.2.shortview=true
column.2.textmode=true
column.2.value=</span><hr>
column.2.valueformat=HTML
column.3.linkedname=resolveTask
column.3.namekey=view.relatedcolumn
column.3.namekeyargkey.0=resolveTask
column.3.namekeyargkey.1=name
column.3.querysort=resolveTask:name
column.3.textmode=true
column.3.valueexpression=IF(!ISBLANK({resolveTask}.{name}),{resolveTask}.{name},IF(!ISBLANK({resolveProject}.{name}),{resolveProject}.{name},""))
column.3.valueformat=HTML

you will get a combined column with issue name as top row and resolving task/project as lower row (or empty if no resolving task/project), e.g.

Rafal_Bainie_0-1739209428908.png

there is probably too much code for the column 3, but as a starter it might help

 

Avatar

Level 1

This is helpful, thanks. But I only want the resolving object to be displayed if one is present or the Issue name if there is no resolving object (Task or Project).