part of the index looks like this "startdate" : "2018-11-01T00:00:00", "enddate" : "2018-11-01T00:00:00" My fluentAPI query looks like below
var response = client.Search(x => x .Size(500) .Query(q => q.Bool(b => b.Must (mu => mu.MultiMatch(m => m .Fields(n => n.Fields(f => f.User, f => f.Activity , f => f.County, f => f.Constituency, f => f.Country , f => f.ActivityRequestDescription, f => f.ActivityDescription, f => f.LessonsLearnt, f => f.Challenges, f => f.Recommendatinons, f => f.User , f => f.Venue, f => f.Division)) .Query( search ))) . Filter (fi => fi .DateRange(r => r .Field(f => f.StartDate) .GreaterThan("2018-08-20") .LessThanOrEquals(DateMath.Now) )))));
The query runs well and return results WITHOUT filter. After I add filter as shown above the query returns no results. Can anyone point the problem with the fluentAPI code