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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.