I'm trying to access the value of object 2(LiveText__Conversation_Header__c
) from object 1 (Case
) and getting error.
Query:
SELECT (SELECT LiveText__EndedTime__c FROM LiveText__Conversation_Header__c),
CaseNumber, LS_Contract__r.Name, Account.Name,
LS_Contract__r.cllease__Last_Payment_Date__c, FORMAT(LastModifiedDate), Type, Description
FROM Case
Error:
(SELECT LiveText__EndedTime__c FROM LiveText__Conversation_Header__c) ^ ERROR at Row:1:Column:44 Didn't understand relationship 'LiveText__Conversation_Header__c' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.