Hello All, I need SQL for the JQL Query

Question

I'm trying to mae report on JIRAdatabse for the belo JQL

project = idm and "Demand Type" = CR and ((sprint in (9,6)) or (sprint is empty and status not in (Live,Cancelled))

I have been trying to work on it fo sometime now. Please help. The key issue is I'm unable to track the number of CRs thats gone live wiithin a sprint.

Im woking o SAP BO webi report, so i can getch Live data anytime.

Please help.

Nic Brough -Adaptavist- · Answer

Start at https://developer.atlassian.com/server/jira/platform/rest-apis/

MEHRAJ FARHEEN · Answer

Can you please provide more details about REST CALL?

Nic Brough -Adaptavist- · Answer

There are somewhere between 12 and 26 highly inefficient joins you would need to make in to replicate that JQL in SQL.  Probably towards the higher end if I remember the Software data correctly.

Please, don't.  The Jira database is not intended for reporting like this and SQL is the worst possible way to report on Jira data.

Try running the SQL over a simple REST call instead.  It will work fine, faster, will rarely (if ever) need any updates and re-testing on upgrade, and won't put unnecessary load on your database.