Fisheye exclude from filter

[FrankV]

Hello, Is it possible to exclude specific text from filtered commits. For ex, I want to look at all my SVN changes in fisheye, but those WITHOUT the text "automated build". i.e. this would allow me NOT to see some commits that are not done by real people.

Thanks.

[Piotr Swiecicki · Accepted solution]

Hi FrankV,

You can use EyeQL to find this. Just to explain on example, go to https://fisheye2.atlassian.com/search/mb-unit/page and run the search with this query

select revisions
   where comment matches 'tweaks'  
group by csid return count(revisions), csid, author, date, comment

Notice you get 46 results, all the commits from mb-unit repository with 'tweaks' phrase. Now repeat the search with this query:

select revisions
   where comment matches 'tweaks'  
 and not comment matches 'minor'  
group by csid return count(revisions), csid, author, date, comment

to see only 20 changesets returned - all the changesets with phrase 'minor' in the commit message were excluded.

Hope that helps,

[FrankV]

Basically this did work, but it would be nicer if it could be done directly from the page as the returned format is quite different.