Master/Detail Pull

Created on 6 May 2024, 8 months ago

I'm trying to add a Subquery to a mapping where the mapped object is the Master in a Master/Detail object.

I have a custom events object Event__c that is mapped and pulling fine - I need to pull data from the custom object Event_Facility_Members__c where Event__C is the master.

I have the soql like this:

$query->fields[] =
          "(SELECT Facility__c from Event_Facility_Members__c WHERE Event_Facility_Members__c.Event__C = '$query->fields[0]')";

I've also tried it with a Event__c record Id like this that I know should return results:

$query->fields[] =
          "(SELECT Facility__c from Event_Facility_Members__c WHERE Event_Facility_Members__c.Event__C = 'a0KEa00000B07CrMAJ')";

In every instance I get an error in line 217 of the queuehandler Call to a member function size() on null.

I assume it's a SOQL issue - but I can't figure it out as the SOQL works in the developer console in SF.

πŸ’¬ Support request
Status

Active

Version

5.0

Component

salesforce.module

Created by

πŸ‡ΊπŸ‡ΈUnited States jseltzer

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024