Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL Statement: Statement to Search for 2 Assignees Returns All and Scrambles Names

Kevin Meyer
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 15, 2020

Hi,

I just wrote a simple JQL statement to pull all of the Issues assigned to two people working on 2 projects.  Two problems:

1.   As you can see from the statement, the names of the assignees were changed into what appears to be a hexadecimal rendering. 

2.   All assignees' records were returned. 

project = "Atlassian Training Project" OR project = JobSearch AND (assignee = 5fb119d5d670b8006e4e154b OR assignee = 5fa9d33462584c006b32de59)

Thoughts? 

Kevin

1 answer

3 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 15, 2020

The change is to use the unique identifier for the person you have names.

You're getting all the issues because your JQL says you want to see all issues in the atlassian training project, plus those in the Jobsearch project assigned to your two assignees.

I think what you really want is 

(project = "Atlassian Training Project" OR project = JobSearch) AND (assignee = 5fb119d5d670b8006e4e154b OR assignee = 5fa9d33462584c006b32de59)

To get only issues assigned to those people in the two projects.

Jack Brickey
Community Champion
November 15, 2020

and regarding the names changing to hexadecimal, these unique numbers are there to protect the user's names. it is part of Atlassian's move to adhere to GDPR. While you can enter the user name it is converted for the purpose of output results so that if printed, emails, copy/pasted, etc. the names are protected.

Like # people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events