DateMath from DateTime.MinValue

die_seltsame · May 17, 2018, 1:43pm

I'm trying to search for a date that is greater than DateTime.MinValue, but elastic throws search_phase_execution_exception. When I create var d = DateMath.Anchored(DateTime.MinValue) , d.Self = null and d.ToString() returns String.Empty. I do not observe this behavior with other dates, f.e. with DateTime.MaxValue.

 "range": {
                  "eventDateUtc": {
                    "gte": "0001-01-01T00:00:00"
                  }
                }

How can I make this filter using Nest? Elasticsearch can search dates that are greater than DateTime.MinValue.

I am using Nest 6.0.0 and Elastic 6.2.0

Why isValid is defined in this way?

github.com

elastic/elasticsearch-net/blob/master/src/Nest/CommonOptions/DateMath/DateMath.cs#L84


			{
				var rounding = match.Groups["rounding"].Value.Substring(1).ToEnum<DateMathTimeUnit>(StringComparison.Ordinal);
				if (rounding.HasValue)
					return math.RoundTo(rounding.Value);
			}
			return math;
		}


		public override string ToString()
		{
			var isValid = Self.Anchor.Match(d => d != default(DateTime), s => !s.IsNullOrEmpty());
			if (!isValid) return string.Empty;


			var separator = Self.Round.HasValue || Self.Ranges.HasAny() ? "||" : string.Empty;


			var sb = new StringBuilder();
			var anchor = Self.Anchor.Match(
				d => d.ToJsonNetString() + separator,
				s => s == "now" || s.EndsWith("||", StringComparison.Ordinal) ? s : s + separator
			);
			sb.Append(anchor);

system · June 14, 2018, 1:43pm

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
DateRange Query in NEST Elasticsearch	3	877	December 19, 2016
Problem in DateRange query in C# Elasticsearch	8	5614	July 12, 2018
Querying Elasticsearch with NEST error: "Input string was not in a correct format." Elasticsearch	7	3450	July 1, 2019
NEST date deserialization challenges Elasticsearch	1	1080	October 9, 2019
NEST search -> String was not recognized as a valid DateTime Elasticsearch	1	917	September 21, 2017

DateMath from DateTime.MinValue

Related topics