From user-return-14094-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Mon Dec 06 23:26:19 2010 Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 8300 invoked from network); 6 Dec 2010 23:26:18 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 6 Dec 2010 23:26:18 -0000 Received: (qmail 99599 invoked by uid 500); 6 Dec 2010 23:26:17 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 99555 invoked by uid 500); 6 Dec 2010 23:26:17 -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 99547 invoked by uid 99); 6 Dec 2010 23:26:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Dec 2010 23:26:17 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kchuang@ucalgary.ca designates 136.159.37.49 as permitted sender) Received: from [136.159.37.49] (HELO smtp1.ucalgary.ca) (136.159.37.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Dec 2010 23:26:10 +0000 Received: from EXEDGE01.ad.ucalgary.ca (unknown [10.40.24.17]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by smtp1.ucalgary.ca (Postfix) with ESMTP id 2BDE22401D for ; Mon, 6 Dec 2010 16:25:35 -0700 (MST) Received: from EXHUB02.admin.ad.ucalgary.ca (10.40.88.18) by EXEDGE01.ad.ucalgary.ca (10.40.24.17) with Microsoft SMTP Server (TLS) id 8.3.83.0; Mon, 6 Dec 2010 16:25:34 -0700 Received: from exmb01.admin.ad.ucalgary.ca ([169.254.1.211]) by EXHUB02.admin.ad.ucalgary.ca ([::1]) with mapi; Mon, 6 Dec 2010 16:25:34 -0700 From: King Huang To: "user@couchdb.apache.org" Date: Mon, 6 Dec 2010 16:25:34 -0700 Subject: Suggestions for View Keys Thread-Topic: Suggestions for View Keys Thread-Index: AcuVnOGVdKD8SiW2Q7WIxMvOmlRS9A== Message-ID: Accept-Language: en-US, en-CA Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US, en-CA Content-Type: multipart/alternative; boundary="_000_B83C5052C36F421F92770C2C4D235865ucalgaryca_" MIME-Version: 1.0 X-UCalgary-MailScanner-Information: Please contact IT Help Desk at (403) 220-5555 for more information X-UCalgary-MailScanner-ID: 2BDE22401D.A6CF7 X-UCalgary-MailScanner: Found to be clean X-UCalgary-MailScanner-From: kchuang@ucalgary.ca --_000_B83C5052C36F421F92770C2C4D235865ucalgaryca_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I have a view whose view keys are currently of the following form: [k, x, y, z] [k, x, y, 0] [k, x, 0, z] [k, x, 0, 0] [k, 0, y, z] [k, 0, y, 0] [k, 0, 0, z] [k, 0, 0, 0] There are multiple values for k, x, y, and z, and x, y, z can be undefined = (represented by 0 here). What I want to be able to fetch are, given k, x, y, and z, all the view row= s with (key and (x or 0) and (y or 0) and (z or 0)). I'm having difficultly= coming up with an appropriate view key structure where the view rows will = be sorted in a manner that allows me to select that. Does anyone have any s= uggestions? Thanks, King Chung Huang Technology Solutions Analyst Information Technologies University of Calgary --_000_B83C5052C36F421F92770C2C4D235865ucalgaryca_--