search issues for specific user

[Frank probeermaand]

*newbie alert* surely I'm not the first person to ask this question, but I couldn't find the answer.

as a Jira Administrator I want to find all issues that are assigned to a specific person. when I use assignee = person123 I only see his issues for projects of which I am also a member. what is the query when I want to see that user's issues for all projects?

[Sreenivasaraju P · Accepted solution]

Yes. You are right. assignee = person123 will return the requests, where you have permission to view. You can't see the requests where you don't have the permission. 

Option 1: You have to enable permission for yourself for all the projects.

Option 2: You can extract from DB

[Nic Brough -Adaptavist-]

Please don't use option 2 - the database is not designed or built for reporting and that way lies madness.

[Frank probeermaand]

I was already afraid that these were the only options.

Thanks nevertheless.