Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of robert.newson@gmail.com
 designates 209.85.161.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=f2I+nNmx7MAmKVz1k2Utjyq3AVcnidQz6M1D0OuR9pkyRc1bH/vEa+ww9Wrhyj1OMM
         f3uHyLFNO1JtjkEB68k5g+1pHaOes4ggBXxfczD+is8ZM7/MUyXrqG71tXJI5YWjhiRr
         w5aANap3mKPjs1KUG+p8E2i/s/mNKVRDVsxe0=
MIME-Version: 1.0
In-Reply-To: <AANLkTimh2P50Dj929hdiBv2T5k1SfB8LoHcAEwhsPGVM@mail.gmail.com>
References: <AANLkTin23lmo1PGZTCZDEvmKuY6kXJS8fFrAPLtAyqFX@mail.gmail.com>
	<AANLkTimo846jfV9azf6pBmBS6DYt-tCiyUeniAg2c57G@mail.gmail.com>
	<AANLkTinjJ2wA78dkujnTbBGYYkzO5VB15wCMlqP9Yetv@mail.gmail.com>
	<AANLkTimh2P50Dj929hdiBv2T5k1SfB8LoHcAEwhsPGVM@mail.gmail.com>
Date: Thu, 1 Jul 2010 21:49:16 +0100
Message-ID: <AANLkTimdmDu00MI7RMKWbDspk-MoOKYM6HtASDgVcplF@mail.gmail.com>
Subject: Re: Newbie Question about View's Startkey Match
From: Robert Newson <robert.newson@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Afshin,

Unfortunately, none of your four assumptions are correct.

CouchDB supports key and key range lookup only, there is no syntax for
"match all arrays" or "match all objects".

What you have probably seen is this trick;

?startkey=["foo"]&endkey=["foo",{}]

which, in most circumstances, selects all array keys where the first
item is a string of "foo". This works because shorter arrays sort
before longer arrays and {} (empty object) sorts later than any
possible string.

As Zachary pointed out above, the view collation is described at
http://wiki.apache.org/couchdb/View_collation.

B.

On Thu, Jul 1, 2010 at 9:30 PM, Zachary Zolton <zachary.zolton@gmail.com> wrote:
> Afshin,
>
> Well, if you want to just get a certain "slice" of a view's key space,
> you'll want to use both the startkey and endkey parameters.
>
> For instance, if you just want all the view rows where the key
> contains an array, try this:
>
> startkey=[]&endkey={}
>
> Any array value (e.g. ["foo"] or ["foo","bar"]) will collate at or
> after the empty array (i.e. []), and since in this example you don't
> want any object keys coming through we stop at the empty object (i.e.
> {}).
>
> Is this any clearer?
>
> -Zach
>
> On Thu, Jul 1, 2010 at 3:04 PM, afshin afzali <a.afzali2003@gmail.com> wrote:
>> Thank you, I've saw this page already. My question is based on that page.
>> Are you confirm my assumtions ?
>>
>>
>>
>>
>> On Fri, Jul 2, 2010 at 12:26 AM, Zachary Zolton <zachary.zolton@gmail.com>wrote:
>>
>>> Here's the overall ordering of collation:
>>> http://wiki.apache.org/couchdb/View_collation#Collation_Specification
>>>
>>> On Thu, Jul 1, 2010 at 2:31 PM, afshin afzali <a.afzali2003@gmail.com>
>>> wrote:
>>> > Hi Guys,
>>> >
>>> > These are some simple assumptions which I would be confirmed when using
>>> in
>>> > startkey param:
>>> >
>>> > 1) {} matches all object keys ( including {} )
>>> > 2) [] matches all array keys (including [] )
>>> > 3) "" (null string) matches all string keys (including "")
>>> > 4) {} at the end of complex key matches all of remained ones
>>> >
>>> > BEST
>>> > -- afshin
>>> >
>>>
>>
>