soql父到子soql请求的结果

Question

我想知道如何显示soql子请求到父请求的结果。

$query = "SELECT FirstName, LastName, (select Retreat_Booking__c.Retreat__c from Retreat_Bookings__r)FROM Contact" 

$response = $mySforceConnection->query($query);   
$queryResult = new QueryResult($response);  
while($queryResult->current()->FirstName!='' || $queryResult->current()->LastName!='')
{
    echo $queryResult->current()->FirstName." ".$queryResult->current()->LastName." ".$queryResult->current()->Retreat__c." <BR/>";
    $queryResult->next();
}

请求工作并显示"FirstName“和"LastName”，但不显示"Retreat__c“。我知道第二次选择的结果是一个json，我尝试了很多方法，但都不起作用。

Answer 1

查询应如下所示

$query = "SELECT FirstName, LastName, (select Retreat_Booking__r.Retreat__c from Retreat_Bookings__c)FROM Contact";

那是,

用Retreat_Booking__r.Retreat__c代替Retreat_Booking__c.Retreat__c

和

用from Retreat_Bookings__c代替Retreat_Bookings__r

在扩展名之后，应该有自定义对象名称( FROM is __c) Retreat_Bookings__c，并从引用对象字段中检索数据，您应该使用__r扩展名，从而使用Retreat_Booking__r.Retreat__c

更新

对于你的第二个问题，你可以尝试

$query = "SELECT FirstName, LastName, (select Retreat_Booking__r.Retreat__c from Retreat_Bookings__c) AS rb FROM Contact"

然后

while($queryResult->current()->FirstName!='' || `$queryResult->current()->LastName!='')
{
echo $queryResult->current()->FirstName." ".$queryResult->current()->LastName." ".$queryResult->current()->rb.Retreat__c" <BR/>";
$queryResult->next();
}`