I need both: point in time and range. In both cases, I need to be able to search between just 2 years, between year-month to year-month-day-time, etc. So getting my schema right, what and how I index right and the search syntax right are all important. This is why, in my original post, I shared my schema, what I'm indexing and search syntax I'm trying to use. If I got anything wrong here to get the feature working right, please let me know.
Steven. On Fri, Jul 5, 2019 at 2:16 PM Mikhail Khludnev <m...@apache.org> wrote: > Hold on. Do you need a range or just point in time? > > On Fri, Jul 5, 2019 at 6:51 PM Steven White <swhite4...@gmail.com> wrote: > > > Thanks Mikhail. I will read those links and switch over to latest Solr. > > > > Just to be sure, my schema setup and the way I'm indexing the date data > are > > not the issue, right? > > > > Steven. > > > > On Fri, Jul 5, 2019 at 11:05 AM Mikhail Khludnev <m...@apache.org> > wrote: > > > > > Hello, > > > > > > The indexed daterange value is really narrow, it might not be easy to > > pick > > > per se. I'm in doubts regarding " in queries. At least TO syntax > expects > > [ > > > ] > > > You can start from these baseline cases > > > > > > > > > https://github.com/apache/lucene-solr/blob/master/solr/core/src/test/org/apache/solr/schema/DateRangeFieldTest.java > > > > > > and check > > > > > > > > > https://lucene.apache.org/solr/guide/8_0/working-with-dates.html#date-range-formatting > > > (also see below) for sure. > > > Also, I remember lack of strictness in 7,2.1 see > > > https://issues.apache.org/jira/browse/LUCENE-8640 > > > > > > On Fri, Jul 5, 2019 at 5:11 PM Steven White <swhite4...@gmail.com> > > wrote: > > > > > > > Hi everyone, > > > > > > > > I'm using Solr 7.2.1 but can upgrade if I must. > > > > > > > > I setup my schema like so: > > > > > > > > <fieldType name="dateRange" class="solr.DateRangeField"/> > > > > <field name="CC_FILE_DATETIME" type="dateRange" > > indexed="true" > > > > required="true" stored="false" multiValued="false" /> > > > > > > > > And indexed my data like so: > > > > > > > > doc.addField("CC_FILE_DATETIME", "2019-02-05T12:04:00Z");; > > > > > > > > When I try to search against this field, some search are working, > > others > > > > are not. Here are examples > > > > > > > > I get a hit: CC_FILE_DATETIME:"2019-02-05" > > > > I don't get a hit: CC_FILE_DATETIME:"2019-02-05T12" > > > > I don't get a hit: CC_FILE_DATETIME:"2019-02-05T12:04" > > > > I don't get a hit: CC_FILE_DATETIME:"2019-02-05T12:04:00Z" > > > > > > > > I'm seeing issues with range search took, like so: > > > > > > > > I don't get a hit: CC_FILE_DATETIME:"2019-02-05T12:04 TO > > > > 2019-02-06:12:00" > > > > > > > > It looks to me that anytime I include the time part, it won't work > and > > > yes > > > > I tried escaping ":" like so "\:" but that didn't help. > > > > > > > > Can someone guide me through this? > > > > > > > > Thank you > > > > > > > > Steven > > > > > > > > > > > > > -- > > > Sincerely yours > > > Mikhail Khludnev > > > > > > > > -- > Sincerely yours > Mikhail Khludnev >
