Create swimlane in project board that captures tickets assigned to a user across all projects.

[Jessica Van Sickle]

I work in a large organization.  We have 255 projects in our JIRA instance.  For the team that I manage, most of their work is logged within our own project, but tickets from other projects can be assigned to them in any of those projects at a given time.

I have a Kanban board that we work from in our primary project and the swimlanes are configured based upon Queries, which mostly include Epics for the major projects that our team is focused on.

To get a full picture of the team's bandwidth and capacity, I'd also like to have a swimlane for 'External Projects' that allows us to see all of the tickets that are assigned to each developer (filterable by our existing Quick Filters based upon assignee) across all other JIRA projects.  

If I use the JQL statement assignee = [username] I only see tickets from our project included.  It's not practical to type out 255 project names in the query and there doesn't appear to be a wildcard option available in JIRA.

Any suggestions on what a good query would be to accomplish this?

[Ravi Sagar _Sparxsys_]

Hi @Jessica Van Sickle 

Are those projects part of a few categories? Then you can use JQL like.

category in ("Client projects","Internal Projects")

However, looking at your requirements I feel you would need to create a report using some add-ons like eazyBI (there are others) instead of getting this information from your existing board. I personally eazyBI a all because it lets you create pivot type reports based on Jira data.

Another option would be to use Structure that let you organise your issues from different projects. Good thing about Structure is that you can create either bottom up (assignee > sprint > project) or top down (epic > story > sub-task) hierarchy to view your data. 

Ravi

[Jessica Van Sickle]

Hi Ravi,

We actually do have categories, but I'm not sure how to write the balance of the query to include the users.  Any suggestions?

Thanks for your help!