Condition for child object

  • 1
  • Question
  • Updated 2 years ago
  • Answered
Let say company is a parent object  and employee is a child object. Is it possible to include child object field on condition for parent object model.
Photo of ace

ace

  • 580 Points 500 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
Yes! This can be done by using the Result of subquery condition option. Then, you can use additional conditions on the subquery itself.

Check out this screenshot. It will load all accounts with child contacts named John Smith.

Photo of ace

ace

  • 580 Points 500 badge 2x thumb
Works. Really Appreciated!
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
No probelmo!