How to list out project category and its projects linked to the project category?

[Mani Chellamuthu]

I am developing a gadget with REST API to list our all project categories with their linked projects. In schema, there is no association between Project and ProjectCategory. How do I get list project categories and their projects?

[Mani Chellamuthu · Accepted solution]

I found a way to retrieve the desired results. We have to use nodeassociation table where associations are stored. 
The relation between Project and ProjectCategory is defined in nodeassociation.

The SQL below,

select pc.id,pc.cname, p.id, p.pname from nodeassociation na, projectcategory pc, project p
where na.sink_node_id=pc.id and
na.source_node_id=p.id and
na.sink_node_entity='ProjectCategory' and
na.association_type='ProjectCategory'
order by pc.cname;

[c]

Is it possible to run that query through the REST API?

[c]

With JIRA 5.2, it is not possible to fetch the project category via the REST API:

JRA-30001: REST method to retrieve the project category