How to select reviews by multiple authors in Crucible?

Question

I'm trying to create a filter which will show me all reviews created by people from some list, so, using pseudo-code, it would be some kind of:

SELECT * FROM reviews WHERE author IN (johndoe, janedoe, jamesdoe)

However, I don't see a possibility to specify more than one name in fields author, moderator, creator and reviewer:

image2016-2-1 13:45:19.png

I tried to separate them with a comma, a semicolon or a space but it's not a valid format.

So I'd like to ask if there's any possibility to choose multiple people in any of these fields for a custom filter?

Thanks.

image2016-2-1 13:45:19.png

Andrei Rykhalski · Answer

Unfortunately, I've found that link in FishEye only, but not in Crucible. EyeQL queries return a list of revisions (FishEye items), while I need to retrieve a filtered list of code reviews (Crucible items), so I wonder if there's any functionality for that in Crucible.

Marek Parfianowicz · Answer

Click on the "Switch to EyeQL search" link to run an advanced search query:

https://confluence.atlassian.com/fisheye/searching-fisheye-298976804.html#SearchingFishEye-SearchingtheRepository-AdvancedSearch

https://confluence.atlassian.com/fisheye/eyeql-reference-guide-298976796.html