Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards.

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).