Which database table build status for a pull request is stored

[ejo]

Not looking for API here. Need the exact query for retrieving the build status for pull requests 

[Ana Retamal]

Hi @ejothanks for reaching out.

The Atlassian team does not cover development questions or requests, as you can see in our support offerings page. 

If none of our users here offer the help you're looking for, you can also try posting your question in our Developer Community.

Hope that helps!

Ana  

[ejo]

Thanks Ana for the response. I have figured out my self.

[Ana Retamal]

Hi Ejo, glad you could figure it out.

For the future, please consider sharing your findings with the rest of the Community so you can also be helpful for someone else :) 

Kind regards,

Ana

[ejo]

Sure Ana.

I have inspected the below tables to get the required info.

sta_pull_request
bb_pr
"AO_CFE8FA_BUILD_STATUS"