Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of paul.joseph.davis@gmail.com
 designates 209.85.160.180 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type:content-transfer-encoding;
        b=w0695SR+MWOCvp8iQc08SERtxanbjBdh7AS4xR13RDmoBqlQUFaqNO/Q73pY0m+QCI
         CYfW3krgN7Yc2QTTM7ixJjftZhgFC75qzvrFI6gAczSEwrRXUDveuf8V6bPcngLrg6di
         ak1McCdLtBepfiMRi8w9xbcjSt3n2Krh3EmJk=
MIME-Version: 1.0
In-Reply-To: <4CCEF12B.8060508@free.fr>
References: <4CCEF12B.8060508@free.fr>
From: Paul Davis <paul.joseph.davis@gmail.com>
Date: Mon, 1 Nov 2010 13:10:03 -0400
Message-ID: <AANLkTinmeO77hE1NCptKzbNXj4dX3fNXdemA4rmDKye-@mail.gmail.com>
Subject: Re: Complex keys and ranges
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Mon, Nov 1, 2010 at 12:56 PM, cdr53x <cdr53x@free.fr> wrote:
> Hello,
>
> I've read all the docs/wiki again but cannot find anything related to vie=
ws
> usage when keys are complex JSON objects.
>
> Especially, there are no explanations nor examples of how the ranges (
> startkey/endkey ) are supposed to behave with complex keys.
>
> For instance let's presume we have the a view with the following map
> function :
>
> function(doc) {
> =A0 =A0...
> =A0 =A0emit({ 'date' : created_at =A0, 'author' : author}, null) ;
> }
>
>
> Would it be possible to "filter" on both date and author ?
>
> For instance get all the docs created in a given time range by a given
> author , by passing a range like =A0:
>
> =A0start_key : { 'date' : '201002030000.' , author : 'adams' }
> =A0end_key =A0 : { 'date' : '201003030000.' , author : 'adams' }
>
> ?
>
> I have tried this however it does not seem to work that way, so if anyone
> has some info on how this should work, I'd really appreciate
>
> Thanks in advance,
>
> cdrx
>

View collation is specified here:
http://wiki.apache.org/couchdb/View_collation#Collation_Specification


In short, no, its not possible to filter on multiple members of an
object key. Generally speaking you shouldn't use object keys as they
can lead to confusing behavior that is dependent on the various JSON
libraries used for serialization. If you need complex keys its
generally best to stick to Arrays as their sorting behavior easier to
reason about.

HTH,
Paul Davis