can you give me an example of this query and the corresponding view map function or do we need a different reduce function
On Sun, Dec 21, 2008 at 7:27 PM, Antony Blakey <[email protected]>wrote: > If you want to reduce over the appname, then that has to occur after the > date in the key. > > On 22/12/2008, at 1:47 PM, paul jobs wrote: > > *key=["","2008-12-21"] >> *or /invites/_view/invites/appdatecount?count=100&group=true& >> key=["","2008-12-21"] >> >> doesnt work either >> please point out what i m doing wrong >> >> On Sun, Dec 21, 2008 at 7:16 PM, paul jobs <[email protected]> wrote: >> >> Key >>> Value *["animgifts", "2008-12-20"]*10420*["animgifts", "2008-12-21"]* >>> 87781*["anoninbox", "2008-12-20"]*67*["anoninbox", "2008-12-21"]* >>> 31*["areucute", >>> "2008-12-20"]*434*["areucute", "2008-12-21"]* 680*["bdayecards", >>> "2008-12-20"]*3175*["bdayecards", "2008-12-21"]* 12447*["crushometer", >>> "2008-12-20"]*69*["crushometer", "2008-12-21"]* 250*["datevalentine", >>> "2008-12-20"]*166*["datevalentine", "2008-12-21"]* 635*["igarden", >>> "2008-12-20"]*16*["igarden", "2008-12-21"]* 42*["luvgifts", >>> "2008-12-20"]* >>> 72*["luvgifts", "2008-12-21"]* 81*["newstickers", >>> "2008-12-20"]*123*["newstickers", >>> "2008-12-21"]* 582*["ownmenow", "2008-12-20"]*37*["ownmenow", >>> "2008-12-21"]* 72*["searchsharer", "2008-12-20"]*57*["searchsharer", >>> "2008-12-21"]* 336*["searchy", "2008-12-21"]*16*["sendlovely", >>> "2008-12-20"]* 239*["sendlovely", "2008-12-21"]*721*["topbffs", >>> "2008-12-20"]* 40*["topbffs", "2008-12-21"]*22*["ukissme", "2008-12-20"]* >>> 2939*["ukissme", "2008-12-21"]*9484 ← Previous Page | Rows per page: 10 >>> 25 50 100 | Next Page → >>> Showing 1-29 of 29 rows >>> *map3*:function(doc) { >>> emit([doc.appname,doc.date], doc.count); } >>> *reduce*:function(keys, values) { return sum(values)} >>> >>> in this >>> /invites/_view/invites/appdatecount?count=100&group=true&key="2008-12-21" >>> >>> or >>> >>> /invites/_view/invites/appdatecount?count=100&group=true&key=["2008-12-21"] >>> >>> or >>> >>> /invites/_view/invites/appdatecount?count=100&group=true&key=[,"2008-12-21"] >>> >>> gives rows=[] >>> >>> so how 2 query on a particular date >>> >>> >>> On Sun, Dec 21, 2008 at 7:12 PM, paul jobs <[email protected]> wrote: >>> >>> how to query this for a particular say day?and is it possible to pass >>>> key >>>> arguments in the futon view interface when we run the view >>>> >>>> >>>> On Sun, Dec 21, 2008 at 4:37 PM, Antony Blakey <[email protected] >>>> >wrote: >>>> >>>> >>>>> On 22/12/2008, at 9:19 AM, paul jobs wrote: >>>>> >>>>> I want to do what map2 does but only for say "2008-12-21" ie today >>>>> >>>>>> how do i get today's statistics? >>>>>> >>>>>> >>>>> Split your date into three components and use them as the key e.g. >>>>> >>>>> [doc.appname, doc.date.year, doc.date.month, doc.date.day] >>>>> >>>>> This will allow you to get partial reduce results for just one day, or >>>>> month, or year. >>>>> >>>>> Antony Blakey >>>>> -------------------------- >>>>> CTO, Linkuistics Pty Ltd >>>>> Ph: 0438 840 787 >>>>> >>>>> Reflecting on W.H. Auden's contemplation of 'necessary murders' in the >>>>> Spanish Civil War, George Orwell wrote that such amorality was only >>>>> really >>>>> possible, 'if you are the kind of person who is always somewhere else >>>>> when >>>>> the trigger is pulled'. >>>>> -- John Birmingham, "Appeasing Jakarta" >>>>> >>>>> >>>>> >>>>> >>>> >>> > Antony Blakey > -------------------------- > CTO, Linkuistics Pty Ltd > Ph: 0438 840 787 > > Lack of will power has caused more failure than lack of intelligence or > ability. > -- Flower A. Newhouse > >
