Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Odata CRM

Posted on by 160

hi.

i have jquery written on my entity list to filter two lookup field. it only retrieve 10 records. i want to increase it more. how can i do  that?

regards

$(document).ready(function () {

    $("#dropdown_0").on(
        "change",
        function (eventObject) {
            var user = $('#dropdown_0').val();
            //alert(user);
            var get_FilteredOut = "/_odata/account/?$filter=ownerid/Id%20eq%20(guid%27" + user + "%27)";
            $.ajax({
                type: "GET",
                url: get_FilteredOut,
                dataType: 'json'
            }).done(function (json) {
                var values = json.value;
                values.push({ accountid: "", name: "" });
                values = values.reverse();
                $("#dropdown_3").empty();
                $.each(values, function (index, value) {
                    $("#dropdown_3").append('<option value="' + value.accountid + '">' + value.name + '</option>');
                })
            })
        });
});

  • Suggested answer
    Guido Preite Profile Picture
    Guido Preite 54,081 Super User 2024 Season 1 on at
    RE: Odata CRM

    looks like the code is calling a custom api and not directly the crm odata

    var get_FilteredOut = "/_odata/account/?$filter=ownerid/Id%20eq%20(guid%27" + user + "%27)";

    and also if that url was a crm odata, the limit would be 5000 records, there is nothing in the code you posted that limit the records to 10.

    check that api endpoint logic.

    hope it helps

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans