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 A66BD852A for ; Tue, 30 Aug 2011 06:27:36 +0000 (UTC) Received: (qmail 56189 invoked by uid 500); 30 Aug 2011 06:27:34 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 55791 invoked by uid 500); 30 Aug 2011 06:27:25 -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 55762 invoked by uid 99); 30 Aug 2011 06:27:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2011 06:27:19 +0000 X-ASF-Spam-Status: No, hits=1.6 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of tretiy3@gmail.com designates 74.125.83.52 as permitted sender) Received: from [74.125.83.52] (HELO mail-gw0-f52.google.com) (74.125.83.52) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2011 06:27:09 +0000 Received: by gwj15 with SMTP id 15so7550763gwj.11 for ; Mon, 29 Aug 2011 23:26:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=6UFxCk4bbW2FiykiMrsMMFBBJc5tA+C/wI7AmVYn/84=; b=Sl/QSZpxu7UKiHPwKqixzoNYfUnSGoqNEa205f/dc079pCeN2iIRtCKBGB0xLhxog9 jE+OzQJnupavq0LOglLE+RUN6KNRAs7PtDxVaF8hvVNp3LvB2cL/a/IH/yJs5cp1T84X mYVQFsYIB5DEyxsrw6rlMUh+Ga0qolXbmnhEQ= MIME-Version: 1.0 Received: by 10.150.115.2 with SMTP id n2mr5839511ybc.135.1314685608222; Mon, 29 Aug 2011 23:26:48 -0700 (PDT) Received: by 10.151.47.15 with HTTP; Mon, 29 Aug 2011 23:26:48 -0700 (PDT) In-Reply-To: References: Date: Tue, 30 Aug 2011 09:26:48 +0300 Message-ID: Subject: Re: startkey and endkey From: Ganzha Alexey To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=000e0cd4c1bcab619c04abb318c4 X-Virus-Checked: Checked by ClamAV on apache.org --000e0cd4c1bcab619c04abb318c4 Content-Type: text/plain; charset=ISO-8859-1 Hello. Your start key must match exactly some key in database. It is like an anchor. After db hits your start key, it begn emit for you all rows with the key which is less than startkey according to view collation. On Tue, Aug 30, 2011 at 8:33 AM, Andrey Cherkashin wrote: > Hello everyone. > > I have a problem with using couch views that has "complex" keys like: > ["Category", "sub-cat", "sku", 100] > > For example, I trying to get all docs that is in "Paint" category, so my > first guess was: > startkey=["Paint",0,0,0]&endkey=["Paint",{},{},{}] > but i got nothing. What am i doing wrong? --000e0cd4c1bcab619c04abb318c4--