From user-return-19402-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Sat Jan 7 22:22:50 2012 Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 947DC908F for ; Sat, 7 Jan 2012 22:22:50 +0000 (UTC) Received: (qmail 87050 invoked by uid 500); 7 Jan 2012 22:22:49 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 86823 invoked by uid 500); 7 Jan 2012 22:22:47 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 86815 invoked by uid 99); 7 Jan 2012 22:22:47 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jan 2012 22:22:47 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [88.198.36.132] (HELO mail.p3k.org) (88.198.36.132) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Jan 2012 22:22:39 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.p3k.org (Postfix) with ESMTP id ED3A883622A for ; Sat, 7 Jan 2012 23:22:14 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at p3k.org Received: from mail.p3k.org ([127.0.0.1]) by localhost (hezze.p3k.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id M2kCCjUOrjOZ for ; Sat, 7 Jan 2012 23:22:12 +0100 (CET) Received: from macke.silveradsl (vie-188-118-252-144.dsl.sil.at [188.118.252.144]) (using TLSv1 with cipher ECDHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: tobi) by mail.p3k.org (Postfix) with ESMTPSA id 6BB0B83607E for ; Sat, 7 Jan 2012 23:22:12 +0100 (CET) From: =?iso-8859-1?Q?Tobi_Sch=E4fer?= Mime-Version: 1.0 (Apple Message framework v1251.1) Content-Type: multipart/signed; boundary="Apple-Mail=_44B71043-7DA3-4FB4-A082-7032A7D24D9C"; protocol="application/pkcs7-signature"; micalg=sha1 Subject: Re: Newbie question: How to collate sum() with other properties Date: Sat, 7 Jan 2012 23:22:11 +0100 In-Reply-To: To: user@couchdb.apache.org References: <37E896DC-095B-4AAA-AA5C-67AAE7C3B46D@p3k.org> Message-Id: X-Mailer: Apple Mail (2.1251.1) --Apple-Mail=_44B71043-7DA3-4FB4-A082-7032A7D24D9C Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 thanks for your suggestion, zach! i am delighted to hear that issuing two requests is not despised. nevertheless, just for the sake of fully understanding map/reduce in = couchdb, i read your reply as although it might be a mess of code and = counter-intuitive it is possible and it would work=85 is that correct? best regards, tobi On 06.01.2012, at 18:57, Zachary Zolton wrote: > Tobi, >=20 > You probably can somehow cram all that stuff together via the reduce > function, but you miss out on being able to use the built in _count > reduction and it'll take a mess of code. >=20 > I think you're better off trying to retrieve this information in two > queries: first query for the names and IDs of the polls and then do a > second query for the count of choices of those poll IDs. >=20 >=20 > Cheers, >=20 > Zach --Apple-Mail=_44B71043-7DA3-4FB4-A082-7032A7D24D9C Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIF/DCCBfgw ggPgoAMCAQICAwkAojANBgkqhkiG9w0BAQUFADB5MRAwDgYDVQQKEwdSb290IENBMR4wHAYDVQQL ExVodHRwOi8vd3d3LmNhY2VydC5vcmcxIjAgBgNVBAMTGUNBIENlcnQgU2lnbmluZyBBdXRob3Jp dHkxITAfBgkqhkiG9w0BCQEWEnN1cHBvcnRAY2FjZXJ0Lm9yZzAeFw0xMDA4MDQwODU4NTNaFw0x MjA4MDMwODU4NTNaMIG7MRUwEwYDVQQDFAxUb2JpIFNjaORmZXIxIDAeBgkqhkiG9w0BCQEWEWlu dGVyZmFjZUBwM2sub3JnMSQwIgYJKoZIhvcNAQkBFhVtYWlsQHRvYmlzY2hhZWZlci5jb20xIDAe BgkqhkiG9w0BCQEWEXRvYmlAYW50dmlsbGUub3JnMRswGQYJKoZIhvcNAQkBFgxtYWlsQHAzay5v cmcxGzAZBgkqhkiG9w0BCQEWDHRvYmlAcDNrLm9yZzCCASIwDQYJKoZIhvcNAQEBBQADggEPADCC AQoCggEBALibbHuFOASaHZ5MRPM2ltpHlVFuA/om68QDj6d58nZRzBic7txPp0MBOVvtr1kbqlO0 634JYK3gUO6JgAUJFCNWIE+a2PV8TfhT5jmdNkoTLzWD55uZcYAtx8QwZpGZ1fOjaJt5jPitQJkd YBQLXhWAQf9jERcGA+G+XCCgFeqs2dPxd7Ghthuf8hrHotTiZ4P98llqyoVH4CwgdpFFkFQmhs42 ioKaN2IP+rMNIe1n9Z2CvzMerL38cxOE0SXlDrL/aDvjE6AXMNDL8jKe9MRRCdV+YyS1GAITpkXg fSCg6YhXamjiS9qtogXpX45/U4N3PINStl23/5TJMaf9aA8CAwEAAaOCAUQwggFAMAwGA1UdEwEB /wQCMAAwVgYJYIZIAYb4QgENBEkWR1RvIGdldCB5b3VyIG93biBjZXJ0aWZpY2F0ZSBmb3IgRlJF RSBoZWFkIG92ZXIgdG8gaHR0cDovL3d3dy5DQWNlcnQub3JnMEAGA1UdJQQ5MDcGCCsGAQUFBwME BggrBgEFBQcDAgYKKwYBBAGCNwoDBAYKKwYBBAGCNwoDAwYJYIZIAYb4QgQBMDIGCCsGAQUFBwEB BCYwJDAiBggrBgEFBQcwAYYWaHR0cDovL29jc3AuY2FjZXJ0Lm9yZzBiBgNVHREEWzBZgRFpbnRl cmZhY2VAcDNrLm9yZ4EVbWFpbEB0b2Jpc2NoYWVmZXIuY29tgRF0b2JpQGFudHZpbGxlLm9yZ4EM bWFpbEBwM2sub3JngQx0b2JpQHAzay5vcmcwDQYJKoZIhvcNAQEFBQADggIBAIi3eQR66tt96MnO 0tDTwTjGfB5SukJFEWuwLlX2guK0hzmrDvUVePCr+s1hIssU1sbRPPEWiO7Rm0yCkGc/PTrpE8FD M2ufeGp3APSjwkS1CYe4Lm3Q/MTOj6ux6O7iS0w13lIuDm0eDrwaa3P6d6N+fd7jEWy+nj4zoB8A TVULG8RhHtjZSXb74tCxNz455DuC3oQt74cWJl8auRl/buOXHIhYWmCXQE3SRHNabDv2F88hlHyM aDkwwjYLEUwL1K5IBCkRctoWrLLb3M6aC4g3KEQy9ocpXRQFjb6gqDGyVGCSmxM3+FNgigQ+mVQi pW892cLetYTP80idg3+QETJyHTM9ZC314MDa/0sjP6icRlgbbfZwMestfL6CiD/fNW0zJfBk/sZL RzXcE3BUH0nnrsEue0ddvVG7/Z8Sfmgbhj8+uMO/BUgYbix3FxIyWQIBkY+sa7L8lV+W/juyTA2H Z6G9VEdfYDA1Ho9kYnZKYXKBTDcBgoiGJSbL2njZm562HIbv0CgFtiHK2IgeqiPk+wt+f0JxbAP1 IO3IpG5tFgX9/BKwJjmcuibn0gKvBK9n4+G9HUIw6M9XGKmyIplFlk/aSGc/2eYdRQ8oZrStrIoD 7DY87oJ+8PRUaB+wi4FdTTW9dwUGcsYAHDuVaJLM2XY6jh+8riTGHCQE/DTRMYIDMzCCAy8CAQEw gYAweTEQMA4GA1UEChMHUm9vdCBDQTEeMBwGA1UECxMVaHR0cDovL3d3dy5jYWNlcnQub3JnMSIw IAYDVQQDExlDQSBDZXJ0IFNpZ25pbmcgQXV0aG9yaXR5MSEwHwYJKoZIhvcNAQkBFhJzdXBwb3J0 QGNhY2VydC5vcmcCAwkAojAJBgUrDgMCGgUAoIIBhzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcB MBwGCSqGSIb3DQEJBTEPFw0xMjAxMDcyMjIyMTFaMCMGCSqGSIb3DQEJBDEWBBSPlwi6vRcKsIpP HDUxuwEtNHSe7DCBkQYJKwYBBAGCNxAEMYGDMIGAMHkxEDAOBgNVBAoTB1Jvb3QgQ0ExHjAcBgNV BAsTFWh0dHA6Ly93d3cuY2FjZXJ0Lm9yZzEiMCAGA1UEAxMZQ0EgQ2VydCBTaWduaW5nIEF1dGhv cml0eTEhMB8GCSqGSIb3DQEJARYSc3VwcG9ydEBjYWNlcnQub3JnAgMJAKIwgZMGCyqGSIb3DQEJ EAILMYGDoIGAMHkxEDAOBgNVBAoTB1Jvb3QgQ0ExHjAcBgNVBAsTFWh0dHA6Ly93d3cuY2FjZXJ0 Lm9yZzEiMCAGA1UEAxMZQ0EgQ2VydCBTaWduaW5nIEF1dGhvcml0eTEhMB8GCSqGSIb3DQEJARYS c3VwcG9ydEBjYWNlcnQub3JnAgMJAKIwDQYJKoZIhvcNAQEBBQAEggEAgW2qQdFyCgz6cwm/3gNc OrVegjLhcb4Cdr5Dr0izTYfZaQ9R6MZ+lfJYe2Pd1ivUaosRsA7TNJYyHEMuVnIPdoOOBID/i0Gh HF7o6Mhax+290YDE3FpbmV/2R+aDwLPN12nh1z12os/fQgnWrsgtEjtxSycGCKnGlFaywVwdwylQ yNXk4OGBPIHifn47/SFWMnirE4TaE8QXJoQQN/3se+S1InzvwBwZ09I85LItQT4qGDioxP6VEFPa QcQQSZKfWMc2JnbWrc7vM2zBPRpWZvR5PrBM5IEVqUTdSMYRI9EoM9m7dUWuAX5kwcux1pLSvkmx IRcKs+ziQTrYC6H3hgAAAAAAAA== --Apple-Mail=_44B71043-7DA3-4FB4-A082-7032A7D24D9C--