Hi all,
For our community portal I have created a n:n relationship between contact and a custom entity named themes. Here users can, trough a subgrid placed on an entity form available on their profile, show interest in several themes we as a community discuss.
Now I want to fetch all themes a contact is interested in trough this n:n relationship in a liquid fetchXML to create a customised welcome screen for the user on the portal. This themes entity is used trough out the portal so I like to have it as a relation.
in XRM toolbox I was able to build a fetchXML statement to query the needed data. However when on the portal this query does not work. Is it possible to query n:n relations this way? Entity permissions for both entities are set to global read. Is there any other way to fetch the required data? I need the name and guid of the related themes to a contact.
thanks in advance.
Simon
the xml statement:
<fetch top="50" >
<entity name="contact" >
<attribute name="firstname" />
<attribute name="lastname" />
<link-entity name="bhs_contact_bhs_thema_final" from="contactid" to="contactid" intersect="true" >
<link-entity name="bhs_thema" from="bhs_themaid" to="bhs_themaid" alias="thema" >
<attribute name="bhs_name" />
</link-entity>
</link-entity>
</entity>
</fetch>