Find jira issues with pending bitbucket PR apoprovals

[Wade Hephner]

Hello, I have been trying to figure out if it is possible to query jira for issues that have open pull requests and still need approvals on that pull request.

I have been using 
issue.property[development].openprs>0
to get issues with open PR's but I have not been able to figure out a way to see if there are approvals on the PR's.

Is this possible or has anyone done this?

Version 7.2 of Jira and Version 4.14.4 of bitbucket

thanks,
Wade

[Tuncay Senturk]

See this post

[Wade Hephner]

Thanks Tuncay, I have tried those suggestions and found that issue.property[development].reviews does not work with bitbucket. I believe it is looking for fisheye/crucible reviews and not bitbucket approvals.

Thanks,
Wade

[Tuncay Senturk]

Yes, they are.

How about J-Tricks plugin? It has some sort of JQL functions as well, I am not sure whether it requires crucible/fisheye though.

https://www.j-tricks.com/jqlt-development-functions.html 

[Wade Hephner]

Thanks for the recommendation. I looked through the documentation and there are no functions for getting development data.