How to find the committed points for currents sprint using PostgreSQL?

Asam_atis4w

For example,  when the sprint started(sprint starting date) if there were 15 issues assigned to the sprint, I need to fetch those committed issues and related story points, any issues added to the sprint later(after sprint start date) can be ignored. is there nay way to find it out in PostgreSQL?

Nic Brough -Adaptavist-

Yes, but it is not the right way to do it, simply call "opensprints()" with the REST API.

If you try to do this in SQL, you're going to need to have to think about the current sprint, how the issues in it are identified within it, and how to read the story points from them.  There's 6 joins in there and that's just minimum you need! 

Don't touch an Atlassian database, it's the worst way to do any reporting.