I am trying to figure out how to display the values for a couple of fields in a Lightning Web Component that is driven by the following SOQL query: SELECT Id, ActivityDateTime, Account.Name, Who.Name, Subject FROM Event
The resulting query results in Workbench come back like this:
In my LWC I am able to display the first 3 fields, but the 'Account.Name' and 'Name.Name' values currently return a blank value when I try to reference them using those fieldnames in my javascript file.
These are my questions I could use some help understanding:
- What is the correct format to use to display the Account Name and Contact Name values?
- Why does the Subject column show before the last two in the results, even though it comes last in the SOQL query?
- Why is the result showing Name.Name instead of Contact.Name?
Thanks very much!