Combining report columns so only the resolving object name is displayed | Community
Skip to main content
J
Jason_Jarvis
New Participant
February 10, 2025
Question

Combining report columns so only the resolving object name is displayed

  • February 10, 2025
  • 1 reply
  • 501 views

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.

1 reply

Rafal_Bainie
Rafal_Bainie
New Participant
February 10, 2025

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.

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

 

J
Jason_JarvisAuthor
New Participant
February 12, 2025

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

Terms & ConditionsAccessibility statement

Loading footer...