Seeing all your projects at once organized by category

[R Raphael]

Hi,

Newbie question:

Can someone tell me what's the best way to get a birdseye view of all your projects at once organized by category?

(-it would also be ideal if it somehow highlighted most pressing items for each, if such is possible??)

Thanks for any thoughts on this!!

cheers,

Raphael

[Michel Neeser · Accepted solution]

Hi @R Raphael and welcome!

You can filter by project category using JQL, as described here. If you want to find the most pressing items, you can order the results with JQL accordingly. Hope this helps.

[R Raphael]

thanks, Michel!

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @R Raphael

welcome to the community! 

This is a tricky one.

You are probably aware of the All projects view at https://<your-jira-site>.atlassian.net/jira/projects? This would list all projects and also show their project category, however doesn't tell you anything about the projects' issues.

The only other thing that I can think of is to approach it from the relevant issues - what you call the most pressing items - and then group these issues by project category and project.

To do so, we first need to clarify how you define these most pressing items. Could you come up with a JQL clause that selects these items, like Priority = "Highest"? If that's not possible, it's going to get tricky, since JQL doesn't have a LIMIT clause or similar.

Assuming that you are able to query the most pressing items, it's then a matter of presenting them organised by project and project category. You should be able to group your issues using a ORDER BY category, project clause - e.g., with a JQL query like Priority = "Highest" ORDER BY category, project - but this won't give you a great birdseye view either.

As an app developer, I'm naturally drawn towards the Atlassian Marketplace, and specifically the app that my team and I are working on, JXL for Jira. Assuming that you are able to query the most pressing items with some JQL query, you could use JXL's grouping capabilities to create a view like the following in just a couple of clicks:

Is this roughly what you had in mind?

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for issue grouping by any issue field(s), (configurable) issue hierarchies, sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[R Raphael]

Hannes,
Thanks for your thoughtful response.  Sounds like a good solution.  I will check out.  I am former CS instructor (inc. Python) but am not a programmer:  will need to get comfort with JQL clause .

thanks!

Raphael