Find jira issues with pending bitbucket PR apoprovals

Question

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

Wade Hephner · Answer

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

Tuncay Senturk _Snapbytes_ · Answer

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 · Answer

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