couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "paul jobs" <webjog...@gmail.com>
Subject Re: clustering based on 2 columns
Date Mon, 22 Dec 2008 04:51:10 GMT
/invites/_view/invites/bydate?count=100&group=true&startkey=["2008-12-21"]&endkey=["2008-12-21",{}]
cool antony it works
*interesting adding ,{} from startkey or removing ,{} from endkey doesnt
work
*
/invites/_view/invites/bydate?count=100&group=true&startkey=["2008-12-21"]&endkey=["2008-12-21"]

{"rows":[{"key":["2008-12-21","animgifts"],"value":89324},{"key":["2008-12-21","anoninbox"],"value":31},{"key":["2008-12-21","areucute"],"value":699},{"key":["2008-12-21","bdayecards"],"value":13058},{"key":["2008-12-21","crushometer"],"value":263},{"key":["2008-12-21","datevalentine"],"value":639},{"key":["2008-12-21","igarden"],"value":43},{"key":["2008-12-21","luvgifts"],"value":83},{"key":["2008-12-21","newstickers"],"value":600},{"key":["2008-12-21","ownmenow"],"value":72},{"key":["2008-12-21","searchsharer"],"value":348},{"key":["2008-12-21","searchy"],"value":32},{"key":["2008-12-21","sendlovely"],"value":729},{"key":["2008-12-21","topbffs"],"value":42},{"key":["2008-12-21","ukissme"],"value":10071}]}

can you explain how this works
On Sun, Dec 21, 2008 at 8:42 PM, Antony Blakey <antony.blakey@gmail.com>wrote:

> http://127.0.0.1:5984/wtf/_view/invites/bydate
> ?group=true&startkey=[%222008-12-21%22]&endkey=[%222008-12-21%22,{}]
>
>
> {"rows":[{"key":["2008-12-21","app1"],"value":12},{"key":["2008-12-21","app2"],"value":5}]}
>
> On 22/12/2008, at 2:59 PM, paul jobs wrote:
>
>  this doesnt work
>> /invites/_view/invites/bydate?count=100&group=true&key=[%222008-12-21%22]
>>
>> {"rows":[]}
>>
>>
>>
>> On 12/21/08, Antony Blakey <antony.blakey@gmail.com> wrote:
>>
>>>
>>>
>>> On 22/12/2008, at 2:39 PM, paul jobs wrote:
>>>
>>> antony this doesnt help
>>>
>>>> Key
>>>> Value  *"2008-12-20"*17854*"2008-12-21"*114536
>>>> i get this result when i give your map-reduce view, it doesnt collate by
>>>> appnames after collating by date
>>>>
>>>>
>>> I thought you were reducing over all appnames.
>>>
>>> map:    function(doc) { emit([doc.date, doc.appname], doc.count) }
>>> query:  ...?group=true&key=["2008-12-21"]
>>>
>>> Antony Blakey
>>> -------------
>>> CTO, Linkuistics Pty Ltd
>>> Ph: 0438 840 787
>>>
>>> He who would make his own liberty secure, must guard even his enemy from
>>> repression.
>>> -- Thomas Paine
>>>
>>>
>>>
>>>
> Antony Blakey
> -------------
> CTO, Linkuistics Pty Ltd
> Ph: 0438 840 787
>
> All that is required for evil to triumph is that good men do nothing.
>
>
>

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