How to list all projects in a specific Project Category

Still need help?

The Atlassian Community is here for you.

Ask the community


To list all projects that are configured under a specific Project Category through SQL query to the database. 


Run the following query:

select p.pname, p.pkey 
	from project p join nodeassociation n 
	where n.sink_node_entity='ProjectCategory' and
	n.sink_node_id=(select id from projectcategory where cname='Test') 
order by p.pname; 
  • Replace 'Test' with the project category name that you wish to list.

(info) This is tested using PostgreSQL. Please modify it according to the needs of your database.

Last modified on Apr 5, 2021

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.