Cause I got about 20 date fields or more. If add a separate field for it, then I have to add additional 3 field for each of them. For example, for the field birthdate, I need to add birthdate_year, birthdate_month, birthdate_day. Is this practical adding so much additional fields?
Albert From: Stefan Matheis Sent: Thursday, March 15, 2018 3:05 PM To: solr-user@lucene.apache.org Subject: RE: solr query > You have any other idea? Yes, we go back to start and discuss again why you're not adding a separate field for that. It's the simplest thing possible and avoids all those workarounds that got mentioned. -Stefan On Mar 15, 2018 4:08 AM, "Albert Lee" <albertlee8...@gmail.com> wrote: > Hi Emir, > > If using OR-ed conditions for different years then the query will be very > long if I got 100 years and I think this is not practical. > You have any other idea? > > Regards, > Albert > From: Gus Heck > Sent: Thursday, March 15, 2018 12:43 AM > To: solr-user@lucene.apache.org > Subject: Re: solr query > > 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 > >
