Apex Code Development You need to sign in to do that
Don't have an account?
Michael M Are there any common ID's on ListEmail class and EmailStatus class?
Are there any common ID's on ListEmail and EmailStatus classes?
My task is to get the emailstatuses of list emails sent through a campaign. I know that ListEmail class can get the CampaignID. But now I need to get the Email Statuses of those emails. Is that possible? I would be able to do it by the ownerid of the listemail or by the campaignid. Are there any common fields between listemail and emailstatus?
My task is to get the emailstatuses of list emails sent through a campaign. I know that ListEmail class can get the CampaignID. But now I need to get the Email Statuses of those emails. Is that possible? I would be able to do it by the ownerid of the listemail or by the campaignid. Are there any common fields between listemail and emailstatus?
All Answers
There are no common ids on ListEmail and EmailStatus.
For further reference check the below,
https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_emailstatus.htm
https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_listemail.htm
Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Thanks.
Is there any other way to connect the 2 with different queries? What about the Contact and the campaign? Or the contact and the listemail?
1. campaign camp = [select id from campaign where id = '7013l000000yq77AAA'];
2. list<listemail> le = [select id, createddate, fromaddress, totalsent, ownerid from listemail where campaignid = :campid];
and I need to be able to connect those with this:
3. List<Contact> contList = [Select id, name, CreatedDate, lastModifiedDate, email,
(SELECT id, taskId, createdDate, firstOpenDate, lastOpenDate, timesOpened, emailTemplateName, task.subject, task.TaskSubtype FROM EmailStatuses where createddate = today and task.tasksubtype = 'ListEmail' ) from Contact where email != null ];
But as I think it is in Beta version,
https://help.salesforce.com/articleView?id=release-notes.rn_sales_account_campaign_members.htm&release=230&type=5
Check this Idea too,
https://trailblazer.salesforce.com/ideaView?id=08730000000BrEVAA0
Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Thanks.