Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

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

Avatar

Level 1

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!

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 8

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.

View solution in original post

6 Replies

Avatar

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

Avatar

Level 1

Thanks so much for the help! Unfortunately this is a method I've already tried with no luck.

This is the string now:

group.0.linkedname=owner

group.0.namekey=view.relatedcolumn

group.0.valuefield=owner:roleID

group.0.namekeyargkey.0=owner

group.0.namekeyargkey.1=roleID

group.0.valueformat=string

group.1.linkedname=direct

group.1.namekey=Department/Location

group.1.valuefield=Department/Location

group.1.valueformat=customDataLabelsAsString

textmode=true

Avatar

Level 8

What type of report are you trying to run (User, Task, etc.)?

Avatar

Correct answer by
Level 8

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.

Avatar

Level 1

Thanks so much for your help, I really appreciate it! :) Have a great weekend!