couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ryan Richins <richi...@mac.com>
Subject How to query multi item key
Date Tue, 08 Sep 2009 18:24:56 GMT
Hi,

I have been trying to figure out the right way to query a multi item  
key but have not had any luck.

Given the following set of data:

{"key":["27.0.0.1","2009/08/12 18:37:06 +0000"],"value":null},
{"key":["12.0.0.1","2009/08/13 02:29:57 +0000"],"value":null},
{"key":["17.0.0.1","2009/08/14 21:25:27 +0000"],"value":null},
{"key":["31.0.0.1","2009/08/15 02:54:03 +0000"],"value":null},
{"key":["11.0.0.1","2009/08/16 08:35:15 +0000"],"value":null},
{"key":["12.0.0.1","2009/08/17 19:21:59 +0000"],"value":null}

If I want all of the IP's in a given date range (2009/08/13 -  
2009/08/16) what is the right way to construct the query?  The hang-up  
is trying to figure out the right value for the first item in the key  
to act as a '*'
Below are a few of the following I have tried but none of which work.
http://localhost:5984/foo/_design/test/_view/by_ip_and_created_at?startkey= 
[null,"2009/08/13"]&endkey=[null,"2009/08/16"]
http://localhost:5984/foo/_design/test/_view/by_ip_and_created_at?startkey= 
[null,"2009/08/13"]&endkey=[{},"2009/08/16"]
http://localhost:5984/foo/_design/test/_view/by_ip_and_created_at?startkey= 
[{},"2009/08/13"]&endkey=[{},"2009/08/16"]
http://localhost:5984/foo/_design/test/_view/by_ip_and_created_at?startkey= 
["","2009/08/13"]&endkey=["","2009/08/16"]

Thanks,
Ryan


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message