From couchdb-user-return-1412-apmail-incubator-couchdb-user-archive=incubator.apache.org@incubator.apache.org Thu Oct 02 03:12:47 2008 Return-Path: Delivered-To: apmail-incubator-couchdb-user-archive@locus.apache.org Received: (qmail 126 invoked from network); 2 Oct 2008 03:12:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Oct 2008 03:12:46 -0000 Received: (qmail 85904 invoked by uid 500); 2 Oct 2008 03:12:44 -0000 Delivered-To: apmail-incubator-couchdb-user-archive@incubator.apache.org Received: (qmail 85877 invoked by uid 500); 2 Oct 2008 03:12:44 -0000 Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: couchdb-user@incubator.apache.org Delivered-To: mailing list couchdb-user@incubator.apache.org Received: (qmail 85866 invoked by uid 99); 2 Oct 2008 03:12:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Oct 2008 20:12:44 -0700 X-ASF-Spam-Status: No, hits=2.1 required=10.0 tests=DNS_FROM_RFC_BOGUSMX,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of ben@groovie.org designates 85.10.207.234 as permitted sender) Received: from [85.10.207.234] (HELO unicron.groovie.org) (85.10.207.234) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Oct 2008 03:11:42 +0000 Received: from c-71-202-164-208.hsd1.ca.comcast.net ([71.202.164.208] helo=Shaggy.home.groovie.org) by unicron.groovie.org with esmtpsa (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.69) (envelope-from ) id 1KlEbu-00036t-90 for couchdb-user@incubator.apache.org; Wed, 01 Oct 2008 20:12:15 -0700 Message-Id: From: Ben Bangert To: couchdb-user@incubator.apache.org In-Reply-To: Content-Type: multipart/signed; boundary=Apple-Mail-20--203209157; micalg=sha1; protocol="application/pkcs7-signature" Mime-Version: 1.0 (Apple Message framework v929.2) Subject: Re: Associating users and comments Date: Wed, 1 Oct 2008 20:12:06 -0700 References: <2098F155-ECB7-468E-8CA7-8E54F18EE606@groovie.org> <5152C024-ACC0-4FF7-AB45-171C0B2311EC@groovie.org> <16E99800-645D-4009-B499-7C94D71A4D92@groovie.org> X-Mailer: Apple Mail (2.929.2) X-Spam-Score: -2.6 (--) X-Spam-Report: Spam detection software, running on the system "unicron.groovie.org", has identified this incoming email as possible spam. The original message has been attached to this so you can view it (if it isn't spam) or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: On Oct 1, 2008, at 8:00 PM, Chris Anderson wrote: > http://wiki.apache.org/couchdb/Views > > The reduce docs are somewhat lacking... I did read those.... let me be more specific, I have a few documents with key/value pairs like so: [...] Content analysis details: (-2.6 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- 1.5 DNS_FROM_RFC_BOGUSMX RBL: Envelope sender in bogusmx.rfc-ignorant.org -1.8 ALL_TRUSTED Passed through trusted hosts only via SMTP -2.6 BAYES_00 BODY: Bayesian spam probability is 0 to 1% [score: 0.0000] 0.3 AWL AWL: From: address is in the auto white-list X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-20--203209157 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit On Oct 1, 2008, at 8:00 PM, Chris Anderson wrote: > http://wiki.apache.org/couchdb/Views > > The reduce docs are somewhat lacking... I did read those.... let me be more specific, I have a few documents with key/value pairs like so: _id "097337c75773737022bb4e8cd3a92140" _rev "3161423366" created "2008-10-01T19:40:25Z" last_login "2008-10-01T19:40:25Z" name "Joe" type "Human" _id "3fefb1f90316b029b7937c01964e4fd8" _rev "2184850695" created "2008-10-01T19:40:25Z" last_login "2008-10-01T19:40:25Z" name "Fred Smith" type "Human" username "fsmith" _id "dd7d49e84929231c4384216e8dfbb133" _rev "1337790890" code "This is a sample" created "2008-10-01T19:40:25Z" human_id "097337c75773737022bb4e8cd3a92140" language "text" title "Sample 1" type "Paste" Now, I can easily use the view collation to have a list of all the users and their 'Paste's that go with them, no prob. I get how the keys influence sort and such by having a map function like so (to get me the info I want for each one): function(doc) { if (doc.type == 'Human') { emit([doc._id, 0], {type:doc.type, name:doc.name}) } else if (doc.type == 'Paste') { emit([doc.human_id, 1], doc); } } Now, how would I filter this list, so that I don't get all the Humans with zero paste's filed for them? Ie, I only want the human row in the result set if there's going to be a Paste type row following it. Alternatively, how would I have it return only 5 Paste's max for each user? Thanks, Ben --Apple-Mail-20--203209157 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGfTCCAzYw ggKfoAMCAQICEClzcfApE1Xl0tE8fQf6InIwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDUyMzIyMDUzNVoXDTA5MDUyMzIyMDUz NVowZjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEjMCEGCSqGSIb3DQEJARYUYmJh bmdlcnRAZ3Jvb3ZpZS5vcmcxHjAcBgkqhkiG9w0BCQEWD2JlbkBncm9vdmllLm9yZzCCASIwDQYJ KoZIhvcNAQEBBQADggEPADCCAQoCggEBAMAxyJSHPp0a6b6jg37ULZHv6Vh+ZthZh0LIACrEkeDU KT2Gop2+h7wuoZNRSOLGSijSuMmYL9whUZmDLefzwkU8/yL7Ya6dh+QE3L0TM2nGqhF1v6/uzQaN cYukSeWkRMx2QrRGpu5npDWUsMN8vKMziDlVpjpQKDfnupVFa34vhWpavJliaDh4KbPBBfesR3Xg wEdgwOmhfL/lgDNdO8SHtZ3+s/ysf095eM5b2IP+kLyF2t/NOFTA3zIWbjOAIGyyxyt7J2x1oEAT 1VlATLQ0+DQhh4UZS/PIJpJsOGxttjfqKTTbXivBDDUEq843wz4L0X5YZlv4ky8vAj1bolsCAwEA AaNlMGMwDgYDVR0PAQH/BAQDAgP4MBEGCWCGSAGG+EIBAQQEAwIFIDAwBgNVHREEKTAngRRiYmFu Z2VydEBncm9vdmllLm9yZ4EPYmVuQGdyb292aWUub3JnMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcN AQEFBQADgYEAArp/WahHEAzWmCz+VUX1PmjwbxRTy9T0z6Z52EUbvrU9mnOPHTC0hgHXYzMtEKW5 8apV7CnoHyFucbYfqJi+R3xx+4x5M7e+Oj+7JWhxjKH+aXsL1eI1ialOenSDq9VKhyUuF2lCrFIm fTsG+h02NRZyMYQ/OskM0ReNFALAEygwggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHR MQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24x GjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZp Y2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkq hkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcN MTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0Ew gZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb 8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9 A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYD VR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20v VGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwx GjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2j ZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4l UJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9d X2VPMYIDEDCCAwwCAQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRp bmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vpbmcg Q0ECEClzcfApE1Xl0tE8fQf6InIwCQYFKw4DAhoFAKCCAW8wGAYJKoZIhvcNAQkDMQsGCSqGSIb3 DQEHATAcBgkqhkiG9w0BCQUxDxcNMDgxMDAyMDMxMjA3WjAjBgkqhkiG9w0BCQQxFgQU2Cn6Y8dn OXr3DFwclkTNMBl1gaIwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoT HFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG cmVlbWFpbCBJc3N1aW5nIENBAhApc3HwKRNV5dLRPH0H+iJyMIGHBgsqhkiG9w0BCRACCzF4oHYw YjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAq BgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhApc3HwKRNV5dLRPH0H +iJyMA0GCSqGSIb3DQEBAQUABIIBAHpE8c0flDp1M9efLih89oo5ip3t9P5sZYbomCTJPvI1RoeW P787XCBCRTAPS4mkuJQMcEzNll2byXzdWxdzC1ams0DiksurZ6Sbm+AhWDqLdzGaA4shx+lqssfD C8UNphM4CshMPRbeFXDAzC38Rh9bKVdeT497Uy2ENOMwAqTZ0LH4/m3Jk9vR1cZGCB9Nzd2P1v2L dKRwKRJMsQR//D16g+HD+8VUPFQ0KJMZZ/AL+YBCrW+8a/Di3ceOFNsXg01YvKm22e69ZU9Uwn0d sBuRtrc0CSIYsWqCAmoEn2KOgIUCFnlASP/BbFnvJ8cHzQyMoPDlrqVszgb1RiQoeqYAAAAAAAA= --Apple-Mail-20--203209157--