is there a way how to create a report that will show projects by project categories ?

[Elena Moussikaev]

is there a way how to create a report that will show projects by project categories ?

[Rachel Wright]

Hi Elena,

If you have JIRA Server, you can get this information from the database. Here's a MySQL query to get you started:

SELECT p.pkey, p.pname, pc.cname AS "category" FROM  project p, projectcategory pc, nodeassociation na WHERE  na.source_node_entity = 'Project' AND  na.sink_node_entity = 'ProjectCategory' AND  na.source_node_id = p.id AND pc.id = na.sink_node_id

NOTE:  Uncategorized projects will not be returned.

Hope this helps!

Rachel Wright