Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 42100 invoked from network); 16 Oct 2010 11:37:47 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 16 Oct 2010 11:37:47 -0000 Received: (qmail 19465 invoked by uid 500); 16 Oct 2010 11:37:45 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 19251 invoked by uid 500); 16 Oct 2010 11:37:43 -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 19243 invoked by uid 99); 16 Oct 2010 11:37:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 16 Oct 2010 11:37:41 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of robert.newson@gmail.com designates 209.85.216.52 as permitted sender) Received: from [209.85.216.52] (HELO mail-qw0-f52.google.com) (209.85.216.52) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 16 Oct 2010 11:37:36 +0000 Received: by qwb7 with SMTP id 7so1000187qwb.11 for ; Sat, 16 Oct 2010 04:37:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:content-type; bh=WPiGQtxLA/BeiRYJjJqpSH5oJBrRMZIayi53PYQi++g=; b=Km6D9NsiiLArIiLfMtR24CX0ADeUuEaZL55KRBMsAZDQ902c8ACeQIrtkpXk7xe4/K ymTJL1qJOFnId9Qu7RcO1D1HvenFE3hZpP5VTUrNIZ+sUi1BfJrx21g7WJOD3NYye9NX V/N53J6FYb0oy5qx01O6Qhg4Tq10TuNtmew34= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=d33bb8rv96CrrQ3VAR/NrvcbTPTlhdmzLAeWLjfOvAHzLjpSdZcG2Dph35h7lS0/7J 3ShKeCujs7LNlg/0Cj1YYCK1L3KKxqMrUU7nl8oewwRrcq29lLOvJ1rAmoUxNpH8jcPn jYpzKi9AkCk9cDkTGJlFUHbqZOF2VDMd1fKuk= MIME-Version: 1.0 Received: by 10.229.185.137 with SMTP id co9mr1739024qcb.189.1287228600768; Sat, 16 Oct 2010 04:30:00 -0700 (PDT) Received: by 10.229.212.78 with HTTP; Sat, 16 Oct 2010 04:30:00 -0700 (PDT) In-Reply-To: References: Date: Sat, 16 Oct 2010 12:30:00 +0100 Message-ID: Subject: Re: A question about compound keys From: Robert Newson To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 It's startkey and endkey not start_key and end_key :) B. On Sat, Oct 16, 2010 at 12:02 PM, Tracy Flynn wrote: > Any help is appreciated. > > I know I'm missing something basic. > > What I've read indicates that the following query > > http://127.0.0.1:5984/cups/_design/cups/_view/latest_by_customer?start_key=["greg_retsinas",606231154]&end_key=["greg_retsinas",606231154] > > should return > > {"total_rows":10,"offset":1,"rows":[ > {"id":"greg_retsinas-project_3_bulk_import_test-201008071451","key":["greg_retsinas",606231154],"value":null} > ]} > > not > > {"total_rows":10,"offset":0,"rows":[ > {"id":"brian_vankonynenburg-tracy_test_output_1-201010151149","key":["brian_vankonynenburg",606231153],"value":null}, > {"id":"greg_retsinas-project_3_bulk_import_test-201008071451","key":["greg_retsinas",606231154],"value":null}, > {"id":"greg_retsinas-test_project_1_standup_payments_and_revenue-201008071451","key":["greg_retsinas",606231161],"value":null}, > {"id":"greg_retsinas-project_3_bulk_import_test-201008071443","key":["greg_retsinas",606231163],"value":null}, > {"id":"greg_retsinas-test_project_1_standup_payments_and_revenue-201008071443","key":["greg_retsinas",606231170],"value":null}, > {"id":"greg_retsinas-project_3_bulk_import_test-201008071435","key":["greg_retsinas",606231172],"value":null}, > {"id":"greg_retsinas-test_project_1_standup_payments_and_revenue-201008071435","key":["greg_retsinas",606231179],"value":null}, > {"id":"greg_retsinas-project_3_bulk_import_test-201008071431","key":["greg_retsinas",606231180],"value":null}, > {"id":"greg_retsinas-test_project_1_standup_payments_and_revenue-201008071431","key":["greg_retsinas",606231188],"value":null}, > {"id":"greg_retsinas-test_project_2_hold_for_delivery-201008071431","key":["greg_retsinas",606231188],"value":null} > ]} > > What am I doing wrong? > > Tracy