Solved

Looking to change the Role IDs in a report grouping to the actual Primary Role name...

Forum|Forum|4 years ago
August 26, 2021
3 replies
1250 views

Hey all, I'm trying to adjust the grouping names in a report from the Role ID to the Primary Role. In text mode, is there a way to translate the ID to the name that actually makes sense for the viewers? Any help would be appreciated!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by TerryHy

In your group.0, change: group.0.valuefield=owner:roleID to the following:

group.0.valuefield=owner:role:name

And change: group.0.namekeyargkey.1=roleID to the following:

group.0.namekeyargkey.1=role:name

I tested this out with an Issue Report and I got results grouped by the role name.

T

TerryHy

Level 8

Hi Taylor, yes. Just change wherever it says "roleID" to "role:name". So for the below, valuefield=roleID, would be valuefield=role:name. This will work for any report where you want to change ID to Name; you would just need to change where it says ID to :name

displayname=

linkedname=direct

namekey=roleID

querysort=roleID

valuefield=roleID

valueformat=HTML