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 YEAR
Hi,
I have this problem: We have about 100k persons with date of birth indexed
by solr. Now we need find persons with birth anniversary for any input date.
Exactly 1, 5 and 10 year is neccessary.
For example:
Input date: 17.8.2011
Required output:
1 year: persons with date of birth 17.8.2010,
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.*
