Search assignable users by a list of email addresses

[Jian GU]

Hello, 

With a list of email addresses, we want to get corresponding Jira users.

Right now, I've 2 ideas : 

• direct approach. Search users with emails. For only one user, it works, but I don't know how to pass all the emails in query, and make it return the right users.
• Retrieve all users with projectKeys, then filter users by comparing email addresses. But values for the field "emailAddress" of returned users are empty.

Maybe I missed something. Any suggestions ?

Thanks

[Jack Brickey · Accepted solution]

you can use the following structure...

assignee in ("fred.flinstone@caveman.com", "barney.rubble@caveman.com")

basically use the "in" operator and enclose emails in "".

[Bill Sheboy]

Hi @Jian GU -- Welcome to the Atlassian Community!

Yes, and...to Jack's suggestion:

That approach will get you any issues which have assigned users from your list.  If you instead want the users only (without issues), you cannot do that with a JQL search as that only checks in issues.

To just get the user list only, please work with your site admin to have them help by exporting the users list from admin functions and then searching the results.

Best regards,
Bill

[Jian GU]

Thanks @Jack Brickey , the jql works fine.

However, as Bill mentionned, search with jql returns issues with assignees. In order to get a "pure" list of users, it's necessary to loop a large amount of issues. Plus, for a new user, who has never been assigned to an issue, we can not get him ...

It's pity that, user search does not take jql :(

[Jian GU]

Hello @Bill Sheboy , thanks !

You're right, jql search returns issues. We may get users, but not perfect.

We want a system which requires as little "human action" as possible. In any case, I'll contact my site admin.

Regards, 

Jian