How to select all commits for a given user in EyeQL?

In Crucible, I use advanced search.

I try to select all commits for a specified user that were not reviewed.

The following query:

select revisions 
from dir / 
where 
(on branch master 
or on branch release-10
)
and not reviewed
and date >= 2014-09-23
group by csid
return csid,author,comment,date

works fine, but if I try to add where clause for author it doesn't work.

The author looks like "First Last" (E.g. "John Smith").

I tried to use ( before and not reviewed ):

• and author=First Last
• and author='First Last'
• and author="First Last"
• and author in (First Last)
• and author in ('First Last')
• and author in ("First Last")

but there are some problems:

• case 1:

  Search error:
  error parsing query: unexpected token: Last
  

• case 4:

  Search error:
  error parsing query: expecting RPAREN, found 'Last'
  

or it doesn't return a result (case: 2, 3, 5, 6).

I am sure that "First Last" exists because it can be found using the query above.

How can I create the query?

I found a solution:

and author = "first last <first.last@domainName.domain>"

Even if the author looks like "First Last" in the "Author" column, (s)he also has an e-mail that appears on mouse over.