Re: How to Query to Solr for comparing two dates in solr

2014-06-13 Thread Chris Hostetter
: I think you'd have to get creative with function queries. The trick is You don't have to get *very* creative... : > I want to retrieve all docs or records from solr where updateDate >= : > appliedDate OR appliedDate == null Pretty sure all you need is... fq={!frange l=0}ms(updateDat

Re: How to Query to Solr for comparing two dates in solr

2014-06-13 Thread Erick Erickson
2014 at 2:49 AM, Pbbhoge wrote: > Hi, > > I have two date fields in Solr Schema, I want to compare two different date > fields in solr itself . > how can i write the Query in Solr for comparing the two dates in solr itself > . > > I want to retrieve all docs or record

How to Query to Solr for comparing two dates in solr

2014-06-13 Thread Pbbhoge
Hi, I have two date fields in Solr Schema, I want to compare two different date fields in solr itself . how can i write the Query in Solr for comparing the two dates in solr itself . I want to retrieve all docs or records from solr where updateDate >= appliedDate OR appliedDate == null you

Re: Limiting on dates in Solr

2011-03-03 Thread Steve Lewis
Ugh. Of course. I fixed that a couple weeks ago, something must have crept back in! Thanks a mil! From: Andreas Kemkes To: solr-user@lucene.apache.org Sent: Thu, March 3, 2011 4:12:02 PM Subject: Re: Limiting on dates in Solr 2011-03-03T59:59:99.999Z

Re: Limiting on dates in Solr

2011-03-03 Thread Andreas Kemkes
2011-03-03T59:59:99.999Z - shouldn't that be 2011-03-03T23:59:59.999Z From: Steve Lewis To: solr-user@lucene.apache.org Sent: Thu, March 3, 2011 11:21:53 AM Subject: Limiting on dates in Solr I am treating Solr as a NoSQL db that has great search capabil

Limiting on dates in Solr

2011-03-03 Thread Steve Lewis
I am treating Solr as a NoSQL db that has great search capabilities. I am querying on a few fields: 1. text (default) 2. type (my own string field) 3. calibration (my own date field) I'd like to limit the results to only show the calibration using this query: calibration:[2011-03-03T00:00:00.00

Re: Dates in Solr

2008-12-10 Thread Tricia Williams
December 10, 2008 12:12:11 PM Subject: Dates in Solr Hi All, I'm curious about what people have done with dates. We Require: 1. multiple granularities to query and facet on: by year, by year/month, by year/month/day 2. sortability: sort/order by date 3. time typically isn't impor

Re: Dates in Solr

2008-12-10 Thread Otis Gospodnetic
o: solr-user@lucene.apache.org > Sent: Wednesday, December 10, 2008 12:12:11 PM > Subject: Dates in Solr > > Hi All, > > I'm curious about what people have done with dates. > > We Require: > > 1. multiple granularities to query and facet on: by year, by > year/mon

Dates in Solr

2008-12-10 Thread Tricia Williams
Hi All, I'm curious about what people have done with dates. We Require: 1. multiple granularities to query and facet on: by year, by year/month, by year/month/day 2. sortability: sort/order by date 3. time typically isn't important to us 4. some of these items don't have a day or mont

Re: Best strategy for dates in solr-ruby

2008-08-12 Thread Ian Connor
I like your suggestion. To keep the index working the same, I have just switched to dates and added the string "T23:59:59Z" and it seems to make the solr.DateField happy when this string is passed. It will mean I will have to mess with it on the way back in - but it should be okay. To have solr-ru

Re: Best strategy for dates in solr-ruby

2008-08-12 Thread Erik Hatcher
On Aug 11, 2008, at 3:03 PM, Ian Connor wrote: I originally used a Ruby Date class for my dates, but found when I set the type to solr.DateField in the solrconfig.xml, it returned a parse error. After that, I switched to Time and it worked fine. However, I now have some dates that are out of th

Best strategy for dates in solr-ruby

2008-08-11 Thread Ian Connor
Hi, I originally used a Ruby Date class for my dates, but found when I set the type to solr.DateField in the solrconfig.xml, it returned a parse error. After that, I switched to Time and it worked fine. However, I now have some dates that are out of the Time range (e.g. 1865) so Date would work b