JQL is showing user IDs instead of names. Why?

[Renwick Oden]

All of my saved JQLs are showing user IDs instead of user names, making it impossible to edit.

EX: reporter in (557058:77186584-18c0-4f0f-8fa3-f059ec46db9b, 557058:29c34501-af90-4d81-b215-13a753775ced, 557058:81297732-1f4e-4812-b7c9-e083e6237e7c, 557058:e6427447-6ac3-4b00-80b0-fa3f47fb26aga, 557058:433c22ba-38dc-400d-8e6f-501387fd602a)

1) Why was it decided that this is an improvement to the user experience?

2) The following page explains that there should be a link to resolve user names, but there is not.  How do I get the link to show?

https://support.atlassian.com/jira-software-cloud/docs/convert-usernames-to-user-account-i-ds

[Suvendu Banik · Accepted solution]

WORKAROUND
reporter in ("exact name 1","john doe")

[Renwick Oden]

^^^ This Guy! ^^^

GENIUS!!!!!

Don't ruin it for us Atlassian!!!!

[David Su]

Seriously

[Martin Flury]

if you take over the Atlassians suggestion of the user, while typing its name, it will get replaced by the user ID. You have to write the full name in-between double quotes, that way the user name wont get replaced by the user ID.

[Dean Zimmermann]

This is a huge pain for legacy queries that had a lot of names replaced with ID#s.

While I understand from comments above this was supposedly done to comply with GDPR, once someone  unauthorized is inside your Jira instance, you've got a lot bigger issues than GDPR - and of course still a problem with GDPR.

Since it's obvious who is included and excluded from the query by temporarily removing ID #s when specifying people ultimately you can still figure out the names.  Further, the ID # itself uniquely identifies someone so that is just one more piece of PII being leaked.

When this change was made, it was within Jira's power to update the legacy queries to include "name" rather than just an unquoted name in existing queries and notify admins they would need to change behavior to comply with GDPR. 

In short, the GDPR reasoning doesn't seem to hold much water.

[Dennis Lochman]

Ridiculous reasoning!

[Zoryana Bohutska _SaaSJet_]

Hi @Jorge Eduardo Olmos 

You can consider a third-party solution like Dynamic Filter: JQL Replacer. It allows creating filters for the assignee list without JQL but using custom Smart Fields for Dynamic Filter. So at any time, you can view assignee names of created Smart Field.

I hope it will help.

Regards

[Soumya Navaneeth]

Right now seems like there is no way to see the User names in JQL. 

But one way to check User ID & name mapping is to Export the Users from User Management.

The Generated Excel will have the ID & Names.

[Jorge Eduardo Olmos]

There is no way we can work wih JQL like this!!!!!!!

[Rajesh Lukson]

This doesn't make any sense. No way to edit the queries with assignee, reporter, etc..

I think there should be better way to deal with it.

[Michael Auton]

Ive just came across the same thing... for an old query. I mean how am I meant to work with see screenshot ??? Is there any way to decipher this ?

[Dennis Lochman]

Yeah, it's quite cumbersome. I have a lot of older query's that have users that are not with the company any longer, and new users that are not yet in the query's. 

Another annoying thing is that some of my users have moved on to different projects and tickets they have created since moving, are still coming up in the results. 

Unfortunately, the only way we're left with to clean up our query's is to empty out all the users and add all the valid ones back in. 

I myself have dozens that I have to fix. 

Good luck!

[Daniel Turczanski - JQL Search Extensions]

Can't it be solved by referring to a group instead of to each user separately? Clearly those users have something in common and they could be a part of a group.

[David Helfrich]

Sometimes a non-admin will want to run a filter to find issues important to them despite not having the ability to create or manage groups.  If we're entering a list of names, it would be nice to continue to see the list of names, especially when someone on a team may create a filter and share with their teammates, they can't really see what the filter is doing this way.

[Martin Flury]

@David Helfrich write the user name in-between double quotes (don't klick on the, by the system suggested, user name) and the user name won't get replaced by the user ID.
Example: Assignee in ("name1", "name2")

[Bill Sheboy]

Hi!  Those are the only ones that I know about.  I have found that when I type in the actual user name in JQL, it will resolve to the ID, but there is no way to have that remain the user name once converted.

[Renwick Oden]

Hey @William Sheboy 

That is unfortunately that this change has made the management and debugging of JQL unmanageable.

I read that there should be a link on the query page that exposes the name, but the link is not there.

Are there any work arounds? 

Thanks!