Currentpage-like support for skipped (OData) #358

Activity

1. mookfist commented on Sep 19, 2017

   

   mookfist

   on Sep 19, 2017

   More actions

   +1

   dealing with an API that uses offset/limit rather than page/limit

   👍React with 👍2Reacted by NRDEV88 and Alex Dowgailenko
2. alex-dow commented on Sep 20, 2017

   

   alex-dow

   on Sep 20, 2017

   More actions

   I too ran into this problem. I had to implement my own solution:

       state: {
           firstPage: 0,
           currentPage: 0,
           pageSize: 5,
           offset: 0
       },  
       queryParams: {
           pageSize: 'limit',  // LIMIT in SQL speak
           start: 'after'          // OFFSET in SQL speak
       },  
   
       getOffset: function() {
           console.log('getOffset:', this.state);
           return this.state.currentPage * this.state.pageSize;
       },  
   
       fetch: function(options) {
   
           if (!options) {
                  options = {}; 
           }   
           if (options['data']) {
               options['data']['after'] = this.getOffset();
           } else {
               options['data'] = { 
                   'after': this.getOffset()
               };  
           }   
   
           return PaginatedCollection.prototype.fetch.call(this, options);
       }

   All the terminology here is annoying if you're used to offset/limit terminologies. The API I'm using uses the terms "after/limit" while backbone.paginator uses "start/pageSize" but SQL uses "offset/limit".

   So far this seems to work as expected but do I get unnecessary query params in my API request. I can live with that...
3. jackbentley commented on Jan 31, 2018

   

   jackbentley

   on Jan 31, 2018

   More actions

   If I'm not wrong, the example from the readme solves this nice and succinctly? (I think that's where I first found it?)

     queryParams: {
       pageSize: "limit",
       // Setting a parameter mapping value to null removes it from the query string
       currentPage: null,
       // Any extra query string parameters are sent as is, values can be functions,
       // which will be bound to the pageable collection instance temporarily
       // when called.
       offset: function () { return this.state.currentPage * this.state.pageSize; }
     },

   👍React with 👍1Reacted by Alexey