Missing 1:N fields in advance find/App views

(0) Share

Report

Posted on by RalphyC

I have a parental relationship between two custom entities, which work fine in relation to subgrids etc. However, while I can filter primary entity views based on fields in the related entity (using Advanced find>Primary entity>select>related entity etc), the option does not exist for me to add the columns to a view. What am I doing wrong?

Cheers

Ralph

Categories:

Other

All responses (5)

Answers (1)

RalphyC 11 on at

Like (2)

Report

RE: Missing 1:N fields in advance find/App views

Thanks Ravi, yep that makes sense (if a little frustrating). I'll have to work a way round from the other way!

Cheers

Ralph
Verified answer

RaviKashyap 55,410 on at

Like (3)

Report

RE: Missing 1:N fields in advance find/App views

Hi Ralph,

It is current not possible to select the field values from the parent entity and display it in the view. This is by design. The reason for this is advance find returns unique records, if CRM allows field from the child entity then it will result in duplicate record for the main/ parent entity.

E.g.

Parent 1Name Child1 Name

Parent 1 Name Child 2 Name

etc.

Hope this makes sense.
diegompc 798 on at

Like (1)

Report

RE: Missing 1:N fields in advance find/App views

Hi RalphyC!!

Is the field securiy disabled?

Have you marked the sercheable option?

Rehards!!
RalphyC 11 on at

Like (1)

Report

RE: Missing 1:N fields in advance find/App views

Hi Diego, yes for filter/query but not for columns (which is what I want so I can make a view including the column).

Cheers

Ralph
Suggested answer

diegompc 798 on at

Like (0)

Report

RE: Missing 1:N fields in advance find/App views

Hi RalphyC!!

Is the field available for Advanced Find?

Regards!!