Microsoft Dynamics CRM (Archived)

Dynamics Portal FetchXML returns empty

(0) Share

Report

Posted on by Sskod

105

Hello,

I'm executing a fetch XML query in the liquid code, my XML is correct but it always returns empty

could you please help?

Here is my code

{% fetchxml MyFetchSearch %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" count="1" returntotalrecordcount="true" page="1" >
  <entity name="new_entity">
     <attribute name="new_entityname" />
    <filter type="and">
       <condition attribute="new_entityattribute" value="1" operator="eq"/>
    </filter>
  </entity>
</fetch>
{% endfetchxml %}{ 
  "Result" : "{{MyFetchSearch }}"
}

Thank you

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: Dynamics Portal FetchXML returns empty

Hi,

In advanced find look for "new_entity",select "new_entityname" in view and use condition "new_entityattribute" equals 1. If it returns any rows then download fetchxml from advanced find and use it in your code.

If still you face issue then check that current user has privilege to read "new_entity" or not.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report
RE: Dynamics Portal FetchXML returns empty

Have you tried something along the lines of:

{% for res in MyFetchSearch.results.entities %}
{{ res.fieldname1 }}
{{ res.fieldname2 }}
...
{% endfor %}
Suggested answer

Arpit Shrivastava 7,518 User Group Leader on at

Like (0)

Report

RE: Dynamics Portal FetchXML returns empty

Please make sure you have enabled the proper Entity Permissions on the entity (new_entity).

If found useful, please mark the answer as verified.

Cheers

Arpit

arpitmscrmhunt.blogspot.com
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Dynamics Portal FetchXML returns empty

Hello,

are you confirm your condition is correct or not?

<filter type="and">

<condition attribute="new_entityattribute" value="1" operator="eq"/>

</filter>

Dynamics Portal FetchXML returns empty

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Leaderboard

Featured topics

Product updates

Dynamics Portal FetchXML returns empty

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Subscribe to

Leaderboard

Featured topics

Product updates