Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: error (athena.apache.org: local policy)
Message-ID: <51E6E32E.4070903@bardubitzki.com>
Date: Wed, 17 Jul 2013 11:32:14 -0700
From: Stephan Bardubitzki <stephan@bardubitzki.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130623 Thunderbird/17.0.7
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: View Collation
References: <51E6DFAD.4040009@bardubitzki.com>
 <CABvT1DHiJQE8Uf+ff35+2yTVtLS4RiNxVfBMRP1XMtTgGDSJig@mail.gmail.com>
In-Reply-To: 
 <CABvT1DHiJQE8Uf+ff35+2yTVtLS4RiNxVfBMRP1XMtTgGDSJig@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

The third element in the startkey is the number property to be sorted. 
Here is my map function:

function(doc) {
     if (doc.kml_id && doc.marker && doc.language) {
         for (language in doc['language']) {
             var o = {};
             o.description = doc.language[language];
             o.gps = doc.gps;
             emit([language, doc.kml_id, doc.marker], o);
         }
     }
}

On 13-07-17 11:21 AM, Robert Newson wrote:
> Use start key of ["fr",id]
> On 17 Jul 2013 19:18, "Stephan Bardubitzki" <stephan@bardubitzki.com> wrote:
>
>> In my docs I have a Number property starting at 0. My start/end key looks
>> like this:
>>
>> startkey: ["fr", id, 0]. endkey: ["fr", id, {}]
>>
>> to sort the response by this property. It seems to work well, however, the
>> doc with the property value=0 is omitted.
>>
>> I presume the view collation for numbers is starting at 1?
>>
>>
>>
>>
>>
>>
>>
> --------------------------------
> Spam/Virus scanning by CanIt Pro
>
> For more information see
> http://www.kgbinternet.com/SpamFilter.htm
>
> To control your spam filter, log in at
> http://filter.kgbinternet.com
>