Cenqua > Fisheye > Advanced Searching

Advanced Searching

FishEye is a search engine for your repositories. FishEye puts the history of every file in your repository at your fingertips. Use any combination of file contents, commit messages, authors, dates, branches and tags, or file paths.

• Use Quick Search to jump to a file
• Perform structured queries with the standard Search
• Write your own complex searches in EyeQL
• Get results as html, tables, or CSV
• Save search results as bookmarks or links
• Integrate repository searches into your own scripts with FishEye’s API

EyeQL Examples

For more complex searches you can use FishEye’s query language EyeQL. EyeQL is an intuitive SQL-like language that gives you the ability to craft arbitrary queries.

The following examples demonstrate the power of EyeQL to extract valuable information from your repository. The link below each query will execute that query on the demonstration instance of FishEye. Edit the queries and to see how easy, powerful and fast EyeQL is.

Find files removed on the Ant 1.5 branch:

select revisions
where modified on branch ANT_15_BRANCH and is dead
group by changeset

Show Results

As above, but just return the person and time the files were deleted:

select revisions
where modified on branch ANT_15_BRANCH and is dead
return path, author, date

Show Results

Find changes made to Ant 1.5.x after 1.5FINAL:

select revisions
where on branch ANT_15_BRANCH
and after tag ANT_MAIN_15FINAL
group by changeset

Show Results

Find changes made between Ant 1.5 and 1.5.1:

select revisions
where between tags (ANT_MAIN_15FINAL, ANT_151_FINAL]
group by changeset

Show Results

As above, but show the history of each file separately :

select revisions
where between tags (ANT_MAIN_15FINAL, ANT_151_FINAL]
group by file

Show Results] group+by+file

Find Java files that are tagged ANT_151_FINAL and are head on the ANT_15_BRANCH:

(i.e. files that haven’t changed in 1.5.x since 1.5.1)

select revisions from dir /src/main
where is head
and tagged ANT_151_FINAL
and on branch ANT_15_BRANCH
and path like *.java
group by changeset

Show Results

Changes made by conor to Ant 1.5.x since 1.5.0

select revisions
where between tags (ANT_MAIN_15FINAL, ANT_154]
and author = conor
group by changeset

Show Results