AnsweredAssumed Answered

SOQL Query: filtering based on parent and child fields

Question asked by GiorgioPorro891 on Jul 30, 2015
Latest reply on Jul 30, 2015 by mfrontera

Hello

 

I am developing a Salesforce operation to GET Cases records that match certain conditions.
My Cases have a Parent object, called iRhythm_Asset. The Asset object has a field called "SIZE"

 

I want to get all Cases where the Status = "NEW" and the parent asset size < 20.

 

In SOQL I would simply write "where Status = 'NEW' and Asset__r.SIZE < 20", but how do I write this with the BOOMI filters interface using Logical AND spanning across two objects?

 

0EM40000000brlL

Outcomes