How can I report on Projects by their Category?

[Nikita Diepenhorst]

The way my insurance organization is using Jira is to create a Project and define its Project Category based on the line of business its work is oriented around (ie; earthquake, wind, fire, etc). However, when I go to create a Filter to report off of this to see how many Projects we currently have underway for certain lines, 1) the Project's Category does not display as a column and 2) the Filters only apply to Issues, not Projects. So I am left with a list of Issues that I can filter by Project Name, but the Category column in the Filters page applies to the Issues, not the Project. If I were to create a separate Custom Field for Project Category, that would mean tracking manually on each and every Issue the Project Category.

I can obviously filter the Projects page by Category and see there what is currently out there, but there is no way to export this list from there to do further reporting outside of Jira that I have found. 

Is there another place in Jira to report off of the assigned Project Category? Or am I asking something of Jira that it is not built to do and should look for another way to utilize it?

[Edwin Chan · Accepted solution]

The property key I was looking for is 'jira.avatar.default.id'. Unfortunately, it will not be picked up from jira-application.properties. So I had to do it through the database instead:

UPDATE propertystring
SET propertyvalue = '10001'
WHERE ID = (SELECT ID FROM propertyentry WHERE PROPERTY_KEY = 'jira.avatar.default.id')

Replace 10001 with the project avatar ID that can be found in the avatar table.

[Nic Brough -Adaptavist-]

We build the WAR for our install, so I cheated and over-rode it by sticking our default logo over the top of the default

[Jo-Anne MacLeod]

I don't believe that this is possible at this time, although it would be a nice feature to have the the jira-application.properties file.