I have Room (roomID column) and a Key (with keyID, roomID, and keyDescription columns) . A room can have multiple keys. I setup a one to many relationship between the Room and a Key using the roomID.
I used the Room record to populate a gridField. The search is not returning anything if I put an information that should match the keyDescription. I have the code below. I am only after for keys that are active which is one active key per room. Even if I remove the filter in the code, it does not return anything. Is this expected for a One to Many relationship?
{ a!gridField( data: a!recordData( recordType: <room_record>, relatedRecordData: a!relatedRecordData(relationship: '<roomRecord-keyRecord>', filters: { a!queryFilter( field: '<keyRecord.isActive>', operator: "=", value: true ) } ), columns: {
a!gridColumn( label: "Room ID", sortField: 'roomRecord.roomID', value: fv!row['roomRecord.roomID'], ),
a!gridColumn( label: "Key Description", sortField: 'roomRecord-keyRecord.keyDescription', value: fv!row['roomRecord-keyRecord.keyDescription'], ))}
Discussion posts and replies are publicly visible
Hi Vernon Pinawin, Can you please update if got any solution for this
you got any solution for this case , search not working for related records fields , it looks to me only the primary record type data getting the search results