Link Entity Data

Resolved

(@manojmane29)

Hi,

I am using the fetchXML in my wordpress page. Where i have to show the link entity data but i am unable to prepopulate the data of link entity.

I am using the below fetchXML :-

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="gfav_subsidyapplication">
    <attribute name="gfav_subsidyapplicationid" />
    <attribute name="gfav_name" />
    <attribute name="createdon" />
    <attribute name="gfav_program" />
    <attribute name="gfav_lastname_subsidy" />
    <attribute name="gfav_firstname_subsidy" />
    <attribute name="gfav_email_subsidy" />
    <attribute name="gfav_dateofbirth_subsidy" />
    <order attribute="gfav_name" descending="false" />
    <filter type="and">
      <condition attribute="gfav_subsidyapplicationid" operator="eq"  value="{9857B6EC-4DBE-EB11-BACC-0022486D8A0D}" />
    </filter>
    <link-entity name="av_programs" from="av_programsid" to="gfav_program" link-type="inner" alias="ab" />
  </entity>
</fetch>

The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Author alexacrm
(@alexacrm)

4 years, 11 months ago
Hi @manojmane29

<link-entity> node needs to include <attribute> child nodes, e.g.
```
<link-entity name="av_programs" from="av_programsid" to="gfav_program" link-type="inner" alias="ab">
   <attribute name="av_name" />
</link-entity>
```
Use FetchXmlBuilder for XrmToolBox to visually build and test your queries.
HTH
George
Thread Starter manojmane29
(@manojmane29)

4 years, 11 months ago

@alexacrm Okay but how can i read the alias entity attribute value ? Can you please share the syntax format.

Thanks,
Manoj

Plugin Author alexacrm
(@alexacrm)

4 years, 11 months ago

@manojmane29

using the alias, something like

{{ record['ab.av_name'] }} where record is the variable iterating over the array returned by the fetch.

HTH
George

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Link Entity Data’ is closed to new replies.