I have Contact and Case relationship mapped to LiveChatTranscript through ContactId and CaseId like the following:
I need to fetch LiveChatTranscript data along with Contact and Case in a single query. From documentation:
I have tried the following query:
SELECT Id, (SELECT Contact.FirstName from Contacts), UserAgent, ChatKey, ChatDuration, Status, Body, CreatedDate, LastModifiedDate FROM LiveChatTranscript WHERE Status = 'Completed' LIMIT 20
But always getting
[ { "message": "\n(SELECT Contact.FirstName from Contacts), UserAgent, ChatKey, ChatDuration\n ^\nERROR at Row:1:Column:44\nDidn't understand relationship 'Contacts' 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.", "errorCode": "INVALID_TYPE" } ]
I'm confused how am I supposed to use the ContactId and CaseId for this case since it says there is not relationship like what the documentation specified. Any help is greatly appreciated!