From user-return-17702-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Tue Aug 30 06:50:14 2011 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 3234C8328 for ; Tue, 30 Aug 2011 06:50:14 +0000 (UTC) Received: (qmail 85667 invoked by uid 500); 30 Aug 2011 06:50:12 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 84887 invoked by uid 500); 30 Aug 2011 06:49:58 -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 84878 invoked by uid 99); 30 Aug 2011 06:49:53 -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:49:53 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,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 andoriyu@gmail.com designates 209.85.210.46 as permitted sender) Received: from [209.85.210.46] (HELO mail-pz0-f46.google.com) (209.85.210.46) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2011 06:49:43 +0000 Received: by pzk32 with SMTP id 32so10768035pzk.19 for ; Mon, 29 Aug 2011 23:49:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=content-type:mime-version:subject:from:in-reply-to:date :content-transfer-encoding:message-id:references:to:x-mailer; bh=zzGAb4i5+ciYi6M4zFOjnpcWZaFhY9iBM6BoK2jSOro=; b=xb0M+XFDrsjrXTNVp/pNIdWbQNMtn7rE32Hpfi9lBe9Rv+PCezuexNzdls7bNnNfZw odUSzWqCzz0zIwplL3ludax39a8ewJNCFsmLkySMHsxC3NDk96FOzi44tvWTXClkfyrL B1PYTo41lQFLjLWK9k7HcbdRRk0pSNjmHcIZU= Received: by 10.142.144.6 with SMTP id r6mr2809382wfd.109.1314686961922; Mon, 29 Aug 2011 23:49:21 -0700 (PDT) Received: from [192.168.220.101] (dveri.ether.vzletka.net. [89.105.128.215]) by mx.google.com with ESMTPS id x6sm22462582pba.5.2011.08.29.23.49.18 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 29 Aug 2011 23:49:20 -0700 (PDT) Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Apple Message framework v1249) Subject: Re: startkey and endkey From: Andrey Cherkashin In-Reply-To: Date: Mon, 29 Aug 2011 23:49:10 -0700 Content-Transfer-Encoding: quoted-printable Message-Id: <28EAF0D9-BC45-463B-AE57-B8C95E045C63@gmail.com> References: To: user@couchdb.apache.org X-Mailer: Apple Mail (2.1249) X-Virus-Checked: Checked by ClamAV on apache.org ["Paint", "Inside", "01-05.01-0002", 0] ["Paint", "Inside", "01-05.01-0003", 0] ["Paint", "Outside", "01-05.01-0004", 0] On Aug 29, 2011, at 11:35 PM, Ganzha Alexey wrote: > More details required. > Drop here some rows from your view. >=20 > On Tue, Aug 30, 2011 at 9:29 AM, Andrey Cherkashin = wrote: >=20 >> When I do exact match in start key and end key, i got 0 results. >> On Aug 29, 2011, at 11:26 PM, Ganzha Alexey wrote: >>=20 >>> 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. >>>=20 >>> On Tue, Aug 30, 2011 at 8:33 AM, Andrey Cherkashin = >> wrote: >>>=20 >>>> Hello everyone. >>>>=20 >>>> I have a problem with using couch views that has "complex" keys = like: >>>> ["Category", "sub-cat", "sku", 100] >>>>=20 >>>> For example, I trying to get all docs that is in "Paint" category, = so my >>>> first guess was: >>>> startkey=3D["Paint",0,0,0]&endkey=3D["Paint",{},{},{}] >>>> but i got nothing. What am i doing wrong? >>=20 >>=20