Skip to main content
Hi,

 

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 件の回答
  1. 2018年6月27日 15:23
    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)'
0/9000