From user-return-19486-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Fri Jan 13 20:17:14 2012 Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 396D99FAF for ; Fri, 13 Jan 2012 20:17:14 +0000 (UTC) Received: (qmail 25116 invoked by uid 500); 13 Jan 2012 20:17:12 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 25052 invoked by uid 500); 13 Jan 2012 20:17:11 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 25044 invoked by uid 99); 13 Jan 2012 20:17:11 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jan 2012 20:17:11 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [209.85.210.52] (HELO mail-pz0-f52.google.com) (209.85.210.52) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Jan 2012 20:17:07 +0000 Received: by dadv6 with SMTP id v6so710786dad.11 for ; Fri, 13 Jan 2012 12:16:46 -0800 (PST) Received: by 10.68.116.234 with SMTP id jz10mr4227699pbb.84.1326485806208; Fri, 13 Jan 2012 12:16:46 -0800 (PST) MIME-Version: 1.0 Received: by 10.68.42.228 with HTTP; Fri, 13 Jan 2012 12:16:25 -0800 (PST) In-Reply-To: References: From: Jamie Talbot Date: Fri, 13 Jan 2012 12:16:25 -0800 Message-ID: Subject: Re: View key query To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Martin, I think this is because 18 (as your fourth key component) is between 0 (in your startKey) and 23 (in your endKey). Cheers, Jamie. On Fri, Jan 13, 2012 at 12:11, Martin Hewitt wrote: > Hi all, > > I've been banging my head against the wall with this for ages, can someon= e enlighten me as to why a view entry with the key: > > key: [ > =A0 =A0 =A0 =A0 2012, > =A0 =A0 =A0 =A0 1, > =A0 =A0 =A0 =A0 13, > =A0 =A0 =A0 =A0 18, > =A0 =A0 =A0 =A0 "theme", > =A0 =A0 =A0 =A0 "observed", > =A0 =A0 =A0 =A0 "Radio Page" > ] > > Is returned with the query parameters: > > startkey=3D[2012,1,13,0,"metric","31214616cc684011f9e9ea1df9020114"] > > endkey=3D[2012,1,13,23,"metric","31214616cc684011f9e9ea1df9020114",{}] > > An example of the key I'm looking for is: > > key: [ > =A0 =A0 =A0 =A0 2012, > =A0 =A0 =A0 =A0 1, > =A0 =A0 =A0 =A0 13, > =A0 =A0 =A0 =A0 18, > =A0 =A0 =A0 =A0 "metric", > =A0 =A0 =A0 =A0 "31214616cc684011f9e9ea1df9020114", > =A0 =A0 =A0 =A0 16 > ] > > Any help hugely appreciated, thanks! > > Martin --=20 --- http://jamietalbot.com