Gravatar for momaheshwari@deloitte.com

Question by mohit, Apr 28, 2016 11:41 AM

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
Gravatar for maveilleux@coveo.com

Answer by maveilleux, Apr 28, 2016 4:31 PM

Hi mohit!

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.

Here's our documentation about that: https://onlinehelp.coveo.com/en/ces/7.0/administrator/salesforceobjectstogetconfiguration_file.htm

You can also embed parent relationship recursively. You can also check our XSD file for more details. https://onlinehelp.coveo.com/en/ces/7.0/administrator/salesforceobjectstogetconfiguration_file.htm#XML

Hope it will help!

Gravatar for momaheshwari@deloitte.com

Comment by mohit, May 3, 2016 3:15 AM

it didn't help, I want to raise a ticket for the same, Could you pl help me with this?

Ask a question