It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
I am looking for a query that returns all issues present from all projects in a category.
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.
In SQL the project category association is saved in the nodeassociation table (ASSOCIATION_TYPE='ProjectCategory').
Still have a question?
Get fast answers from people who know.
I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs