How to find open reviews or unreviewed commits on tickets

[Paul Edison]

Hi all,

Is there a way to query for tickets that have:

• an ongoing review that is not closed
• code commits that not have been reviewed

with a JQL query in Jira?

Using Jira 7.13 with crucible (for SVN reviews) / bit-bucket (for git).