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.