How to fetch data from Jira?

[Bunty]

Hello Team,

Is there any provision to run any kind JQL or SQL queries to fetch and see fewer records from Jira for data validation. I was going through the documentation and came across some queries that people were running but I had no clue where they were executing it

https://developer.atlassian.com/server/jira/platform/database-schema/

Any Advice?

Thanks,

Manikanta

[Nic Brough -Adaptavist-]

I'd strongly recommend staying well away from the database.

It is not designed for reporting or analysis, it's a datastore only.  (I would tend to argue it's not even "designed" to be that, it's more grown up like that, like a fungus).  It's a nightmare to work out queries for what most people would think of as "easy".  To "get" one issue you start at around 15 joins and can easily end up needing 50+, some 2 or 3 more tables deep.

I have yet to find anyone with a moderate sized or larger Jira and database access who has not suffered problems with performance until they stopped reporting off the database (both in Jira and the reporting).

More to the point, I've yet to see anyone not have massive problems understanding the database well enough to give accurate reports.

Please, use the REST API, or one of the Apps that does reporting and understands the database for you (I usually lean towards EazyBI and Dataplane)

[Thomas Deiler]

Dear @Nic Brough -Adaptavist-,

Manikanta must have read the notice in the article that was referenced. Probably there is a real reason for doing this. If the DB access ist at least read-only, nothing will be harmed.

But I am still strongly interested in the "why". And I totally agree to your points.

So long

Thomas

[Bunty]

Hi @Thomas Deiler @Nic Brough -Adaptavist-

Yes, you are correct, the dB is for storing and the Rest API method is for pull the whole data. I was looking for a way to preview the data before the pull so I came to know that there’s a way to fire up queries like SQL or Jql on jira with a plugin. 

I found the below add-on to do this:

https://kintosoft.atlassian.net/wiki/spaces/SFJ/overview.

[Nic Brough -Adaptavist-]

Yeah.  Still don't.  While it's a good add-on for what it does, please, just step away from the database, it's the single worst way of looking at Jira data.

[Thomas Deiler]

Dear @Bunty,

if you can tell us what should be validated, I can probably help better.

So long

Thomas