Hi @Anthony Novo ,
here your SQL query :
SELECT ji.*
FROM nodeassociation na
INNER JOIN projectcategory pc ON pc.ID=na.SINK_NODE_ID
INNER JOIN project p ON (na.SOURCE_NODE_ID=p.ID)
INNER JOIN jiraissue ji ON (ji.PROJECT=p.ID)
WHERE na.ASSOCIATION_TYPE='ProjectCategory' AND pc.cname='PROJECT_CATEGORY_NAME_HERE';
Hope this helps,
Fabio
@Anthony Novo did this resolve your issue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In SQL the project category association is saved in the nodeassociation table (ASSOCIATION_TYPE='ProjectCategory').
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In JQL (not SQL) you can write "category=MyCat" to select all issues in projects with category MyCat.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes thanks, but i'am very interesting to the sql :D
I want the same display of the JQL but directly in the database with SQL.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.