USER ID

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.

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'

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…