Query to fetch the project based on the project category

Question

Need to list the project in the JIRA baed on project category, i need a DB query.

Thanks in Advance

Boris Georgiev [Appfire] · Accepted Answer

SELECT  project.id as "project id",pname as "project name", projectcategory.id as "category id",cname as "category name" FROM "NODEASSOCIATION" JOIN PROJECT on source_node_id= project.id JOIN projectcategory on sink_node_id=projectcategory.id where SINK_NODE_ENTITY='ProjectCategory'