Query to fetch the project based on the project category

[Sakthi Balaji]

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

Thanks in Advance

[Boris Georgiev _Appfire_ · Accepted solution]

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'

[Sakthi Balaji]

Thanks Boris that query worked for me .