Querying by a datetime field using ElasticSearch Head?

Elastic Stack Elasticsearch
1

It seems like there should be a simple solution, but I've looked all over
and can't find an answer.

This is using elasticsearch head.

I see some results in the browser.

I select the contents of the timestamp field.

I then run the following query and it returns nothing.

What am I missing???

Thanks,
Ralph

{"query":{"bool":{"must":[{"term":{"webservicebolcalls.Timestamp":"1/16/2013
12:04:28
PM"}}],"must_not":[],"should":[]}},"from":0,"size":50,"sort":[],"facets":{}}

Timestamp: 1/16/2013 12:04:28 PM
Milliseconds: 341
MessageId: f6d9648e-bc13-4f51-9f51-8eed6f673210
Endpoint: Internal

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

2

You are using a TermQuery which is not analyzed.
Depending on your mapping, your field can have been indexed as a String or as a date (ms since epoch).

1st: check your mapping
2nd: Try to use matchQuery or RangeQuery.

HTH

David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 10 mai 2013 à 23:04, Ralph Trickey ralphtrickey@gmail.com a écrit :

It seems like there should be a simple solution, but I've looked all over and can't find an answer.

This is using elasticsearch head.

I see some results in the browser.

I select the contents of the timestamp field.

I then run the following query and it returns nothing.

What am I missing???

Thanks,
Ralph

{"query":{"bool":{"must":[{"term":{"webservicebolcalls.Timestamp":"1/16/2013 12:04:28 PM"}}],"must_not":[],"should":[]}},"from":0,"size":50,"sort":[],"facets":{}}

Timestamp: 1/16/2013 12:04:28 PM
Milliseconds: 341
MessageId: f6d9648e-bc13-4f51-9f51-8eed6f673210
Endpoint: Internal

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.