Skip to main content
ManojKumar Muthu (Appviewx) 님이 #Data Management에 질문했습니다
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일 오후 3: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