My team wants a report to show how many emails a customer service rep responds to a day from cases created from our website’s support page, not cases a rep would create on their own.
My plan is to make a GI that has case id’s, and created by, then the emails within those cases which I can filter by rep later, but I’m having a hard time finding the relation between a case and the emails in the case.
Does anyone have a good join for this?
Best answer by lauraj46
Hi
I think you should be able join CRSMEmail to CRActivity based on the refnoteid.
And then join CRActivity to CRCase in a similar fashion.
The SQL would be something like this, which you could replicate in the GI design:
select smemail.subject, crcase.casecd
from smemail CRSMEmail
join cractivity on CRSMEmail.refnoteid = cractivity.noteid
join crcase on cractivity.refnoteid = crcase.noteidHope this helps!
+8Hi
I think you should be able join CRSMEmail to CRActivity based on the refnoteid.
And then join CRActivity to CRCase in a similar fashion.
The SQL would be something like this, which you could replicate in the GI design:
select smemail.subject, crcase.casecd
from smemail CRSMEmail
join cractivity on CRSMEmail.refnoteid = cractivity.noteid
join crcase on cractivity.refnoteid = crcase.noteidHope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.