jiraatlassian-fisheyeatlassian-crucibleeyeql

Get commits without review


I have a list of JIRA issues that have one or many commits:

...

where n,m,y >= 1

Using Crucible I'm trying to create reviews for J1,..., Jk (or for c11, ..., cky - because it's ok if the number of Crucible reviews is bigger than the number of JIRA issues).

In order to achieve this, I want to see using EyeQL which are the commits without a created review (not necessarily closed).

If I run the following query:

select ...
from ...
where
...
and not reviewed 
group by ...
return ...

it returns only the commits that don't have a "complete" review. But I want to see only the commits that don't have a "review" (regardless of its state).

How can I achieve this behavior?

I want something like and doesn't have any created review instead of and not reviewed.


Solution

  • Using the clause not in any review should work, i.e.:

    select revisions from dir "/" where (not in any review) order by date  desc  group by changeset return path, revision, author, date, csid
    

    See the EyeQL reference for the full grammar description with examples.