Fetch field value from third level of master- detail - sub detail for search

I ran into an issue for fetching field values in search results from third level relationship hierarchy.

I could find on Coveo site that there is a below limitation on Coveo end for this â

"When the organization-wide default is set to Controlled by Parent, a maximum master-detail relationship depth of two levels is supported (see Sharing Default Access Settings). Example: When you index a sub-detail object, the detail parents are correctly determined but the master parents are considered public because there are three levels (master-detail-subdetail)."

Is there a workaround for this problem?

P.S - I have tried using formula fields on Parent object and then fetch the same but no luck.

1 Reply

I think you misunderstood our documentation. The master-detail relationship is a concept in Salesforce related to controlled by parent permissions. I think, what you are trying to achieve is to retrieve fields of parent or child objects. By using parent or child relationship, you'll be able to put parent's parent fields or children's fields on a record.