How do I compare two revisions in Crucible?

Question

I'm trying to create a search between two revision numbers in a Subversion repository in Fisheye.  Basically, the equivalent of running something like:

svn log -r 12:15

I looked at the documentation for EyeQL, but there's no mentinon of revision numbers - it seems to suggest you can only compare tags.

Is that right, or is there some other way to achieve the above?

Richard Cross · Answer

Well, this is expressing individual changesets rather than a range.  If I want to show all the revisions from version 100 to 200, that expression is going to get rather messy.

I think I will be be better off using the Subversion command line as I described above in my original post.

Felipe Kraemer · Answer

Hi @Richard Cross,

According to the EyeQL reference guide you can show a range of revisions with a query like the following:

select revisions
where csid = 12 or csid = 13 or csid = 14 or csid = 15
order by date desc
return path, revision, author, date, csid, comment

For instance, CSID in the query above means "ChangeSet ID".

Hopefully this helps!