function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
NathanHobbsNathanHobbs 

Parent-Child/Child-Parent IN queries

I've found a bug in the connector, although there may be a reason it is written this way.

 

From my testing I have found that while i can use IN statement to lookup child items from the parent, for example, contacts on an account, it does not appear possible to do the reverse... query on the contacts then use an IN query to look up the parent on those contacts.

 

Admittedly we are using customer objects, but it appears that the IN criteria is limited to "references" fields.

 

I can work around it by adding ID fields to the types of fields applicable with IN statements in the code, but wanted to know if anyone else had found this problem and if it has perhaps been fixed in one of the later versions?

joker402joker402

 


NathanHobbs wrote:

From my testing I have found that while i can use IN statement to lookup child items from the parent, for example, contacts on an account, it does not appear possible to do the reverse... query on the contacts then use an IN query to look up the parent on those contacts.

 

 

 

I tried this by pulling a couple contacts with "reports to ID" as an output field, then in the next columns did the exact same query, but used "reports to ID" in <<Column with Reports to ID>> and got results...

 

You should be able to do the same with Account ID