occurrences of JIRAUSERxxxxx in projectroleactor table

[Herbert De Jonghe]

When drawing a table of the user roles of a certain company, I used postgresql to look it up:

SELECT
   c.display_name,p.pname
FROM
   project p, projectroleactor r, cwd_user c
WHERE
   p.id=r.pid and r.roletypeparameter=c.user_name
AND
  c.lower_email_address  ilike '%company%'
ORDER by p.pname

Normally it should yield a certain amount of users but there were too few rows.
When digging into the projectroleactor table there were about some 100 rows with JIRAUSERxxxxx:

SELECT *
FROM
  projectroleactor
WHERE
  roletypeparameter ilike '%JIRAUSER%' or roletypeparameter ilike '%company%'

50054;13660;10450;"atlassian-user-role-actor";"JIRAUSER21101"
50055;13660;10450;"atlassian-user-role-actor";"john.smith@company.com"
50059;13660;10000;"atlassian-user-role-actor";"JIRAUSER21104"
50178;11489;10000;"atlassian-user-role-actor";"JIRAUSER20002"
50272;16560;10010;"atlassian-user-role-actor";"JIRAUSER20002"
50320;16460;10030;"atlassian-user-role-actor";"JIRAUSER20001"
50382;13161;10000;"atlassian-user-role-actor";"JIRAUSER21315"
50536;13161;10000;"atlassian-user-role-actor";"JIRAUSER21321"
50542;16660;10010;"atlassian-user-role-actor";"JIRAUSER21308"
50551;16660;10010;"atlassian-user-role-actor";"JIRAUSER21304"
50559;16660;10551;"atlassian-user-role-actor";"JIRAUSER21306"

Apparently this is because of username renaming.
Can't find the link with cwd_user though.
In which table is this stored?

[Gareth Cantrell]

Hi @Herbert De Jonghe 

The APP_USER table describes the relationship between userkey and username.

[Herbert De Jonghe]

See this post.
Apparently this is because of username renaming.
Can't find the link with cwd_user though.
In which table is this stored?