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!
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
What type of report are you trying to run (User, Task, etc.)?
Views
Replies
Total Likes
Sorry, it is an issue report
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Thanks so much for your help, I really appreciate it! :) Have a great weekend!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies