Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 63364 invoked from network); 29 Jan 2010 16:33:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 29 Jan 2010 16:33:47 -0000 Received: (qmail 44438 invoked by uid 500); 29 Jan 2010 16:33:44 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 44387 invoked by uid 500); 29 Jan 2010 16:33:44 -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 Delivered-To: moderator for user@couchdb.apache.org Received: (qmail 8109 invoked by uid 99); 29 Jan 2010 11:36:55 -0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) MIME-Version: 1.0 Date: Fri, 29 Jan 2010 16:36:26 +0500 Message-ID: Subject: Complex filter with permanent view From: =?KOI8-R?B?5M3J1NLJyiDr1dLJzM/X?= To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org 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' How to solve it with permanent view? Many thanks, Dmitry