Write a SOQL query to fetch all child Accounts, parent Accounts, and grandparent Accounts up to 4 levels up (Parent.Parent.Parent.Name).

Q: Write a SOQL query to fetch all child Accounts, parent Accounts, and grandparent Accounts up to 4 levels up (Parent.Parent.Parent.Name).

Walk up the hierarchy through the self-lookup ParentId using chained Parent relationships (up to 5 levels allowed in one path). Each row shows the Account and its parent, grandparent and ancestors up to four levels up. Missing levels return null.

Question

Accepted Answer

Walk up the hierarchy through the self-lookup ParentId using chained Parent relationships (up to 5 levels allowed in one path).

soql

SELECT Id, Name, Parent.Name, Parent.Parent.Name, Parent.Parent.Parent.Name, Parent.Parent.Parent.Parent.Name
FROM Account

Each row shows the Account and its parent, grandparent and ancestors up to four levels up. Missing levels return null.

Write a SOQL query to fetch all child Accounts, parent Accounts, and grandparent Accounts up to 4 levels up (Parent.Parent.Parent.Name).

More Development questions