Hello All, I need SQL for the JQL Query

[MEHRAJ FARHEEN]

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-]

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.

[MEHRAJ FARHEEN]

Can you please provide more details about REST CALL?

[Nic Brough -Adaptavist-]

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

[Bastian Stehmann]

Hi @MEHRAJ FARHEEN,

welcome to the community.

Why don't you use Jira to get the live data anytime?

I do not recommend creating reports based on SQL.

[MEHRAJ FARHEEN]

Thank you @Bastian Stehmann, we need to send this schedle report to top management daily ith some calculations and analysis.

Using report is the only option for me.