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 webjogger@gmail.com
 designates 209.85.198.238 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=F+K7t8YOnVjIXYryzW3zmka3C/f95OFg3PkcjHMEy6AbcYZ4YSuM06P1EuMR9G053H
         6vdsWrrfAkyUeeJWhPlCJepFNFo8jWHIJzrr6zVtSM43DbFoxt9foN5mdZxeSTaedVos
         TWzkp5Tf1/gnAaiT+GTHokeBfiThD8QiKyfDc=
Message-ID: <4c69d7170812212051t3a12bbabh4e0d60759291c458@mail.gmail.com>
Date: Sun, 21 Dec 2008 20:51:10 -0800
From: "paul jobs" <webjogger@gmail.com>
To: user@couchdb.apache.org
Subject: Re: clustering based on 2 columns
In-Reply-To: <D2A6E962-CE9D-4248-B541-B764458ABE75@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_59451_14303158.1229921470628"
References: <4c69d7170812211449w7b36084dh2e0706ee693bdc6@mail.gmail.com>
	 <2583A30D-5B9C-4426-BCB2-4D736FDD7EAD@gmail.com>
	 <4c69d7170812211912p779b77fexf44cd213603bd4a0@mail.gmail.com>
	 <4c69d7170812211916p4f6fd16er2e45d06e5cbaa42d@mail.gmail.com>
	 <4c69d7170812211927l78457bf2hb0998e4c261e057b@mail.gmail.com>
	 <8BE1477D-84A6-45C8-A63B-0CB5F554FF63@gmail.com>
	 <4c69d7170812212009u5c0f835cr11b4fac72f7d782b@mail.gmail.com>
	 <2DEF6392-F32A-40E4-AC6F-A60350828FDD@gmail.com>
	 <4c69d7170812212029p53e3b1bep283afd328a0b209b@mail.gmail.com>
	 <D2A6E962-CE9D-4248-B541-B764458ABE75@gmail.com>

------=_Part_59451_14303158.1229921470628
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

/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.
>
>
>

------=_Part_59451_14303158.1229921470628--