List of files needing review

Question

Is there any way to get a list of what files either have never been reviewed or have changed since their last review?  We are not yet in a point in our development cycle where we want to review every single changeset but instead want to do a baseline on our 4000 files and then do delta reviews at a future date where needed.

Does anyone out there have an easy method for doing what we need?

Thanks in advanced.

David Knipe · Accepted Answer

I think I might have figured this one out on my own.  I did an EyeQL query:

select revisions from dir "/" where not is deleted and not reviewed and (path like *.c* or path like *.h*) and is head order by date desc group by file return path, revision, author, date, reviews

This seems to do what I want.  The only thing I am unsure of is whether a file is considered "not reviewed" if has previously been reviewed but has been changed since the review.