RE: Invalid Date in Date Math String

2019-08-21 Thread Ritesh Kumar (Avanade)
have a successful rebuild without this error. Thanks Ritesh -Original Message- From: Grant Killian Sent: Wednesday, August 21, 2019 6:12 AM To: solr-user@lucene.apache.org Subject: RE: Invalid Date in Date Math String I happened to see this, Ritesh, so let me offer that this issue

RE: Invalid Date in Date Math String

2019-08-21 Thread Grant Killian
support ticket with Sitecore and they'll get you squared away. Thanks, Grant -Original Message- From: Ritesh Kumar (Avanade) Sent: Tuesday, August 20, 2019 7:39 PM To: solr-user@lucene.apache.org Subject: RE: Invalid Date in Date Math String Thanks Eric for the response! Regards R

RE: Invalid Date in Date Math String

2019-08-20 Thread Ritesh Kumar (Avanade)
Thanks Eric for the response! Regards Ritesh -Original Message- From: Erick Erickson Sent: Tuesday, August 20, 2019 4:34 PM To: solr-user@lucene.apache.org Subject: Re: Invalid Date in Date Math String You probably need to talk to the SiteCore people. The Apache project doesn’t have

Re: Invalid Date in Date Math String

2019-08-20 Thread Erick Erickson
ng solr 6.6.3 with Sitecore 9, however currently we seem to > be observing the below issue while rebuilding the index "Invalid Date in Date > Math String" > We already applied the patch located at the below location but it did not fix > the issue: > https://github.

Invalid Date in Date Math String

2019-08-20 Thread Ritesh Kumar (Avanade)
Hello, We have been using solr 6.6.3 with Sitecore 9, however currently we seem to be observing the below issue while rebuilding the index "Invalid Date in Date Math String" We already applied the patch located at the below location but it did not fix the issue: https://

Invalid Date Math Strings silently fail in q, not in fq

2019-05-13 Thread Ronja Koistinen
"status":400, "QTime":2, "params":{ "q":"*:*", "defType":"edismax", "df":"text", "fl":"visible_date", "fq":"visible_date:[\"2019-01-01T00

Re: Date Math, NOW and filter queries

2015-11-17 Thread Mugeesh Husain
thanks all of you, actually the problem was '+' sign is a URL-escape for space, Using %2B instead of + sign, should be fine -- View this message in context: http://lucene.472066.n3.nabble.com/Date-Math-NOW-and-filter-queries-tp4240561p4240675.html Sent from the Solr - User ma

Re: Date Math, NOW and filter queries

2015-11-17 Thread Shawn Heisey
On 11/17/2015 7:07 AM, Mugeesh Husain wrote: > when i fire query fq=date:[NOW/DAY-7DAYS TO NOW/DAY+1DAY], it is giving > below error > > "fq":"initial_release_date:[NOW/DAY-7DAYS TO NOW/DAY 1DAY]", > "rows":"32"}}, > "error":{ > "msg":"org.apache.solr.search.SyntaxError: Cannot parse >

Re: Date Math, NOW and filter queries

2015-11-17 Thread Chris Hostetter
: the '+' sign is a URL-escape for space, which you : see in the error message. more specifically, the error indicates that something/somewhere/somehow when you are construction your request to Solr, your HTTP request params are not getting properly escaped -- so the '+' is being sent literlay

Re: Date Math, NOW and filter queries

2015-11-17 Thread Erick Erickson
Congratulations, you are in "Url escaping hell" ;) the '+' sign is a URL-escape for space, which you see in the error message. Escape it as %2B and you should be fine. Best, Erick On Tue, Nov 17, 2015 at 6:07 AM, Mugeesh Husain wrote: > hi!, > > http://lucidworks.

Date Math, NOW and filter queries

2015-11-17 Thread Mugeesh Husain
hi!, http://lucidworks.com/blog/2012/02/23/date-math-now-and-filter-queries/ for date range query i am following above article,in this article I try to querying fq=date:[NOW/DAY-7DAYS TO NOW/DAY], it is working fine, when i fire query fq=date:[NOW/DAY-7DAYS TO NOW/DAY+1DAY], it is giving below

Re: Stored values and date math query

2013-03-04 Thread Indika Tantrigoda
se would normally be expected) > > : Is it possible to retrive an integer value from the index and pass it on > it > : a date math query ? Is there anything else that needs to be in the query > ? > > not using the date match syntax, but you can use the function syntax to > write a

Re: Stored values and date math query

2013-03-02 Thread Chris Hostetter
that (the "_val_" hook only lets you embed a function in a place where a query clause would normally be expected) : Is it possible to retrive an integer value from the index and pass it on it : a date math query ? Is there anything else that needs to be in the query ? not using the da

Re: Stored values and date math query

2013-03-01 Thread Indika Tantrigoda
stored value) > > > > However, when doing so causes the query to return incorrect results. The > > query is part of a if/else query present in the fields (fl) list > > > > _session_available_now_:if(exists(query($sessionAvailableNowQuery)), 100, > > 0) > > &g

Re: Stored values and date math query

2013-02-28 Thread Erick Erickson
; 0) > > Is it possible to retrive an integer value from the index and pass it on it > a date math query ? Is there anything else that needs to be in the query ? > > Thanks in advance. >

Re: Date math query syntax

2012-11-18 Thread Indika Tantrigoda
"XY Problem". First you need to > tell us what you are really trying to accomplish, THEN a solution can be > pursued. > > Take a look at the "ms" function query for date calculations - which is > separate from so-called "date-math" which is a constant offs

Re: Date math query syntax

2012-11-18 Thread Jack Krupansky
rst you need to tell us what you are really trying to accomplish, THEN a solution can be pursued. Take a look at the "ms" function query for date calculations - which is separate from so-called "date-math" which is a constant offset from a base date literal value. -- Ja

RE: solr Invalid Date in Date Math String/Invalid Date String

2011-06-09 Thread Chris Hostetter
: Here is the error message: : : Fieldtype: tdate (I use the default one in solr schema.xml) : Field value(Index): 2006-12-22T13:52:13Z : Field value(query): [2006-12-22T00:00:00Z TO 2006-12-22T23:59:59Z] <<< : with '[' and ']' : : And it generates the result below: i think the piece of info

RE: solr Invalid Date in Date Math String/Invalid Date String

2011-06-02 Thread Ellery Leung
--Start--- HTTP ERROR: 500 org.apache.solr.common.SolrException: Invalid Date in Date Math String:'[2006-12-22T00:00:00Z TO 2006-12' org.apache.jasper.JasperException: org.apache.solr.common.SolrException: Invalid Date in Date Math String:'

Re: solr Invalid Date in Date Math String/Invalid Date String

2011-05-31 Thread Erick Erickson
e other items that have values > on both size? They don't work at all. > > > -Original Message- > From: Mike Sokolov [mailto:soko...@ifactory.com] > Sent: 2011年5月27日 10:23 下午 > To: solr-user@lucene.apache.org > Cc: alucard001 > Subject: Re: solr Invalid Da

RE: solr Invalid Date in Date Math String/Invalid Date String

2011-05-27 Thread Ellery Leung
t: Re: solr Invalid Date in Date Math String/Invalid Date String The "*" endpoint for range terms wasn't implemented yet in 1.4.1 As a workaround, we use very large and very small values. -Mike On 05/27/2011 12:55 AM, alucard001 wrote: > Hi all > > I am using SOLR 1.4.1 (ac

Re: solr Invalid Date in Date Math String/Invalid Date String

2011-05-27 Thread Mike Sokolov
\-22T00\:00\:00\.000Z TO * [2006-12-22T00:00:00.000Z TO *] [2006\-12\-22T00\:00\:00\.000Z TO *] (vice versa) I get either: Invalid Date in Date Math String or Invalid Date String error What's wrong with it? Can anyone please help me on that? Thank you. -- View this message in context: htt

solr Invalid Date in Date Math String/Invalid Date String

2011-05-26 Thread alucard001
\:00Z TO * [2006-12-22T00:00:00Z TO *] [2006\-12\-22T00\:00\:00Z TO *] 2006-12-22T00:00:00.000Z TO * 2006\-12\-22T00\:00\:00\.000Z TO * [2006-12-22T00:00:00.000Z TO *] [2006\-12\-22T00\:00\:00\.000Z TO *] (vice versa) I get either: Invalid Date in Date Math String or Invalid Date String error

Re: More Date Math: NOW/WEEK

2011-03-05 Thread Andreas Kemkes
s in the client. Regards, Andreas From: Chris Hostetter To: solr-user@lucene.apache.org Sent: Tue, March 1, 2011 6:30:26 PM Subject: Re: More Date Math: NOW/WEEK : Digging into the source code of DateMathParser.java, i found the following : comment: :99 // NOTE: consciously c

Re: More Date Math: NOW/WEEK

2011-03-01 Thread Chris Hostetter
: Digging into the source code of DateMathParser.java, i found the following : comment: :99 // NOTE: consciously choosing not to support WEEK at this time, : 100 // because of complexity in rounding down to the nearest week 101 : // arround a month/year boundry. 102

More Date Math: NOW/WEEK

2011-02-23 Thread Andreas Kemkes
Date Math is great. NOW/MONTH, NOW/DAY are all working and very useful, so naively I tried NOW/WEEK, which failed. Digging into the source code of DateMathParser.java, i found the following comment: 99 // NOTE: consciously choosing not to support WEEK at this time, 100

Re: Date Math

2011-02-23 Thread Andreas Kemkes
Tue, February 22, 2011 6:18:56 PM Subject: Re: Date Math : org.apache.lucene.queryParser.ParseException: Cannot parse 'last_modified:-DAY': ... : Are they not supported as a short-cut for "NOW-1DAY"? I'm using Solr 1.4. No, "-1DAY" is a valid DateMath s

Re: Date Math

2011-02-22 Thread Chris Hostetter
: org.apache.lucene.queryParser.ParseException: Cannot parse 'last_modified:-DAY': ... : Are they not supported as a short-cut for "NOW-1DAY"? I'm using Solr 1.4. No, "-1DAY" is a valid DateMath string (to the DateMathParser) but as a field value you must specify a valid date string,

Date Math

2011-02-17 Thread Andreas Kemkes
The SolrQuerySyntax Wiki page refers to DateMathParser for examples. When I tried "-1DAY", I got: org.apache.lucene.queryParser.ParseException: Cannot parse 'last_modified:-DAY': Encountered " "-" "- "" at line 1, column 14. Was expecting one of: "(" ... "*" ... ... ...

Re: date math help

2010-01-25 Thread Ahmet Arslan
--- > What not use separate facet query for each these? > &facet.query:[NOW-1DAY TO > NOW]&facet.query:[NOW-7DAYS TO NOW]& etc. Sorry I forgot to add the field name: &facet.query=LastMod:[NOW-1DAY TO NOW]&facet.query=LastMod:[NOW-7DAYS TO NOW]&

Re: date math help

2010-01-25 Thread Ahmet Arslan
> If I wanted to return documents faceted by LastMod and I > wanted them grouped > by week what would the correct syntax be? > > I would like to eventually format the results to display > this: > > Last day (facet count) > Last Week (facet count) > Last 2 Weeks (facet count) > Last Month (facet c

date math help

2010-01-25 Thread solrquestion6
=NOW/DAY-84DAYS (84 days is 12 weeks) Am I going about this wrong or is there a better way to get my desired result? thanks! -- View this message in context: http://old.nabble.com/date-math-help-tp27315500p27315500.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: date math in bf?

2008-10-21 Thread Chris Hostetter
: Is it possible to do date math in a FunctionQuery? This doesn't work, but I'm : looking for something like: : : bf=recip((NOW-updated),1,200,10) when using DisMax to get the elapsed time : between NOW and when the document was updated (where updated is a Date field). "

date math in bf?

2008-10-15 Thread Sean Timm
Is it possible to do date math in a FunctionQuery? This doesn't work, but I'm looking for something like: bf=recip((NOW-updated),1,200,10) when using DisMax to get the elapsed time between NOW and when the document was updated (where updated is a Date field). I know one can do ro

Re: date math syntax

2008-01-29 Thread Chris Hostetter
: Is there a wiki page or more examples of the "date math" parsing other than : this: http://wiki.apache.org/solr/SolrQuerySyntax ...which links to... http://lucene.apache.org/solr/api/org/apache/solr/util/DateMathParser.html ...which contains several examples of math expressions.

date math syntax

2008-01-29 Thread Brian Whitman
Is there a wiki page or more examples of the "date math" parsing other than this: http://www.mail-archive.com/solr-user@lucene.apache.org/msg01563.html out there somewhere? From an end user query perspective. -b

'New' "Date Math" parsing code in Solr

2006-12-13 Thread Chris Hostetter
(I have this nasty habit of commiting cool things to Solr that should be announced on solr-user, and then deciding I'll wait untill they are in a nightly snapshot before I send an email about them -- and then forgetting that I never sent the mail). A while back I added some functionality to the D