Re: Periodic search in date field

2011-08-18 Thread Gora Mohanty
On Wed, Aug 17, 2011 at 1:07 PM, slaava wrote: > Thanks for quick reply! > > Yes, this is my backup solution. But I prefer some one-query approach - > there could be many results so I want use SolrQuery.start() and > SolrQuery.rows() and show persons in table with paging. Was suggesting just one

Re: Periodic search in date field

2011-08-18 Thread slaava
Very inspirating, great thanks! Idea with indexing last number of year is very good and covers current requirements. But one day there could be requirement for (as you said) 3-years anniversaries. So I do this: Index: For every required X-year anniversary there will be field "year_mod_X" with "YE

Re: Periodic search in date field

2011-08-18 Thread Erick Erickson
Hmmm, doing this with date ranges would be a possibility, although that would be some really ugly filter queries... What would happen if you indexed a separate field that was just the last digit of the year, plus separate fields for year day and month? This assumes that 1, 5 and 10 are the only ra

Re: Periodic search in date field

2011-08-17 Thread slaava
Thanks for quick reply! Yes, this is my backup solution. But I prefer some one-query approach - there could be many results so I want use SolrQuery.start() and SolrQuery.rows() and show persons in table with paging. Are you sure mod() function is supported now? It isn't included in Math.* functi

Re: Periodic search in date field

2011-08-17 Thread Gora Mohanty
On Wed, Aug 17, 2011 at 12:01 PM, slaava wrote: [...] > My first idea was to index date in mmdd format (20110817) and use > modulo: > 1 year: indexed_date % 1 = 0817 > 5 year: indexed_date % 5 = 10817 > 10 year: indexed_date % 10 = 10817 > > but I didn't found something like modulo