How to list all projects in a specific Project Category
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 on p.id=n.source_node_id 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.
This is tested using PostgreSQL. Please modify it according to the needs of your database.