How to query Project completion in Big picture
In the Big picture, I can see the status column shows % of To Do, In Progress, and Done as one of the columns when seeing Initiative, Program and Project.
I have a requirement to fetch these values using SQL from the underlying Oracle database (am Jira server version).
I know bp tables start with AO but I can't find the right table that shows these numbers. not it could be calculated on the fly in which case can someone share the SQL which matches the results that are shown on the big pic?
See the pic below. Plus i see status as In progress, done, To do at project, initiative level that also I need to find from SQL. IN short what is displayed on bigp main screen for all projects columns i need sql
