Everlive get(query) only returns 50 rows?

Thread is closed for posting
2 posts, 0 answers
  1. Nick
    Nick avatar
    1 posts
    Member since:
    Mar 2017

    Posted 10 Apr 2017 Link to this post

    Hi there.

    I am using Everlive backend services to run queries to my database and retrieve items from my table. I can successfully run the query and receive a result, however my result seems to be limited to 50 items and my table holds more than 50 items? Here is the piece of code I am using to retrieve results from my table: 

     

    var expandExp = {
      "CreatedBy" : {
        "ReturnAs" : "SchoolId",
    "SingleField" : "SchoolId",

        }
    };

    var query = new Everlive.Query();
    query.expand(expandExp);

    var data = everlive.data('Check_In');
    data.get(query)
        .then(function(data){


    console.log(data.result.length);
            
        },
        function(error){
            console.log(JSON.stringify(error));
        });

     

    "50" is returned to my console but my table has 58 records?

  2. Anton Dobrev
    Admin
    Anton Dobrev avatar
    609 posts

    Posted 11 Apr 2017 Link to this post

    @Nick

    Due to the usage of an expand query the limits for fetching expanded data (as explained here) are imposed. 

    You may consider using a paging setting or do not expand the data (eventually expand it when viewing the item details). 

    Let me know if this helps. 


    Regards,
    Anton Dobrev
    Telerik by Progress
     
    Everlive is now Telerik Backend Services, and is part of the Telerik Platform.
     
Back to Top