You need to sign in to do that
Don't have an account?
E G
Identify Case Team Members who actually created the Case
Hi,
I'd like to identify all MemberIds of users that actually created cases. I'm trying to use SOQL to achieve this but I'm missing something in the query.
Select ctm.Id, ctm.MemberId, ctm.ParentId, ctm.TeamRoleId from CaseTeamMember ctm WHERE ParentId IN (SELECT cId FROM Case c WHERE RecordTypeId = '012800000002y3wAAA' AND CreatedDate > 2017-07-10T18:33:32.000+0000) AND MemberId = <CaseOwnerId>
Thanks,
Eno
I'd like to identify all MemberIds of users that actually created cases. I'm trying to use SOQL to achieve this but I'm missing something in the query.
Select ctm.Id, ctm.MemberId, ctm.ParentId, ctm.TeamRoleId from CaseTeamMember ctm WHERE ParentId IN (SELECT cId FROM Case c WHERE RecordTypeId = '012800000002y3wAAA' AND CreatedDate > 2017-07-10T18:33:32.000+0000) AND MemberId = <CaseOwnerId>
Thanks,
Eno
What is the error you are getting ?
the only thing that seems strange in the query is instead of c.Id its cId
Sorry, that's a typo. The actual soql os c.Id. The question here is more around the syntax of how to compare the MemberId with the Case.CreatedBy field.