You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@couchdb.apache.org by Kiril Stankov <ki...@open-net.biz> on 2015/05/19 19:09:10 UTC
How can I know if there are more items when using startkey and endkey
Hi,
I am trying to implement pagination, but I run into an issue.
My view is pretty simple, it emits documents with a composite key - one
of the doc's fields and a date field:
emit([doc.refID, new Date(doc.date*1000)], null);
The query I send is:
http://db:port/db/_design/designDoc/_view/ByRefID?startkey=["somekey",{}]&endkey=["somekey"]&descending=true&skip=0&limit=4
This works fine. The problem is that from the response:
{"total_rows":20,"offset":14,"rows":[
{"id":"205765617df5163269f3a6c02d03d4ab","key":["409aea325150f27b69fee977fa03580a","2015-05-19T16:26:36.000Z"],"value":null},
{"id":"205765617df5163269f3a6c02d01d0ac","key":["409aea325150f27b69fee977fa03580a","2015-05-14T12:32:01.000Z"],"value":null},
{"id":"409aea325150f27b69fee977fa10d9bd","key":["409aea325150f27b69fee977fa03580a","2015-04-23T12:16:59.000Z"],"value":null},
{"id":"409aea325150f27b69fee977fa0fc301","key":["409aea325150f27b69fee977fa03580a","2015-04-23T11:10:20.000Z"],"value":null}
]}
I cannot tell if there are more items to show.
The total_rows returns the number of all documents matching the view,
not only those matching the start and end keys. Also, I do not know how
to interpret the offset param in this case. What 14 stands for, in this
case.
Any idea will be appreciated.
Thanks in advance!
------------------------------------------------------------------------
*With best regards,*
Kiril Stankov,
Re: How can I know if there are more items when using startkey and
endkey
Posted by Kiril Stankov <ki...@open-net.biz>.
_
/(|
( :
__\ \ _____
(____) `|
(____)| |
(____).__|
(___)__.|_____
THANKS!
------------------------------------------------------------------------
*With best regards,*
Kiril Stankov
On 19-May-15 8:16 PM, Alexander Shorin wrote:
> http://docs.couchdb.org/en/latest/couchapp/views/pagination.html#paging-alternate-method
> --
> ,,,^..^,,,
>
>
> On Tue, May 19, 2015 at 8:09 PM, Kiril Stankov <ki...@open-net.biz> wrote:
>> Hi,
>>
>> I am trying to implement pagination, but I run into an issue.
>> My view is pretty simple, it emits documents with a composite key - one of
>> the doc's fields and a date field:
>> emit([doc.refID, new Date(doc.date*1000)], null);
>> The query I send is:
>> http://db:port/db/_design/designDoc/_view/ByRefID?startkey=["somekey",{}]&endkey=["somekey"]&descending=true&skip=0&limit=4
>>
>> This works fine. The problem is that from the response:
>>
>> {"total_rows":20,"offset":14,"rows":[
>> {"id":"205765617df5163269f3a6c02d03d4ab","key":["409aea325150f27b69fee977fa03580a","2015-05-19T16:26:36.000Z"],"value":null},
>> {"id":"205765617df5163269f3a6c02d01d0ac","key":["409aea325150f27b69fee977fa03580a","2015-05-14T12:32:01.000Z"],"value":null},
>> {"id":"409aea325150f27b69fee977fa10d9bd","key":["409aea325150f27b69fee977fa03580a","2015-04-23T12:16:59.000Z"],"value":null},
>> {"id":"409aea325150f27b69fee977fa0fc301","key":["409aea325150f27b69fee977fa03580a","2015-04-23T11:10:20.000Z"],"value":null}
>> ]}
>>
>> I cannot tell if there are more items to show.
>>
>> The total_rows returns the number of all documents matching the view, not
>> only those matching the start and end keys. Also, I do not know how to
>> interpret the offset param in this case. What 14 stands for, in this case.
>>
>> Any idea will be appreciated.
>> Thanks in advance!
>> ------------------------------------------------------------------------
>> *With best regards,*
>> Kiril Stankov,
>>
Re: How can I know if there are more items when using startkey and endkey
Posted by Alexander Shorin <kx...@gmail.com>.
http://docs.couchdb.org/en/latest/couchapp/views/pagination.html#paging-alternate-method
--
,,,^..^,,,
On Tue, May 19, 2015 at 8:09 PM, Kiril Stankov <ki...@open-net.biz> wrote:
> Hi,
>
> I am trying to implement pagination, but I run into an issue.
> My view is pretty simple, it emits documents with a composite key - one of
> the doc's fields and a date field:
> emit([doc.refID, new Date(doc.date*1000)], null);
> The query I send is:
> http://db:port/db/_design/designDoc/_view/ByRefID?startkey=["somekey",{}]&endkey=["somekey"]&descending=true&skip=0&limit=4
>
> This works fine. The problem is that from the response:
>
> {"total_rows":20,"offset":14,"rows":[
> {"id":"205765617df5163269f3a6c02d03d4ab","key":["409aea325150f27b69fee977fa03580a","2015-05-19T16:26:36.000Z"],"value":null},
> {"id":"205765617df5163269f3a6c02d01d0ac","key":["409aea325150f27b69fee977fa03580a","2015-05-14T12:32:01.000Z"],"value":null},
> {"id":"409aea325150f27b69fee977fa10d9bd","key":["409aea325150f27b69fee977fa03580a","2015-04-23T12:16:59.000Z"],"value":null},
> {"id":"409aea325150f27b69fee977fa0fc301","key":["409aea325150f27b69fee977fa03580a","2015-04-23T11:10:20.000Z"],"value":null}
> ]}
>
> I cannot tell if there are more items to show.
>
> The total_rows returns the number of all documents matching the view, not
> only those matching the start and end keys. Also, I do not know how to
> interpret the offset param in this case. What 14 stands for, in this case.
>
> Any idea will be appreciated.
> Thanks in advance!
> ------------------------------------------------------------------------
> *With best regards,*
> Kiril Stankov,
>