我有一个.Net应用程序试图从elasticsearch文档存储中获取数据,具有以下结构中的记录:
{ "_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", }, }
我想在最后20分钟内使用LogGenerationTime获取所有记录.这是我到目前为止所写的查询,但它似乎没有返回任何数据:
var format = "yyyy-MM-dd'T'HH:mm:ss.fff"; var lowerBound = DateTime.Now.AddMinutes(-20); ISearchResponseresultSet = _elasticSearchClient.Search (q => q.Query (p => p.Range (v => v.OnField (x => x.LogGenerationTime).GreaterOrEquals(lowerBound, format))));
有人可以帮助编写正确的查询来获取预期的结果吗?谢谢!