The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

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 Champions.
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
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 Champions.
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
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events