web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

fetchXML and loop through the data set with JavaScript

(0) ShareShare
ReportReport
Posted on by 71

Hi

I used fetchXml to retrieve data from the entity and loop through the data set using JavaScript. However, when I loop through the data, I am getting an empty result (refer to the JAVASCRIPT code below).

Could you advise how i can get each data from the collection?

alert('{{porvinces[i].value}}');  //this line return empty

alert('{{porvinces[0].value}}');  // this line return the right value

<fetch top="50" >
<entity name="stringmap" >
<attribute name="attributevalue" />
<attribute name="displayorder" />
<attribute name="objecttypecodename" />
<attribute name="attributename" />
<attribute name="value" />
<attribute name="objecttypecode" />
<attribute name="langid" />
<attribute name="stringmapid" />
<filter type="and" >
<condition attribute="attributename" operator="eq" value="provincesterritories" />
</filter>
</entity>
</fetch>

$("document").ready(function() {
var entitySize="{{provinces.results.entities.size}}";
var i=0;
var entityObj;

for(i=0;i < entitySize;i++ )
{
alert('{{porvinces[0].value}}');  // i get the right value
alert('{{porvinces[i].value}}');  //this line return empty

}
});

I have the same question (0)
  • Suggested answer
    Nya Profile Picture
    29,060 on at

    Hi,

    As you can get the right value of {{porvinces[0].value}}, the issue most likely related to the circulation. Have you tried to see the value of the parameter – entitySize, which should not need to be enclosed in quotes?

     

    If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

    Best Regards,

    Nya

  • SivaR Profile Picture
    71 on at

    entitysize return 10

    in for loop, i can print the number. only if i use in this format '{{porvinces[i].value}}', i am not getting value.

    {% assign porvinces =   reasonEntries.results.entities %}

    $("document").ready(function() {

    var entitySize="{{reasonEntries.results.entities.size}}";

    alert(entitySize); // this line returns 10

    for(i=0;i < entitySize;i++ )

    { alert( i + " number of loop"); // this line retuns value

       alert('{{porvinces[2].value}}' + "  second item"); // this line retuns value

        alert('{{porvinces[i].value}}' + "==increment value==");

    }

    });

    }

  • Nya Profile Picture
    29,060 on at

    Hi,

    Have you checked the type of i? Is it a number or a string?

     

    Looking forward to your reply.

    Best Regards,

    Nya

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 209 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 71

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans