I think you have inadvertently "corrected" the intentional exclusive end on my range... [NOW/MONTH TO NOW/MONTH+1MONTH}
On Wed, Mar 14, 2018 at 12:08 PM, Emir Arnautović < emir.arnauto...@sematext.com> wrote: > 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 > > -- http://www.the111shift.com
