Where the category of the project is stored in jira?

mihan ayeshana July 15, 2012

I go through the jira 4.3.3 database (jira433) but i can't find the place where the project category is stored. Can help me to find the place category of a particular project is stored.

1 answer

0 votes
Norman Abramovitz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 15, 2012

I am assuming you really mean categories verses components. There are three tables involved.

project, projectcategory and nodeassociation

nodeassociation.sink_node_entity='ProjectCategory'
nodeassociation.source_node_id = project.id
nodeassociation.sink_node_id=projectcategory.id

mihan ayeshana July 15, 2012

But when i run

select SINK_NODE_ID from nodeassociation where SOURCE_NODE_ID =11254;

query in sql it gives

+--------------+

| SINK_NODE_ID |

+--------------+

| 10032 |

| 10043 |

| 10000 |

| 10000 |

| 10002 |

| 10050 |

| 10074 |

| 10085 |

+--------------+

But for one project there should be one category but it gives this result why is that

Norman Abramovitz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 15, 2012

The nodeassociation table contains more than just project category relationships, so you got all the associations for that id number. You need to restrict more with the sink_node_entity or at least display that field as well or you have the wrong project number.

select SINK_NODE_ID from nodeassociation where SOURCE_NODE_ID =11254
and nodeassociation.sink_node_entity='ProjectCategory'

Suggest an answer

Log in or Sign up to answer