Hi Gus, It is just current month, but Albert is interested in month, regardless of year. It can be done with OR-ed conditions for different years: birthDate:[NOW/MONTH TO NOW/MONTH+1MONTH] OR birthDate:[NOW-1YEAR/MONTH TO NOW-1YEAR/MONTH+1MONTH] OR birthDate:[NOW-2YEAR/MONTH TO NOW-2YEAR/MONTH+1MONTH] OR…
Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > On 14 Mar 2018, at 16:55, Gus Heck <gus.h...@gmail.com> wrote: > > I think you can specify the current month with > > birthDate:[NOW/MONTH TO NOW/MONTH+1MONTH} > > does that work for you? > > On Wed, Mar 14, 2018 at 6:32 AM, Emir Arnautović < > emir.arnauto...@sematext.com> wrote: > >> Actually you don’t have to add another field - there is function ms that >> converts date to timestamp. What you can do is use frange query parser and >> play bit with math, e.g. sub(ms(date_field),ms(NOW/YEAR)) will give you >> ms elapsed since this year and you know that from 0 to 31*86400000 is >> January, from 31*86400000+1 to … is February and so on. >> >> If you go this path, I would suggest custom function that will convert >> date to month/year. >> >> HTH, >> Emir >> -- >> Monitoring - Log Management - Alerting - Anomaly Detection >> Solr & Elasticsearch Consulting Support Training - http://sematext.com/ >> >> >> >>> On 14 Mar 2018, at 10:53, Albert Lee <albertlee8...@gmail.com> wrote: >>> >>> I don’t want to add separate fields since I have many dates to index. >> How to index it as timestamp and do function query, any example or >> documentation? >>> >>> Regards, >>> Albert >>> >>> From: Emir Arnautović >>> Sent: Wednesday, March 14, 2018 5:38 PM >>> To: solr-user@lucene.apache.org >>> Subject: Re: solr query >>> >>> Hi Albert, >>> The simplest solution is to index month/year as separate fields. >> Alternative is to index it as timestamp and do function query to do some >> math and filter out records. >>> >>> Emir >>> -- >>> Monitoring - Log Management - Alerting - Anomaly Detection >>> Solr & Elasticsearch Consulting Support Training - http://sematext.com/ >>> >>> >>> >>>> On 14 Mar 2018, at 10:31, Albert Lee <albertlee8...@gmail.com> wrote: >>>> >>>> NOW/MONTH and NOW/YEAR to get the start of month/year, but how can I >> get current month of regardless year. Like the use case, people who’s >> birthdate is this month? >>>> >>>> Regard, >>>> Albert >>>> >>>> >>>> From: Emir Arnautović >>>> Sent: Wednesday, March 14, 2018 5:26 PM >>>> To: solr-user@lucene.apache.org >>>> Subject: Re: solr query >>>> >>>> Hi Albert, >>>> It does - you can use NOW/MONTH and NOW/YEAR to get the start of >> month/year. Here is reference to date math: https://lucene.apache.org/ >> solr/guide/6_6/working-with-dates.html#WorkingwithDates-DateMathSyntax < >> https://lucene.apache.org/solr/guide/6_6/working-with- >> dates.html#WorkingwithDates-DateMathSyntax> >>>> >>>> HTH, >>>> Emir >>>> -- >>>> Monitoring - Log Management - Alerting - Anomaly Detection >>>> Solr & Elasticsearch Consulting Support Training - http://sematext.com/ >>>> >>>> >>>> >>>>> On 14 Mar 2018, at 04:21, Albert Lee <albertlee8...@gmail.com> wrote: >>>>> >>>>> Dear Solr, >>>>> I want to whether solr support query by this year or this month? >>>>> If can, how to do that. >>>>> Thanks. >>>>> >>>>> Regards, >>>>> Albert >>>>> >>>> >>>> >>> >>> >> >> > > > -- > http://www.the111shift.com
