how can i query against the nodeassociation table

[Jobin Kuruvilla [Adaptavist]]

The nodeassociation table holds the details about versions, components etc. Following is a query that works in the latest JIRA version:

SELECT concat(pr.pkey, '-',ji.issuenum) as issuekey, comp.cname
        FROM nodeassociation na, component comp, jiraissue ji, project pr
        WHERE comp.id = na.sink_node_id
        AND ji.id = na.source_node_id
        AND na.association_type = 'IssueComponent'
        AND pr.pkey='DEMO'
        AND ji.issuenum='123';

As you can see, it gets you details about components of an issue with key DEMO-123. You can similarly get version details as well.

PS: This query was taken from my book - JIRA Development Cookbook - Third Edition. You will find similar examples in Chapter 10 but hope this helps.

[Nic Brough -Adaptavist-]

Don't.  Use the API instead, nodeassociation is one of many tables that is not remotely suitable for querying.

What is the question you are trying to answer here?