Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

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