Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: couchdb-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of sho.fukamachi@gmail.com
 designates 209.85.146.179 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:from:to:content-type:content-transfer-encoding
         :mime-version:subject:date:x-mailer;
        b=p07YIF1aSnUNCzkWXofxPWzcj79fbudSUfi+ZwyEfiDneo1Z07l7Dh8TXBbAU+lVME
         R+ClJHR9S7c2U7uNQ1q1QZo2DZoFk+K9IvyqVfoL3dIsv/WF1aXA48TAC09IwIVuNHGH
         vQ5wf5rpMDeWOiG+vlnwPUrAYsTiIsshbiZm4=
Message-Id: <E36474A8-21B6-4B77-BF7C-81378DC56D9D@gmail.com>
From: Sho Fukamachi <sho.fukamachi@gmail.com>
To: couchdb-user@incubator.apache.org
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v929.2)
Subject: dual purpose filter/count views
Date: Mon, 10 Nov 2008 08:36:46 +1100

Hi all,

This is probably a really simple question, but for some reason* I  
can't figure it out.

(* reason is most like extreme dumbness on my part)

I've got a bunch of views where i have something like this:

get_all_by_field:

map: if (doc.type == 'my_doc') emit(doc.field, doc);

count_all_by_field:

map: if (doc.type == 'my_doc') emit(doc.field, 1);
reduce: function(keys, values) { return sum(values) }

That works fine, but seems like it could be more elegant ..

I thought I'd be "clever" and try to combine the two, so I could get  
the "search" output by calling the map alone, and then getting the  
count by turning on reduce, something like this:

map: function(doc) {
   if (doc.type == 'my_doc') emit(doc.field, [doc, 1]);
     }
reduce: function(keys, values) { return sum(values[1]) }

The idea being that if i turn off reduce, it outputs the docs I want,  
but if I turn it on, I can just count the second element in the  
emitted array.

But for some reason it doesn't work. I've tried the above, just  
returning values[1], trying to sum values[0][1], etc. I either get  
errors or nothing.

This is probably some really simple thing that I'm missing in my tired  
state. Can anyone give me a hint as to what it is? : )

thanks!

Sho