Hello everyone,
I am using the FetchXML Builder and the query shows exactly what I want.
{% fetchxml testXML %}
<fetch>
<entity name="test_table">
<attribute name="attr1" />
<attribute name="LookUpField" />
<attribute name="attr3" />
<attribute name="attr4" />
<link-entity name="linked_Table" from="xyz_id" to="name" alias="nameXYZ" visible="true">
<attribute name="nameXYZ" />
</link-entity>
</entity>
</fetch>
{% endfetchxml %}
I want to retrieve a LookupField. But whysoever there's nothing displaying inside the LookUpField when I display it in a JSON.
I tried different combinations as below:
[
{% for item in testXML.results.entities %}
{
"Test1" : "{{ item.LookUpField }}",
"Test2" : "{{ item.nameXYZ }}",
"Test3" : "{{ item.LookUpField.nameXYZ }}"
}{% unless forloop.last %}, {% endunless %}
{% endfor %}
]
Inside the FetchXML Builder it's working fine, but the fetchXML inside my pagetemplate seems to have an issue.
Do I need to give the FetchXML additional access or something as it is not even displaying the GUID neither the Name which is referenced inse the LookUp.
Has somebody come across something like that or know how I can display the linked name attribute of the lookup column?
