How to write date range query in Nest ElasticSearch client?

Question

I have a .Net application trying to fetch data from an elasticsearch document store, having records in the following structure:

{
  "_index": "TestIndex",
  "_type": "amqp",
  "_id": "123",
  "_source": {
    "@timestamp": "2014-10-27T01:31:54.780Z",    
    "type": "amqp",        
    "LogGenerationTime": "2014-10-26T21:31:54.780",    
    "ThreadID": "6",
    "ProcessID": "8136",
    "SessionID": "xyz",
    "UserID": "12345678",
  },  
}

I want to fetch all the records with LogGenerationTime in the last 20 mins. Here's the query that I have written so far but it does not seem to return any data:

    var format = "yyyy-MM-dd'T'HH:mm:ss.fff";
    var lowerBound = DateTime.Now.AddMinutes(-20);
    ISearchResponse<Amqp> resultSet = _elasticSearchClient.Search<Amqp>(q => q.Query
                    (p => p.Range
                        (v => v.OnField
                            (x => x.LogGenerationTime).GreaterOrEquals(lowerBound, format))));

Can someone please help write the correct query to fetch expected results? Thanks!

your query looks pretty much correct. I suggest using fiddler to see the json that it sends to ES to try to determine the issue. — jhilden
– jhilden, Commented Oct 27, 2014 at 18:46

Chrysalis · Accepted Answer · 2014-10-27 20:44:32Z

8

Looking at the source code, there are two overloads of the OnField method. When I use the the that takes Linq expression parameter, the query does not return any data. But I was able to make it work with the other overload, which takes string value, where I am passing the field name of the elasticsearch document as a string. Here's the query that returns expected results:

var resultSet = _elasticSearchClient.Search<Amqp>(q => q.Query
                (p => p.Range(v => v.OnField("LogGenerationTime").GreaterOrEquals(lowerBound))).Size(10000));

Looks like a bug in the framework but am not completely sure.

answered Oct 27, 2014 at 20:44

Chrysalis

4,2483 gold badges23 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martijn Laarman Over a year ago

NEST by default camelCases property expressions, see this answer here how you can override this behaviour. Verbatim strings or attribute marked properties always take precedence.

Pang · Accepted Answer · 2016-03-04 02:05:56Z

1

The following code works for me:

Range(r => r.GreaterOrEquals(lowerBound).Format("MM/dd/yyyy").OnField(LogTime))

edited Mar 4, 2016 at 2:05

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Mar 4, 2016 at 1:42

Olev

675 bronze badges

Collectives™ on Stack Overflow

How to write date range query in Nest ElasticSearch client?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related