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 CA3ED107C8 for ; Fri, 11 Oct 2013 18:06:27 +0000 (UTC) Received: (qmail 27640 invoked by uid 500); 11 Oct 2013 18:06:24 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 27605 invoked by uid 500); 11 Oct 2013 18:06:24 -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 27597 invoked by uid 99); 11 Oct 2013 18:06:24 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Oct 2013 18:06:24 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of robert.newson@gmail.com designates 209.85.128.52 as permitted sender) Received: from [209.85.128.52] (HELO mail-qe0-f52.google.com) (209.85.128.52) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Oct 2013 18:06:19 +0000 Received: by mail-qe0-f52.google.com with SMTP id w7so3511941qeb.39 for ; Fri, 11 Oct 2013 11:05:58 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=from:content-type:message-id:mime-version:subject:date:references :to:in-reply-to; bh=KthNmelk6Q0KW1tUQrgwiTvo+/oLchz9+kz1rZ5CuMw=; b=WLFIq4NLeaT0Evwgs2YUvrn/Fak1eOA1Q69q7/KLZLIKw9CBoTzoBlNxnlqnj3nK0d c4I3PNyVhhupRxB0g0zH793EWwHhhed6cJQ4QWQ2Si1qrBpZdgPYINUGHndJtweAAUrL TAxQqY/v52+zt4Bf20tiWfniOGZcnzgdRcJ6CA2VEzGSO0h0sou/ZaOQNLs1qdCubNXm 4vHgnmsV6gVzilweHZ+BRWUQcevGsXFF0gb47krz78suLbeZ37It8kVJreWZFelU/VjK UtX7DExGIQDYaX0Ukvcpa7R0HetyUEzQtntR3GNC+AaFkZM+YOO9d3225LS2OASlyTKY wajQ== X-Received: by 10.49.12.194 with SMTP id a2mr3227359qec.95.1381514758298; Fri, 11 Oct 2013 11:05:58 -0700 (PDT) Received: from [172.16.9.46] (50-195-18-145-static.hfc.comcastbusiness.net. [50.195.18.145]) by mx.google.com with ESMTPSA id x8sm112775093qam.2.1969.12.31.16.00.00 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 11 Oct 2013 11:05:57 -0700 (PDT) From: Robert Newson Content-Type: multipart/signed; boundary="Apple-Mail=_67D7EF51-48C2-401D-BD91-EE1602F294D4"; protocol="application/pgp-signature"; micalg=pgp-sha512 Message-Id: <1053F209-A673-4082-B631-A441A4BB4015@apache.org> Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\)) Subject: Re: CouchDB: Using "OR" in Queries Date: Fri, 11 Oct 2013 14:05:55 -0400 References: <20131011190955.739de524@epc> To: user@couchdb.apache.org In-Reply-To: <20131011190955.739de524@epc> X-Mailer: Apple Mail (2.1510) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_67D7EF51-48C2-401D-BD91-EE1602F294D4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 That'll work too, though keys for GET is fairly recent iirc, you might = have to POST for older versions. "OR" is easy enough, it's "AND" that's tricky (and why I wrote = couchdb-lucene=85) B. On 11 Oct 2013, at 14:09, svilen wrote: > wasn't it > ...?keys=3D[list] >=20 >=20 > n Fri, 11 Oct 2013 14:56:57 -0300 > Hank Knight wrote: >=20 >> This allows my to find all results where the key equals "GOLD": >> http://example.com/abc/_design/iws/_view/q?key=3D%GOLD%22 >>=20 >> This allows my to find all results where the key equals "SILVER": >> http://example.com/abc/_design/iws/_view/q?key=3D%SILVER%22 >>=20 >> This allows my to find all results where the key equals "BRONZE": >> http://example.com/abc/_design/iws/_view/q?key=3D%BRONZE%22 >>=20 >> How can I get results with a single query where the key equals GOLD = or >> SILVER but not BRONZE? --Apple-Mail=_67D7EF51-48C2-401D-BD91-EE1602F294D4 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP using GPGMail -----BEGIN PGP SIGNATURE----- iQIcBAEBCgAGBQJSWD4DAAoJEBAV9o+doki8BkYQAID+4jipJDgKNx0u66/+44e7 tGk1tEUI/DYWfKiAvPdLsSWGhFSLCUkr4xuvwR1Yt9poNMIfvg/yOJCIp342MeZk RK0J8HM8pchXO9vQ6NitKUcIu3EasrNsv2b2o1IFOQ0myU1SSRCOrW1hgsJFi18A aVuxwzEoc24ZEFIC7CcgRScYz2H8+fthTgAPrpPvwh4sSR5lL2a9PzMA32xk8bfo 4YkQc70f2z0LB99ZhZIYJMpmZfLeHtk8bWTPYFCzP6Y13mEQHUil070WvW9RKIDA MgLYgU6iARXj7oENeiDGbKt7TxYBQ9h6VnJ0GUEjUObzmT0zOmOeMz1m9GKwmEjf MkEhpHs+KDsBikWVnR6aClVtdMIt7IVBuh5CL/xW1yhlUc54yGDWpB0YdfOPMz0v oXTnlB2i8gYnbPYrhoQjq+LcYFeWI9Nj+ugd1GoOkaTCEZqHvCWL0ELeJNGhg1GY f6g9th4yWV4Mq6pLhfZAjmBP6TwuTWiKHVnb3f4rVNthdo2uY+1dlQsipES46vJr bt2dDjhML8iqLTD0phT6Ig+0aAqkwkWqpzRA7tTMGBcdUzBte/iuAYSsWdD52nm7 fJ/hEg5gcfpNGbul6DS8ZLY0ETVyFVjbyF+m2KGRnWL5vnKAvf0m2ZA/JP9XUvEa bTFinJIu7G+iMZ9iNPne =ml0c -----END PGP SIGNATURE----- --Apple-Mail=_67D7EF51-48C2-401D-BD91-EE1602F294D4--