On Tue, Aug 11, 2009 at 7:08 PM, Constantijn Visinescu <baeli...@gmail.com>wrote:
> > <doc> > <str name="name">Room1</str> > <date name="reserved_from_11">2000-08-01T00:00:00Z</date> > <date name="reserved_to_11">2000-08-31T23:59:59Z</date> > </doc> > <doc> > <str name="name">Room2</str> > <date name="reserved_from_24">2000-08-01T00:00:00Z</date> > <date name="reserved_to_24">2000-08-13T23:59:59Z</date> > <date name="reserved_from_36">2000-08-20T00:00:00Z</date> > <date name="reserved_to_36">2000-08-22T23:59:59Z</date> > </doc> > > Now i want to run a query that gives me all documents(rooms) that are > avaiable from aug 15th to aug 18th (should return Room2), or from aug 10th > to aug 15th (should return none) or from sept 1st to sept 5th (should > return > both). > > Is it possible to run queries like this in solr? (either with my current > schema setup, or a different one that accomplishes the same idea). > I'm not sure how you are creating the dynamic field's name. But if you know the field name, the query can be like this: q=*:*&fq=-reserved_from:[2008-08-15T00:00:00Z TO 2008-08-18T00:00:00Z] Note the minus at the start of the fq. The above query says give me all documents (q=*:*) excluding the ones in which reserved_from is between 15th to 18th August. -- Regards, Shalin Shekhar Mangar.
