nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Suvendu Banik

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

All comments

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!

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.

Dennis Lochman

Ridiculous reasoning!

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 ?

Screenshot 2020-08-20 at 23.46.54.png

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!

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.

Jorge Eduardo Olmos

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

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.

Suvendu Banik

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

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.

Renwick Oden

^^^ This Guy! ^^^

GENIUS!!!!!

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

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.

David Su_x9ugks

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.

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software