JQL User name Display - shows user keys

[Rob Lenihan]

Hi

How do I get Jira to display the Users name instead of the user key in my JQL filter?  For example this query displays like this:

assignee in (5ce1f11483de300fe5d52d49, 5d23d5728b90870c0e828b8e, 712020:01f78bfe-ddb5-44b0-ba4a-d7d681884907, 712020:980719c2-6edc-4567-bffd-d2bd7d7bbb26, 5b70f23fb70b2a06b0fb1ea8, 557058:976e3988-9744-4b5f-a168-803d92e07955, 5b6a4f9587bc6529f8ba8216, 5d3788633eb3ec0c892cb426, 5acbe792aa802f2a797a164e, 557058:2887c9c3-6181-4e02-a400-5e4895b0e3ea, 712020:2eda64ce-a261-42fe-9fb3-31c25a498414, ) and status != Closed AND status != Done

I cant tell which users this applies to.

Rob

[Ollie Guan]

Hi @Rob Lenihan ,

Currently, it is not possible for JQL to fetch usernames or emails from the database.

https://confluence.atlassian.com/jirasoftwarecloud/gdpr-changes-to-usernames-in-jira-cloud-967319102.html

https://support.atlassian.com/cloud-automation/docs/convert-usernames-to-account-ids/

https://jira.atlassian.com/browse/JRACLOUD-72062

[Rob Lenihan]

ah ok.  That's pretty average.

How can I tell who my filter applies to?

[Sayed Bares [ServiceRocket]]

@Rob Lenihan you can try the following URL for each account id:

• https://<site-name>.atlassian.net/people/<account-id>
• Example: https://<site-name>.atlassian.net/people/5ce1f11483de300fe5d52d49

This way you will see the profile of the person to whom the filter applies to!

[Ollie Guan]

Btw, there are many workarounds, such as

1. Rename the filter to add the assignee's name

2. Use a two-dimensional table in the Dashboard to display the name easily

3. Use Group query instead of UserID