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 matteo.caprari@gmail.com
 designates 72.14.220.154 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:from:date:message-id:subject:to:content-type;
        b=wzRDkG5L1Mo5wn/1sH02PPQPdbDn0R+TvGs8TJ8xDHSvd050CIdn861uzk8hjjztGp
         oKOJZqnZmjVY7x6G8/7mikOL+dI/cWRG030ZxS6dZ84PFAVETJDgMWc/BfmCg9yelbbi
         h28YrM/+SqsqVYU4UvluiiM0LlYGaVyzAZo/o=
MIME-Version: 1.0
From: Matteo Caprari <matteo.caprari@gmail.com>
Date: Fri, 11 Dec 2009 14:01:56 +0000
Message-ID: <1bca98390912110601j46d22d0ek183b8ea53b6f7414@mail.gmail.com>
Subject: finding documents that fit a range and a list
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8

Hi.

I'm trying to find all documents that fit in a key range and that have
a property that is included in a list,
something in SQL would be

date > '2007-07-07' AND  date < '2008-08-08' AND tx IN ('transfer','purchase')

To do that I wrote a view and list
where the list and the map are

views/tx_by_date/map.js:
function(doc) {
    emit(doc.date, { tx: doc.tx, id:doc.id });
}

lists/filter.js:
function(head, req) {
	var filter = req.query.filter.split(',');
	while(row = getRow()) {
		if (filter.indexOf(row.value.tx) != -1) {
			send(row.value.id+'\n')
		}
	}
}
and execute the query with I'm
_list/filter/tx_by_date?startkey=2007-07-07&endkey=2008-08-08&filter=transfer,purchase

Does this make any sense?
Is it a good idea to use _lists for stuff like this?
Are there better ways to do that?

Thanks!
-- 
:Matteo Caprari
matteo.caprari@gmail.com