Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
Date: Wed, 23 Feb 2011 14:54:42 -0300
Message-ID: <AANLkTikDc4yAitdd42FK5TXx5JzpiOzSzjLvx0DR2=wO@mail.gmail.com>
Subject: startkey and endkey problems
From: Fabio Batalha Cunha dos Santos <fabio.batalha@scielo.org>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=0016e64ccd4ca56288049cf6caf9

--0016e64ccd4ca56288049cf6caf9
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e64ccd4ca56288049cf6caf9--