JQL view tasks assigned to a User across ALL projects

sadams December 5, 2022

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!

1 answer

1 accepted

6 votes
Answer accepted
Darryl Lee
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 5, 2022

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

sadams December 5, 2022

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!

Like shruti gupta likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events