JQL - Show only projects where I am a assignee

Question

Morning folks,

I am a portfolio project manager and have a couple of projects I need to supervise.

Each project has different team members, but I have tasks in each of the projects.

What I need is a board (a filter), where I can see all projects and all tasks (open, in progress, done) for all assignees.

I am struggling with the JQL code (newbie to JIRA). IT proposed using "projects in myProjects()", but this is showing some weird projects I never heard of.

Maybe there is a simple solution I am not yet familiar with.

Thanks,

Hauke

Nic Brough -Adaptavist- · Answer

Welcome to the Community!

JQL searches for issues, not projects, so you can't do this.  "My projects" just means "projects you have access to", not "projects that contain issues where I am the assignee"

You can, of course, search for issues where you are the assignee, but you may have projects where you do not (yet) have any, so you'd miss them.

You will need to generate the list of projects you are actually interested in manually.  A good start might be a saved filter for "assigned to me" (or "assigned to me or people in my team"), which you display in a dashboard gadget like "issue statistics", which lets you group by a field to get simple comparitive statistics.  Selecting "project" would give you a list of all the projects you have assigned issues in, alongside the count of them.  Probably a good basis for starting your project list.

Hauke Stricker · Answer

Hi, yes, more or less, but adding projects manually is not targetful in this case.

Ashu Tyagi · Answer

@Hauke Stricker  have you tried a query project in (project1,project2,project3...)  and then you can arrange the columns in jira issue navigator to see required results or save this query and use it in pie chart and select the Status or assignee as an data point to report on