Found the solution to same problem here - https://groups.google.com/forum/#!searchin/elasticsearch/date/elasticsearch/eeTwWVf6Sfo/1jbHq0gca6QJ
Thanks. On Friday, May 2, 2014 3:13:30 PM UTC+5:30, Hemant wrote: > > Hello, > > I have indexed some data, with default mapping - > > 1. { > 2. "inventory": { > 3. "products": { > 4. "properties": { > 5. "exp_date": { > 6. "type": "date", > 7. "format": "dateOptionalTime" > 8. }, > 9. "man_date": { > 10. "type": "date", > 11. "format": "dateOptionalTime" > 12. }, > 13. "price": { > 14. "type": "long" > 15. }, > 16. "product_description": { > 17. "type": "string" > 18. }, > 19. "product_name": { > 20. "type": "string" > 21. }, > 22. "quan_available": { > 23. "type": "long" > 24. } > 25. } > 26. } > 27. } > 28. } > > > Now when I perform a search to match some date, I am not getting the > expected result. > Consider query like this > { > "query": { > "filtered": { > "query": { > "query_string": { > "query": "exp_date:[2013-03-1 TO 2013-03-5]" > } > } > } > }, > "fields": [ > "price", > "quan_available", > "product_name", > "product_description", > "exp_date", > "man_date" > ], > "from": 0, > "size": 50, > "sort": { > "_score": { > "order": "asc" > } > }, > "explain": true > } > > Gives me expected result, that is all the documents which matches this > date range, but when I remove the field Name exp_date from the query > string, I am getting no result at all. > The following query results zero result. > { "query": { "filtered": { "query": { "query_string": { "query": > "[2013-03-1 TO 2013-03-5]" } } } }, "fields": [ "price", "quan_available", > "product_name", "product_description", "exp_date", "man_date" ], "from": 0, > "size": 50, "sort": { "_score": { "order": "asc" } }, "explain": true } > > Can anybody suggest solution to this problem? What am doing wrong? > Thansk in advance. > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/5155a1ed-b2d2-4fa7-9f2e-c37dd3323d52%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.