Lesson: 75 | Retrieve Accounts with Related Contacts and Cases

User Story
Code

User Story

As a Salesforce administrator,
I want to retrieve a list of all accounts in the healthcare industry along with their related contacts and the cases associated with each contact,
so that I can better understand the relationships between healthcare accounts, their key contacts, and any support cases they have opened.

Code

List<Account> accountsWithContactsAndCases = [
    SELECT Id, Name,
        (SELECT Id, LastName, 
            (SELECT Id, Status FROM Cases) 
        FROM Contacts)
    FROM Account
    WHERE Industry = 'Healthcare'
];

You need to login to have access to the quizzes. This lesson has already been completed by you.

Mastered by 5 users.

Exercises

A. Administrator | Exercises (59 lessons)

B. Flow Builder | Exercises (41 lessons)

C. Apex Beginner | Exercises (78 lessons)

D. Apex Intermediate | Exercises (90 lessons)

E. Integration | Exercises (4 lessons)

F. Lightning Web Component (LWC) Exercises (14 lessons)

Go to top

Login to your account

Lesson: 75 | Retrieve Accounts with Related Contacts and Cases

User Story

Exercises