Hi all,

I would like to query my index to get all data to some date. Every row has a publication date and i would like to use this date to get my results using the actual day time.



i have read in hibernate search in action book about using rangequery to query using dates. In luke i can get the data using this query [* TO NOW] but i can not do this with hibernate search.

I tried:



i also tried:



none of these solutions helps me to get the data till actual date.

any ideas?

thanks in advance!

Hi,

the term query won't work, because it does not understand about the query syntax "[* TO NOW]". For that to work you have to use a query parser. The term query just searches for the terms as you specify them.

A term range query should work. To have an open end point you should pass in null. You also need to double check whether DateTools.dateToString(new Date(), DateTools.Resolution.SECOND) created the same values as you have in the index. It should since @DateBridge uses DateTools under the hood.

--Hardy

hi!

I did it this way just in case anybody wants to do the same query:



and the property publicationDate in my entity has the same resolution as the Termquery, Resolution.DAY.

see u!

Thanks for the update :-)