Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of torsteinkrausework@gmail.com
 designates 209.85.161.180 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=dfV6IH1czAbQELZwWpd7EK6BfHGx328xQlVf/hMm5+wMK8ZVrWGUO9ERhpAqw+fAn8
         RWNvGCkB8NkREE7+z1fzRHVdk0+/2zBtJLCwYPl0mcDueS2oVfrWviDeSu3y8+5mvaJ2
         tkPx8fC5SIuw5DpWFXXgkHD8YuJzsHWrYUMlI=
Message-ID: <4DDF164A.7030009@gmail.com>
Date: Fri, 27 May 2011 11:11:06 +0800
From: Torstein Krause Johansen <torsteinkrausework@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
 rv:1.9.2.15) Gecko/20110402 Icedove/3.1.9
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: Complex queries & results
References: <4DDDFD4E.9060701@gmail.com>
 <BANLkTimxsnRiAJh=+c=YWSbYxv1ba51e_w@mail.gmail.com>
In-Reply-To: <BANLkTimxsnRiAJh=+c=YWSbYxv1ba51e_w@mail.gmail.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit

Hi all,

thanks for the great feedback.

On 26/05/11 19:26, Sean Copenhaver wrote:
> Have you tried having a map function that emits the 'a_name' as a key then a
> reduce function that uses the builtin sum(), then you query with group=true?

If I do:

emit([a_name, one_id, another_id, created_at]);

I can query it with (reduce just being the built in _count)

group=true&group_level=1

and by that get the dictionary I wanted:

{
  "Lisa" : 1
  "John" : 3
}

I know need to make the start and endkey parameters ignore the first 
element of my key as a_name is not a search parameter. I've tried with 
this search for one_id=1, another_id=2 and date between 2011-05-26 and 
2011-05-27:

startkey=[{},1,2,"2011-05-26"]&endkey=[{},1,2,"2011-05-27"]

But don't get anything returned. Am I doing this wrong? Is there a 
different way to make the view ignore the first element of the key? In 
the coucdb.log I can see that my query parameters enter Couch the way I 
intended (no BASH escaping going astray).

Cheers,

-Torstein