After querying a record, I am trying to access a value from a related record, but the value is not showing up. It just returns null. I checked my Record Lists to confirm the expected values are there.
Ex. Record one called Activity Status has a many to one relationship with record two called Activity.
Record Activity Status has the status of the activity for each user with a foreign key called ActivityID that references the Activity record.
Record Activity has the name of the activity.
Ex row for Activity Status: id 1, activityID 2.
Ex row for Activity: id 2, name: "running"
My record query returns the ActivityStatus with id 1 and activityID 2, which is stored in local!data.
I am trying to get the activity name with local!data[recordType!ActivityStatus.relationships.Activity.fields.name]
Does anyone know why this does not work?
Discussion posts and replies are publicly visible
I had a similar problem. For me I forgot to specify the relationship/fields I want returned in the field parameter of queryRecordType
a!queryRecordType( fields: { (The relationship fields) }, ... ).data
Just to add on, you can just mention the related record type instead of defining every field. Also be sure to filter within the related record type on the foreign key id if applicable.
Hi Maria, Did you able to figure out why it doesn't work? Am having same question.
Did you follow the suggestions in this thread? Can you share the code of your query?
Please try ericm's solution.
Otherwise, another possibility is that the Record Security is preventing you from seeing the field.