Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to query SQL by the same number of records issue from JQL

I want to using query statement from SQL to getting all of record about issue in database with condition that the number of result must be the same with JQL. Anyone can help me?

Requirement: Getting all of issue that belong to one project and sprint

2 answers

0 votes

Welcome to the Atlassian Community!

Seriously, don't bother.  The Jira database is not remotely designed for any form of reporting, it is a data store.

You are wasting your time trying to use SQL to report on your Jira data.  The best case is that you'll get an inaccurate report.  The worst case is that you'll take your server down with a hideously non-performant slab of complex SQL.

0 votes

It's not that difficult and would take 3 tables and 2 where conditions, question is, why do you think you want to get this from the database, when you can already get it from Jira? Not to be the annoying guy, but from what I came across almost every time there is no need to stick fingers in DB, it's not the meant way to do reports or data collection, and if you're not already familiar with the structure, it will be rather tedious for you to expand on it any further.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

Watch 4 Confluence apps compete for Best App Demo in September's Appy Hours

Calling all collaborators! Appy Hours on the Atlassian Community is a monthly event where 4 Partner and app vendor presenters go head-to-head with 5-minute demos for the title of Best App Demo. I...

584 views 0 13
Read article

Atlassian Community Events