Sql query to get the progress status of the Issue. Actual and planned progress fileds in the sql dat

[Erfan Mallampalle Syed]

Hi, 

I have a requirement to get planned and actual progress on issue from sql db of JIRA.

Can someone help me with the fields.

Best Regards,

Erfan

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

Your "requirement" is wrong.  You don't want to use the database to get this data, it is the worst possible way you can report on Jira issues.  You would need to write hideously complex SQL that has the potential to 

You have not defined what you mean by planned and actual progress either, so we can't answer the question, irrespective of the method you use.

[Erfan Mallampalle Syed]

Thanks for your reply :)

I have a requirement to prepare a report from JIRA in powerbi. But I am not allowed to use any connector. I just have Jira sql db access. 

The requirement is, I want to get the Actual and planned progress of the issues created. I have to report which issues are delayed, which are on track and which are slightly delayed.

[Nic Brough -Adaptavist-]

Again, you need to define what you mean by planned and actual progress.

When you know that, you can run searches over REST to return the data you are looking for.