This query allow you to convert USER ID into text format
You can find USER ID column in numerous tables that contain personal User data as Assignee, Reporter etc. According to the GDPR (General Data Protection Regulation) all this data is encoded.
| Code Block | ||||
|---|---|---|---|---|
| ||||
select LINKISSUE(i.`KEY`) as `ISSUE`, x.DISPLAYNAME as `Assignee`, y.DISPLAYNAME as `Reporter` from ISSUE i join USER x on i.ASSIGNEEID=x.ACCOUNTID join USER y on i.REPORTERID=y.ACCOUNTID where i.JQL='project=PROJECTNAME' |
...
After…
...
| Info |
|---|
PROJECTNAME* is a tentative name in our queries. Please note that in your JQLs you need to use real names of your Projects, Users, Sprints ,etc. |
Before…
...
After…
...