You need to sign in to do that
Don't have an account?
BorthiryM
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:
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: