JQL view tasks assigned to a User across ALL projects

[sadams]

Unable to find an answer via Google or the community posts here.

I have a JQL query that searches multiple projects for all tasks assigned to a specific user.

What I'm wanting is an "all" selector a.k.a. * for SQL, that I can use in place of specifying certain projects and just select all my projects. Is there a keyword or a way to do this?

Here's an example, replace ABC and XYZ with some kind of ALL (we have a lot of projects)

project in (ABC, XYZ) AND issuetype in (standardIssueTypes(), subTaskIssueTypes()) AND "QA Assignee[User Picker (single user)]" order by created DESC

Thanks for your help and time!

[Darryl Lee · Accepted solution]

Hi @sadams - if you simply omit the project in (ABC, XYZ) clause, it will search across all projects.

[sadams]

Hi @Darryl Lee you're absolutely right, didn't even think of trying that, thanks for the quick response, that worked for my existing query. Thanks!