Fetchxml doesnt return any data

(0) Share

Report

Posted on by romankorchak2

125

Hi All

I am just starting looking in to using liquid in power pages and building first fetchxml query but its not returning any data

{% fetchxml a_test %}
<fetch version="1.0" mapping="logical" > 
 <entity name="rim_testList1"> 
 <attribute name="Name"/> 
 </entity> 
</fetch> 
{% endfetchxml %}
{% assign aa_test = a_test.results.entities %}
{{ aa_test.size }}

And aa_test.size is always 0 😞
Its not permissions issue as I created another page with adding that list and it is showing results

Any idea where I am going wrong?

Also can anybody explain the difference between using fetchxml and entities.account[id]?

Thanks

Categories:

General

All responses (3)

Answers (1)

romankorchak2 125 on at

Like (0)

Report

Re: Fetchxml doesnt return any data

Thanks a lot, that works now 😀
H V 1,510 on at

Like (0)

Report
Re: Fetchxml doesnt return any data

Hi @romankorchak2

Please follow the steps which is provided by @Fubar
{% fetchxml a_test %} <fetch> <entity name="rim_testlist1"> <attribute name="rim_name"/> </entity> </fetch> {% endfetchxml %} {% assign aa_test = a_test.results.entities %} {{ aa_test.size }}

--------------------------
If you like this post, give a Thumbs up. Where it solved your query, Mark as a Solution so it can help other people!
Verified answer

Fubar 7,966 Super User 2025 Season 1 on at

Like (2)

Report
Re: Fetchxml doesnt return any data

as a start your fetchxml query is incorrect.
Your entity name needs to the the logical schema name of the table (will be all lowercase)
You do not have Column "Name" - on a custom table (as indicated by the prefix on the table name) your columns will be prefixed with your publisher prefix (base standard out of the box Tables and Columns are the only ones that do not have a prefix), and it will also be the logical schema name of the Column, and it will be all lowercase e.g. rim_name
For simple queries the easiest ways to create the fetchxml is to create a Model Driven App and either use Advanced Find or change the criteria on a view and then export the fetchxml (a button in the query builder).

More advanced queries download XrmToolBox (xrmtoolbox.com) and use its the fetchXML Builder tool.

Community site session details

Fetchxml doesnt return any data

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Pages

Featured topics

Product updates

Community site session details

Fetchxml doesnt return any data

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Pages

Featured topics

Product updates