couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Davis <paul.joseph.da...@gmail.com>
Subject Re: startkey and endkey problems
Date Wed, 23 Feb 2011 18:03:17 GMT
On Wed, Feb 23, 2011 at 12:54 PM, Fabio Batalha Cunha dos Santos
<fabio.batalha@scielo.org> wrote:
> Hello All,
>
> I'm using startkey and endkey in many situations but the one in question I
> can't figure out why isn't working.
>
> For example the following view.
>
> {"total_rows":19845,"offset":0,"rows":[
> {"id":"00d8a5b0-9d31-4c4b-a6a8-6a6818be0f13","key":"2176-945120100005","value":null},
> {"id":"ffcaac85-9dc7-441d-8cce-db54fb0d6d85","key":"2176-945120100004","value":null},
> {"id":"bd9535a9-2713-46be-b046-69cb049dad9b","key":"2176-945120100003","value":null},
> {"id":"6b91498e-5b31-4c10-8265-5c0b26edeb24","key":"2176-945120100002","value":null},
> {"id":"969b959b-fd2f-4475-ad63-11345e1a9f70","key":"2176-945120100001","value":null},
> {"id":"9406d63b-e268-45fa-a1ef-483963571be1","key":"2176-945120100001","value":null},
> {"id":"573539df-f554-4cca-961b-b658e56f3457","key":"2176-945120100001","value":null},
> {"id":"6c33f7d0-3211-4154-90f5-2b50fec0fbcf","key":"2071-076320100001","value":null},
> {"id":"2b2f07e2-5c08-4cae-b3bd-2519a69a7e62","key":"2071-076320090001","value":null},
> {"id":"62a7dd81-a710-4358-9449-fcbfcccc4049","key":"2011-758220100002","value":null},
> {"id":"966ba99b-3edc-4da5-89f3-28e32edc1625","key":"2011-758220100001","value":null},
> {"id":"f15c268a-41f7-4ef3-92d2-c1516101e121","key":"2011-758220090004","value":null},
> {"id":"ac88d963-e26e-4add-8a75-5d0287feb97f","key":"2011-758220090003","value":null},
> {"id":"84abbd88-8268-4b31-a90e-31a55a137e37","key":"2011-758220090002","value":null},
> {"id":"afe0f6bb-a14f-47fa-885a-f7b9bf33f2a5","key":"2011-758220090001","value":null},
> {"id":"7d7b6733-0c62-41ab-95aa-b01cd1f5d90e","key":"2011-758220080004","value":null},
> {"id":"22afed26-2995-4ffc-92d5-b0bdb3c18849","key":"2011-758220080003","value":null},
> {"id":"ca3a81f0-017c-4680-b25c-0babd6f5afd1","key":"2011-758220080002","value":null},
> {"id":"c9fda101-fd75-4990-862f-25fc8b936d1f","key":"2011-758220080001","value":null},
> {"id":"e384832d-8378-4ab4-98c5-cf7f9ed011cd","key":"2011-758220070004","value":null}
> ]}
>
>
> When I try to recover the keys that starts with "2176-9451" I try the
> following query:
> http://homolog.webservices.scielo.org/scieloorg/_design/couchdb/_view/issue_id?startkey=["2176-9451",{}]&endkey["2176-9451"]
>
> But this query results an empty json.
>
> The result is empty even if I try a query just with the startkey:
> http://homolog.webservices.scielo.org/scieloorg/_design/couchdb/_view/issue_id?startkey=["2176-9451"]
>
> Anybody have any idea why it is not working?
>
>
> Thanks in advance,
>
> *Fabio Batalha C. Santos*
> Colegiado SciELO
> www.scielo.org
> FAPESP - CNPq - BIREME - FapUNIFESP
>

You're passing an array that has a single element that is a string.
They keys in your view are just strings (no arrays). Arrays sort after
strings, and thus your startkey sorts after everything in the view.

The query you want should be something like:

http://homolog.webservices.scielo.org/scieloorg/_design/couchdb/_view/issue_id?startkey="2176-9451"&endkey="2176-9452"&inclusive_end=false

Mime
View raw message