SQL query that returns a list of issues for a caterogie

[Anthony Novo]

Hi,

I am looking for a query that returns all issues present from all projects in a category.

Thanks

[Fabio Racobaldo _Catworkx_ · Accepted solution]

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

[Dan Breyen]

@Anthony Novo did this resolve your issue?

[Barry Kosovski]

As a new year begins, traders https://westafricatradehub.com/crypto/when-is-the-next-bull-run-in-crypto/ are asking when the next major crypto bull run will arrive. Based on prior post-halving cycles and today’s evolving market structure — including growing ETF flows, clearer regulation, and emerging themes like AI and tokenized real-world assets — 2026 appears a plausible window for a strong upswing in Bitcoin, Ethereum, and select altcoins. If liquidity improves and institutional demand continues to absorb supply, the foundation for a meaningful advance could be firmly set.

[Henning Tietgens]

In SQL the project category association is saved in the nodeassociation table (ASSOCIATION_TYPE='ProjectCategory').

[Henning Tietgens]

In JQL (not SQL) you can write "category=MyCat" to select all issues in projects with category MyCat.

[Anthony Novo]

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.