I am gathering data from the LiveChatTranscript and there are multiple references to user as lookup fields. How do I pick which property I want to use as my reference to user?
LiveChatTranscript properties
LastModifiedById Lookup(User)
CreatedById Lookup(User)
OwnerId Lookup(User,Group)
query
-webroot-/query/?q=select chatkey, caseid, status,requesttime, starttime, endtime,endedby,name,ReferrerUri,platform,location, waittime,body,supervisortranscriptbody, case.description, ownerid,***ownerid.user.alias??*** from livechattranscript where chatkey = '12345'
Do I just need to do 2 queries? One to get the chat data and one to get the owner data?
The ID of the operator who participated in the chat last; for missed chats, this is a system user.
; see also soql and owner relationship answer