Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Reading Pull Request review status for Github using JQL



I'm working on seeing what is possible with JIRA Cloud Automation, and I'm currently investigating what is possible using the development issue field, in particular development[reviews]. seems to suggest that this should return any JIRA issues that are pending pull request approval ... 

development[reviews].open > 0 order by created DESC

... but this results in no issues being returned, even when the JIRA Pull Request screen for a given issue shows that there is an Open pull request in Github, and it has no approvals (there's no face with checkmark in the Reviewer column, in fact, no face at all.)


The built-in automation has events for Pull request created, pull request declined, and pull request merged.  But I'm trying to build something that fires when an issue transitions, but the pull request approval is in the wrong state.

Any suggestions?  Googling just brought me to various versions of the linked document above. 


Thanks in advance!

1 answer

1 vote
Andy Heinzer Atlassian Team Dec 17, 2021

Hi Jason,

I understand that you are trying to find issues in Jira that have linked reviews from GitHub.  However not all development information is available to Jira from all development sources equally.  We try to explain this over in View development information for an issue.  From that functionality description, only Fisheye/Crucible is viewing/creating reviews from Jira.

I believe this is why the JQL in Jira is not showing any results to your query about these reviews.

As for how to best try to work-around this, I'm not sure I have enough information to advise you here.  I gather that you want an automation trigger to be when the issue is transitioned, and you are looking for a comparison condition regarding the reviewer/approval.  But what action are you wanting to happen from the issue in Jira when this criteria is met?

Perhaps we can work through another way to have automation check for this.  My initial though was to try to look at alternative triggers here, such as the DevOps triggers, but looking through the Jira smart values - development does not appear to provide us with any smart values that directly show the reviewer info.

So perhaps instead it might be worth trying to setup Incoming webhook trigger to Jira itself (which can be really slick to setup and then have GitHub call that specific webhook URL in Jira).  This method could potentially provide Jira with the specific information from Github's side of things that you can then use within the automation comparisons and actions to effect some change on the issue in Jira, but without knowing what action are you looking to achieve here, I'm not sure how best to guide you.

I'd be interested to learn more here so that maybe we can come up with another way to try to help here.


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

517 views 1 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you