A single user is getting their unique ID added after their name

A single user is getting an ID, like an SSID added after their name. I have checked their user in Jira and theres no ID there. Also they are the only person with that name.

Any ideas how I can stop this ID appearing?

Hi @Terry86
Welcome to the eazyBI community!
I recommend performing a full data reimport in this case - (described here - Data from Jira).
Please let us know if you still face the same problem.

Best wishes,
Elita from support@eazybi.com

Hey @Elita.Kalane

I’ve done a full reimport but it hasn’t fixed it.


Hello @Terry86
Thank you for following up with me.

The user key generally is added to the member name when there are multiple members with the same member display name but different member keys.

The solution is to update issue changelog entries so that references to old assignees are updated to their new IDs.

You might add the following JavaScript code to the Jira data source additional settings - Custom JavaScript code.

The code might be as follows:
Please update the oldusername, newvalue and newstring fields with the data of your users.

function consolidateAssignees ( assigneeID , assigneeString) {
  // consolidate assignees in change entries
  assigneeChange = {
  "oldusername1": { newvalue: "5b01XXXXXXXXXXXXXXXXXXXX" , newstring: "<Display name1>"}, // update and add for each old ID and value the current Priorirty IDs
  "oldusername2": { newvalue: "5b01YYYYYYYYYYYYYYYYYYYY" , newstring: "<Display name2>"},
//... additional entries as required
  "oldusernameN": { newvalue: "ZZZZZZZZZZZZZZZZZZZZZZZZ" , newstring: "<Display nameN>"}  
  var assignee = [] ;
  if (newAssignee = assigneeChange[assigneeID]) {
  assignee.id = newAssignee.newvalue;
  assignee.string = newAssignee.newstring;
  else {
  assignee.id = assigneeID;
  assignee.string = assigneeString;
  return assignee

  if (issue.changelog && issue.changelog.histories && issue.changelog.histories.length > 0) {
  var histories = issue.changelog.histories;
  for (var i = 0; i < histories.length; i++) {
  var history = histories[I];
  if (history.items && history.items.length > 0) {
  for (var n = 0; n < history.items.length; n++) {
  var item = history.items[n];
  if (item.field == 'assignee') {
  // assignee change to:
  history.items[n].to = consolidateAssignees(item.to).id
  history.items[n].from = consolidateAssignees(item.from).id
  } } } }

After adding the script you need to empty the data cube to clear old dimension member entries and then perform full import to repopulate data.

However, this would not help if you have multiple active users with the same display name.

Kind regards,

Elita from support@eazybi.com