Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

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…

  • No labels