Reports and advanced filter

Hi, I´m trying to make a report to list all cases who have: one reply of a forwarded email.

    like:

select case.id
from case c
inner join email_1 e1(c.id=e1.case_id)
inner join email_2 e2 (c.id=e2.case_id)
    where email_1.status=new
   and un email_2.status=forwarded
   and email_1.date>email_2.date

It is possible using the advanced filter??:smileysurprised: