You have two options. 1) use couchdb-lucene
2) emit multiple rows for each document. something like this:
function(doc) {
var iterDate = doc.startDate;
var endDate = doc.endDate;
while (iterDate < endDate) {
emit(iterDate);
iterDate.setDay(iterDate.getDay() + 1) // make this as fine-grained
as you like
}
}
On Wed, Oct 21, 2009 at 6:31 AM, Maurício Szabo <[email protected]>wrote:
> Ok, but how? How is it compared? I've already tried with a lot of
> combinations, and none seens to work.
>
> On Wed, Oct 21, 2009 at 9:27 AM, Cairo Noleto <[email protected]>
> wrote:
>
> > You can use startkey and endkey to find this values
> >
> > On Wed, Oct 21, 2009 at 08:16, Maurício Szabo <[email protected]
> > >wrote:
> >
> > > Hello, list.
> > >
> > > I have a problem on an aplication I'm trying to migrate to CouchDB: I
> > have
> > > a
> > > series of documents like:
> > >
> > > {
> > > type: "Period",
> > > start: "2009-10-12",
> > > end: "2009-12-12"
> > > }
> > >
> > > Problem is, I need to check on my application if there is a valid
> period.
> > I
> > > need to search if:
> > >
> > > (start < today) and (today < end)
> > >
> > > How can I do this in CouchDB? I've tried creating views, but I'm stuck
> > (I'm
> > > emitting [doc.start, doc.end] as an index, but I still cannot find a
> way
> > to
> > > search this).
> > >
> > > Thanks in advance,
> > > Mauricio.
> > >
> >
> >
> >
> > --
> > Cairo Noleto
> > Visits http://www.caironoleto.com/
> >
>