92
I want to retrive 5000+ record using javascript.
i have 20000+ product in my price list so i want to retrive all using fetchxml
XrmServiceToolkit.Soap.Fetch(fetchXml);
Please help me.
Thanks in Advance..!!!!
i got the answer.
var fetchXmlProductInventory = " <entity name='productpricelevel'>" +
" <attribute name='productid' />" +
" <attribute name='amount' />" +
" <order attribute='productid' descending='false' />" +
" <filter type='and'>" +
" <condition attribute='pricelevelid' operator='eq' uiname='" + priceListName + "' uitype='pricelevel' value='" + priceListID + "' />" +
" </filter>" +
" <link-entity name='product' from='productid' to='productid' link-type='inner' alias='ab'>" +
" <attribute name='productnumber' />" +
" <attribute name='description' />" +
" <attribute name='name' />" +
"<attribute name='defaultuomid' />" +
" <filter type='and'>" +
" <condition attribute='als_tempproduct' operator='eq' value='0' />" +
"<condition attribute='statecode' operator='eq' value='0' />"
" </filter>" +
" </link-entity>" +
" </entity>";
var pageNumber = 1;
var pageCookies = "";
var fetchXmlProductInventory = ["<fetch mapping='logical' page='" + pageNumber + "' " + pageCookies + ">", fetchXmlProductInventory, "</fetch>"].join("");
Hi,
Would suggest to think about your implementation again, retrieving 20K+ records using javascript may cause some other problems. Why do you want all these products? Are you trying to populate some field/ table etc? If yes, think about the user who needs to select record from these 20K+ records.
Hello Maulik,
Please see the below link:
community.dynamics.com/.../odata-web-api-crm-online-how-to-query-more-than-5000-records
But how can i implement using javascript?
There are steps for c#...
can you please suggest me using example?
Hello,
If you want to use XrmServiceToolkit.Soap.Fetch you will have to use paging in the way similar to following - docs.microsoft.com/.../page-large-result-sets-with-queryexpression
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (