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 topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Fubar 8,528 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
H V 1,510 on at

Like
a
(0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
romankorchak2 125 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot, that works now 😀

Was this reply helpful? Yes No