{Portals} How to access related entity field in liquid template

(0) Share

Report

Posted on by RaviKashyap

55,410 Moderator

I am using fetch xml/ liquid to retrieve the entity details. This works fine and I can display the retrieved fields from the main entity. However I also have a linked entity and want to display the field from that as well. I tried different combination but nothing worked.

{{ result.<alias>.<fieldname> | escape }} - not working

{{ result.<fieldname> | escape }} - not working

{{ result.<related entity schema name>.<fieldname> | escape }} - not working

{{ <alias>.<fieldname> | escape }} - not working

Any thoughts?

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

Inogic 709 on at

Like (4)

Report

Hi Ravi,

1. Below is the fetch xml that contains link entity of account

{% fetchxml contact_account_query %}

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="contact">

    <attribute name="fullname" />

    <attribute name="telephone1" />

    <attribute name="contactid" />

    <order attribute="fullname" descending="false" />

    <filter type="and">

      <condition attribute="firstname" operator="eq" value="david" />

      <condition attribute="lastname" operator="eq" value="beckham" />

    </filter>

    <link-entity name="account" from="accountid" to="parentcustomerid" visible="false" link-type="outer" alias="ai">

      <attribute name="name" />

      <attribute name="websiteurl" />

      <attribute name="telephone1" />

    </link-entity>

</entity>

</fetch>

{% endfetchxml %}

2. To get alias value from link entity use below code

{% for result in contact_account_query.results.entities %}



Contact Name : {{result.fullname}}<br/>

Account Name : {{result['ai.name']}} (this is alias value)

{% endfor %}

so to get alias value use {{result['ai.name']}}

Thanks!

1 people found this reply helpful.

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (1)

Report

Thanks it worked :)

Was this reply helpful? Yes No
ammi64 87 on at

Like (0)

Report

Hi Ravi,

can you please help me out on how to access related entity field in liquid template, need an urgent response from your end.

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Did you try the above suggestions, that (getting aliased value) worked for me.

Was this reply helpful? Yes No
ammi64 87 on at

Like (0)

Report

I just need to access the related account fields of the contacts through liquid code. I am able to show up the name and id using the following liquid tag:

{{user.parentcustomerid.id}}

{{user.parentcustomerid.name}}

but not able to access the other fields

Was this reply helpful? Yes No
ammi64 87 on at

Like (0)

Report

parentcustomerid is an entity reference object. I want to access the account fields related to contacts of that account to show up in the copy area on the webpage in MSCRM portal.

Was this reply helpful? Yes No
Suggested answer

Nicholas Hayduk 2,863 on at

Like (1)

Report

You are correct - parentcustomerid is the entity reference object, which only gives you ID and name. To get access to the entire entity, use the relationship name instead of the name of the lookup field, like so:

user.contact_customer_accounts.address1_line1

Nick

Was this reply helpful? Yes No
ammi64 87 on at

Like (0)

Report

Thanks a lot Nicholas. Now I am able to access the account fields.

Was this reply helpful? Yes No
ammi64 87 on at

Like (0)

Report

Hi Nicholas when I am logged in with a different user I am not able to see the account fields.

Was this reply helpful? Yes No
ammi64 87 on at

Like (0)

Report

Hi Nicholas,

user.contact_customer_accounts.address1_line1 this works only when my user is logged in as a administrator on the portal but it dosen't work for the users assigned authenticated web roles. Any solution to this ?

Was this reply helpful? Yes No