incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex P <kol...@gmail.com>
Subject Re: Complex filter with permanent view
Date Fri, 29 Jan 2010 18:23:32 GMT
Agreed. (almost) any time you need a string contains, you'll want  
lucene. Range queries are fairly straightforward with standard views  
(look at startkey and endkey) but if you need 'and' conditions (or any  
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>  
wrote:

> On 29 January 2010 11:36, Дмитрий Курилов <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)
>
> -- 
> Slan,
> David

Mime
View raw message