couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Davis <paul.joseph.da...@gmail.com>
Subject Re: startkey
Date Tue, 16 Jul 2013 02:00:36 GMT
A couple examples might be something like:

All rows for French:

startkey: ["fr"]
endkey: ["fr",{}]

All rows for a specific kml_id:

starkey: ["fr", id]
endkey: ["fr", id, {}]



On Mon, Jul 15, 2013 at 8:58 PM, Paul Davis <paul.joseph.davis@gmail.com>wrote:

> Exactly like that yeah.
>
>
> On Mon, Jul 15, 2013 at 8:55 PM, Stephan Bardubitzki <
> stephan@bardubitzki.com> wrote:
>
>> Thanks for your response Paul. I think I'm missing something important.
>> How do I tell the view that I just need fr - language and not en, de, es ...
>>
>> startkey: ["fr", id, 0] ?
>>
>>
>>
>> On 13-07-15 03:26 PM, Paul Davis wrote:
>>
>>> You'll need to add an element to the key to emit the language. Pseudo
>>> code:
>>>
>>> for language in doc["languages"]:
>>>       emit([language, doc.kml_id, doc.marker], 1)
>>>
>>> Also note that its generally not a good idea to emit the doc as the
>>> value.
>>> You should prefer to use include_docs=true in the query string. Emitting
>>> 1
>>> allows you to specify "_sum" as a reduce function to get row counts for
>>> specific start/end key pairs.
>>>
>>>
>>> On Mon, Jul 15, 2013 at 5:07 PM, Stephan Bardubitzki <
>>> stephan@bardubitzki.com> wrote:
>>>
>>>  Hi there,
>>>>
>>>> this map function
>>>>
>>>> "map": "function(doc) { if (doc.kml_id && doc.marker) {
>>>> emit([doc.kml_id,
>>>> doc.marker], doc) } }"
>>>>
>>>> and this startkey
>>>>
>>>> startkey: [id, 0]    --> sorting doc.marker
>>>>
>>>> let me retrieve data from a couch as needed.
>>>>
>>>> Now I got the task to add more languages beside English for description
>>>> properties in an array structure like this
>>>>
>>>> "language": [
>>>>      {
>>>>          "en":{
>>>>
>>>>                  }
>>>>      },
>>>>      {
>>>>           "fr": {
>>>>
>>>>                   }
>>>>      }
>>>> ]
>>>>
>>>> I stuck in figuring out a startkey that let me retrieve the sorted data
>>>> only for a particular language.
>>>>
>>>> Any advice would be really appreciated.
>>>>
>>>> Thanks,
>>>> Stephan
>>>>
>>>>
>>>>  ------------------------------**--
>>> Spam/Virus scanning by CanIt Pro
>>>
>>> For more information see
>>> http://www.kgbinternet.com/**SpamFilter.htm<http://www.kgbinternet.com/SpamFilter.htm>
>>>
>>> To control your spam filter, log in at
>>> http://filter.kgbinternet.com
>>>
>>>
>>
>

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