
I am trying to create an Apex class the returns all Cases related to contact by passing a parameter(Email)
And below the list of field, it should return,
case id, case subject, created on, updated on, case status, version, type, priority, description attachments, comments.
Can someone help me with this?
Thanks a lot in advance.
3 Antworten
Use this query to return the values
Select id, subject, status, Version, type, priority, (SELECT Id, Name FROM Attachments) ,Contact.Email from Case where Contact.Email = '(Parameter Email)'