Searching on dates and time

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Searching on dates and time

Steven White
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
Reply | Threaded
Open this post in threaded view
|

Re: Searching on dates and time

Mikhail Khludnev-2
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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Searching on dates and time

Steven White
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 <[hidden email]> 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 <[hidden email]> 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
>
Reply | Threaded
Open this post in threaded view
|

Re: Searching on dates and time

Mikhail Khludnev-2
Hold on. Do you need a range or just point in time?

On Fri, Jul 5, 2019 at 6:51 PM Steven White <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
> 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
Reply | Threaded
Open this post in threaded view
|

Re: Searching on dates and time

Steven White
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 <[hidden email]> wrote:

> Hold on. Do you need a range or just point in time?
>
> On Fri, Jul 5, 2019 at 6:51 PM Steven White <[hidden email]> 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 <[hidden email]>
> 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 <[hidden email]>
> > 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
>
Reply | Threaded
Open this post in threaded view
|

Re: Searching on dates and time

Erick Erickson
I think what Mikhail is asking is whether your use-case would be satisfied
by just indexing a standard pdate rather than a daterange, then querying
by

fq=CC_FILE_DATETIME:[some_date/MONTH TO some_maybe_other_full_date].

With regular pdates, you can use “date math” to round to whatever you want
on one or both parts of the query.

A note you might be interested in about “fq” clauses and dates in the
filter cache:

https://dzone.com/articles/solr-date-math-now-and-filter

Best,
Erick

> On Jul 5, 2019, at 11:55 AM, Steven White <[hidden email]> wrote:
>
> 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 <[hidden email]> wrote:
>
>> Hold on. Do you need a range or just point in time?
>>
>> On Fri, Jul 5, 2019 at 6:51 PM Steven White <[hidden email]> 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 <[hidden email]>
>> 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 <[hidden email]>
>>> 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
>>

Reply | Threaded
Open this post in threaded view
|

Re: Searching on dates and time

Steven White
Achieving the use-case is a must.  So if here is an alternative to
using solr.DateRangeField,
I'm willing to use it.  What do you mean by "pdate" and what is it?

I'm reading this link on how to use DateRangeField but yet it is not
working for me:
https://lucene.apache.org/solr/guide/6_6/working-with-dates.html  Is the
issue with my schema the way i set it up?  The way I'm indexing the data?
Or something else?

Steven

On Fri, Jul 5, 2019 at 3:03 PM Erick Erickson <[hidden email]>
wrote:

> I think what Mikhail is asking is whether your use-case would be satisfied
> by just indexing a standard pdate rather than a daterange, then querying
> by
>
> fq=CC_FILE_DATETIME:[some_date/MONTH TO some_maybe_other_full_date].
>
> With regular pdates, you can use “date math” to round to whatever you want
> on one or both parts of the query.
>
> A note you might be interested in about “fq” clauses and dates in the
> filter cache:
>
> https://dzone.com/articles/solr-date-math-now-and-filter
>
> Best,
> Erick
>
> > On Jul 5, 2019, at 11:55 AM, Steven White <[hidden email]> wrote:
> >
> > 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 <[hidden email]> wrote:
> >
> >> Hold on. Do you need a range or just point in time?
> >>
> >> On Fri, Jul 5, 2019 at 6:51 PM Steven White <[hidden email]>
> 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 <[hidden email]>
> >> 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 <[hidden email]>
> >>> 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
> >>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Searching on dates and time

Erick Erickson
<fieldType name="pdate" class="solr.DatePointField" docValues=“true” indexed=“true” />

There should be a number of these in the example schemas, although perhaps without indexed=“true” in the fieldType...

DateRanges are pretty cool, but this in the “keep it simple” category, you might just be able to use plain pdates with the standard [time TO time] syntax.

Although when I try your example (this is on 8.1), all your examples return the document when using DateRange. I indexed the doc with SolrJ just as you did. I was trying queries the admin UI and with quotes didn’t need to escape, with quotes I did, don’t know if daterange behavior has changed since 7.3. I don’t see any JIRAs on a quick scan that look pertinent.

The range works too if
1> you include the square brackets like all other range fields
2> correctly format the end date, 2019-02-06T12:00 not 2019-02-06:12:00.

BTW, the sweet spot for DateRange is you can, well, index a range, as:
doc.addField(“dfield", "[2019-02-05T12:04:00Z TO 2019-02-06T12:04:00Z]”);
If all you’re trying to do is index a single point in time, I’d recommend pdate.

Best,
Erick

> On Jul 5, 2019, at 6:19 PM, Steven White <[hidden email]> wrote:
>
> Achieving the use-case is a must.  So if here is an alternative to
> using solr.DateRangeField,
> I'm willing to use it.  What do you mean by "pdate" and what is it?
>
> I'm reading this link on how to use DateRangeField but yet it is not
> working for me:
> https://lucene.apache.org/solr/guide/6_6/working-with-dates.html  Is the
> issue with my schema the way i set it up?  The way I'm indexing the data?
> Or something else?
>
> Steven
>
> On Fri, Jul 5, 2019 at 3:03 PM Erick Erickson <[hidden email]>
> wrote:
>
>> I think what Mikhail is asking is whether your use-case would be satisfied
>> by just indexing a standard pdate rather than a daterange, then querying
>> by
>>
>> fq=CC_FILE_DATETIME:[some_date/MONTH TO some_maybe_other_full_date].
>>
>> With regular pdates, you can use “date math” to round to whatever you want
>> on one or both parts of the query.
>>
>> A note you might be interested in about “fq” clauses and dates in the
>> filter cache:
>>
>> https://dzone.com/articles/solr-date-math-now-and-filter
>>
>> Best,
>> Erick
>>
>>> On Jul 5, 2019, at 11:55 AM, Steven White <[hidden email]> wrote:
>>>
>>> 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 <[hidden email]> wrote:
>>>
>>>> Hold on. Do you need a range or just point in time?
>>>>
>>>> On Fri, Jul 5, 2019 at 6:51 PM Steven White <[hidden email]>
>> 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 <[hidden email]>
>>>> 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 <[hidden email]>
>>>>> 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
>>>>
>>
>>