nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL to Retrieve All Projects for Current User

Matt Richards_q2q9cg

I'm working with the JQL below to retrieve issues assigned to current user that are in open sprints and have the "To Do" status across all their projects. The statement below has the current user's two active projects hard coded in ("Product" and "QA"). I am hoping to make this more dynamic so that I can share it across users.

How can I reference the current user's complete list of projects using JQL to replace these hard coded project names?

Any help is appreciated!

project IN (Product, QA) AND assignee = currentUser() AND status = "To Do" AND sprint in openSprints() ORDER BY Rank

Accepted answers

Trudy P Claspill

Hello @Matt Richards

The search screen is for finding issues, not projects. There is no UI feature to get you an explicit list of only the projects where a user has assigned issues.

If you wanted to reduce the issue search list so that you could see a concise list of the projects rather than each issue then you could do something like use the Two Dimensional Filter Statistics gadget on a Jira Dashboard to organize the issue search results into a table of issue counts across Projects and issue statuses.

Screen Shot 2023-05-16 at 3.13.01 PM.png

All comments

Matt Richards_q2q9cg

Having written this I realize now that if I am explicitly looking for ALL projects I could probably just remove this:

project IN (Product, Matt) AND

To yield:

assignee = currentUser() AND status = "To Do" AND sprint in openSprints() ORDER BY Rank

So... that works, but it would still be useful to know if it is possible to retrieve the complete list of projects for a user.

Trudy P Claspill

Hello @Matt Richards

The search screen is for finding issues, not projects. There is no UI feature to get you an explicit list of only the projects where a user has assigned issues.

Screen Shot 2023-05-16 at 3.13.01 PM.png

Matt Richards_q2q9cg

Thanks for your reply, Trudy. I am not looking for a UI feature. As I mentioned, I am working with JQL.

Trudy P Claspill

Perhaps I am not understanding your question.

There is no JQL function for retrieving just a list of projects. JQL is designed for retrieving issues.

As you discovered, you don't need to have the "project in" criteria in the JQL statement. Omitting it will get all the issues assigned to the currentUser() across all projects.

Are you still looking for a way to get a list of project based on a criteria related to currentUser()?

Matt Richards_q2q9cg

If I cannot use JQL to retrieve a list of projects, then no.

I do have a question related to that 2d issue gadget you showed. I created one of my own and I'm seeing two "To Do" status columns, one from each of the two projects.

By chance have you see this before, or might you have an idea as to why it happened? We have not customized our statuses at all. The projects are basically bare bones.

Thanks for your thoughts and responsiveness.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud