From user-return-10803-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Wed Jun 02 05:38:33 2010
Return-Path: <user-return-10803-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org>
Delivered-To: apmail-couchdb-user-archive@www.apache.org
Received: (qmail 417 invoked from network); 2 Jun 2010 05:38:33 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 2 Jun 2010 05:38:33 -0000
Received: (qmail 35565 invoked by uid 500); 2 Jun 2010 05:38:31 -0000
Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org
Received: (qmail 35440 invoked by uid 500); 2 Jun 2010 05:38:31 -0000
Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@couchdb.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@couchdb.apache.org>
List-Post: <mailto:user@couchdb.apache.org>
List-Id: <user.couchdb.apache.org>
Reply-To: user@couchdb.apache.org
Delivered-To: mailing list user@couchdb.apache.org
Received: (qmail 35432 invoked by uid 99); 2 Jun 2010 05:38:31 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Jun 2010 05:38:31 +0000
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=AWL,HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of Steven.Prentice@nextgen.net designates 203.18.147.131 as permitted sender)
Received: from [203.18.147.131] (HELO smtp12.NextGen.Net) (203.18.147.131)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Jun 2010 05:38:23 +0000
Received: from locutus.nextgen.net ([203.18.147.35])
          by smtp12.NextGen.Net
          with ESMTP id 2010060215380123-297405 ;
          Wed, 2 Jun 2010 15:38:01 +1000 
To: user@couchdb.apache.org
MIME-Version: 1.0
Subject: How do I SUM(values in a field array) using Views
X-KeepSent: 8D2B7CA6:4408C5AB-CA257736:001D741C;
 type=4; flags=0; name=$KeepSent
X-Mailer: Lotus Notes Release 8.0.1 February 07, 2008
Message-ID: <OF8D2B7CA6.4408C5AB-ONCA257736.001D741C-CA257736.001EF1CA@nextgen.net>
From: Steven.Prentice@nextgen.net
Date: Wed, 2 Jun 2010 15:38:00 +1000
X-MIMETrack: Serialize by Router on Locutus/NextGen Systems at 02/06/2010 03:38:01 PM,
	Serialize complete at 02/06/2010 03:38:01 PM,
	Itemize by SMTP Server on SMTP12/NextGenEXT at 02/06/2010 15:38:01,
	Serialize by Router on SMTP12/NextGenEXT at 02/06/2010 15:38:22,
	Serialize complete at 02/06/2010 15:38:22
Content-Type: multipart/alternative; boundary="=_alternative 001EF1C8CA257736_="

--=_alternative 001EF1C8CA257736_=
Content-Type: text/plain; charset="US-ASCII"

Hi say I had product documents that looked like this (formatted for 
readability):

{
"_id":"p9",
"_rev":"2-9a109fb7d9f116441876e0d6401ec1ba",
"product_name":"Apple iPhone 3Gs 32GB",
"Stores":[
                {
                 "name":"Store A",
                 "item_count":558
                },
                {
                 "name":"CompuShop",
                 "item_count":4878
                },
                {
                 "name":"Kerry's Computer Shop",
                 "item_count":54474
                }
            ]
}

and a view function:
function(doc)
{
  for (id in doc.Stores)
  {
    if(doc.product_name && doc.Stores[id].item_count)
    { 
      emit(doc.product_name, doc.Stores[id].item_count);
    }
  } 
}

and a reduce function:
function(keys, values) {
   return sum(values);
}

Why, when I look at the resulting view in Futon does it look correct but 
when I view in browser it gives me a null key and a total of all items as 
opposed to one for each product? Or if I specify a product using ?key= , 
why do i still get key:null 

.../_design/inventory/_view/total_items
{"rows":[
{"key":null,"value":8452613}
]}


--=_alternative 001EF1C8CA257736_=--