lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven White <swhite4...@gmail.com>
Subject Indexing date data for facet search
Date Mon, 11 Apr 2016 22:03:24 GMT
Hi everyone,

I need to index data data into Solr and then use this field for facet
search.  My question is this, the date data in my DB is stored in the
following format "2016-03-29 15:54:35.461":

1) What format I should be indexing this date + time stamp into Solr?
2) What Solr field type I should be using?  Is it "date"?
3) How do I handle various time zones and locales?
4) Can I insert multi value data data into the single "date" facet field
and still use this field for facet search?
5) Based on my need, will all the Date Math per [1] on date facet still
work? I'm confused here because of my need for (3).

To elaborate on (4) some more.  The need here is this.  In my DB, there are
more than one column with date data.  I will be indexing them all into this
single multi-value Solr field of type Date that I will then use for facet.
Is this possible?

I guess, this is a two part question, for date facet: a) how to properly
index, and b) how do I properly search.

As always, any insight is greatly appreciated.

Steve

[1] https://cwiki.apache.org/confluence/display/solr/Working+with+Dates

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message