Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of kolosy@gmail.com designates
 209.85.210.202 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:from:to:in-reply-to:content-type
         :content-transfer-encoding:x-mailer:mime-version:subject:date
         :references;
        b=QNtClw3/NtJOYJK7cA/EaSdZdCIog60ViLNTbvIE2mpuU6WLQx8BDJ8PplZnFF6AN3
         /UPRcfJT5HPvnqH+SeKNgIEeHNHkfxuxu3j+lTk1oZeCluAAcexqXGe5igZD2iSwITz+
         LcFACcbG9So3fbbNCAvbeF4qPkNQtp/zeiL8E=
Message-Id: <448B33C6-DA10-4645-AA1E-CA7FEF79325C@gmail.com>
From: Alex P <kolosy@gmail.com>
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
In-Reply-To: <b5f7bf6c1001291016r3cb50a22k82670c8d408c0dbc@mail.gmail.com>
Content-Type: text/plain;
	charset=koi8-r;
	format=flowed;
	delsp=yes
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (iPhone Mail 7D11)
Subject: Re: Complex filter with permanent view
Date: Fri, 29 Jan 2010 14:23:32 -0400
References: <ed1c4e161001290336w4f5e29b4rda3f18fcc34ee0d9@mail.gmail.com>
 <b5f7bf6c1001291016r3cb50a22k82670c8d408c0dbc@mail.gmail.com>

Agreed. (almost) any time you need a string contains, you'll want =20
lucene. Range queries are fairly straightforward with standard views =20
(look at startkey and endkey) but if you need 'and' conditions (or any =20=

compound queries at query-time) you have to go third party.

On Jan 29, 2010, at 2:16 PM, David Coallier <david.coallier@gmail.com> =20=

wrote:

> On 29 January 2010 11:36, =E4=CD=C9=D4=D2=C9=CA =EB=D5=D2=C9=CC=CF=D7 =
<me@dmkonweb.ru> wrote:
>> Hi folks,
>>
>> I have a database that contains docs like this one:
>> {
>>    'type': 'order',
>>    'customer_name': 'John F. Smit',
>>    'order_date': '2009-12-18',
>>    'manager_id': 'some id',
>>    'partner_order': 'ZX-M-777218883',
>>    'other_fields': 'There are other fields in document'
>> }
>>
>> I need all documents that match conditions received from web-form (so
>> conditions are unknown). For example:
>>  * customer_name string CONTAINS 'Smit'
>>  * order_date date BETWEEN '2009-12-01' and '2009-12-31'
>>  * manager_id string IS 'manager-21'
>>  * partner_order CONTAINS '77232'
>>
>
>
> I would recommend/consider looking at couchdb-lucene
> (http://github.com/rnewson/couchdb-lucene)
>
> --=20
> Slan,
> David