# Search\_query

**URL:** <https://discuss.elastic.co/t/search-query/4682>\
**Category:** Elasticsearch\
**Created:** [June 22, 2011, 8:39am UTC](https://discuss.elastic.co/t/search-query/4682 "2011-06-22T08:39:19Z")\
**Posts on this page:** 3\
**Page:** 3

<div class="post-metadata">

**Author:** ![sandeep15mca](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sandeep15mca/32/3178_2.png) [@sandeep15mca](https://discuss.elastic.co/u/sandeep15mca)\
**Post date:** [June 30, 2011, 11:37am UTC](https://discuss.elastic.co/t/search-query/4682/41 "2011-06-30T11:37:11Z")

</div>

Sorry Sir but I am trying and trying .............sorry if I did any mistake

On Thu, Jun 30, 2011 at 5:05 PM, Clinton Gormley [clinton@iannounce.co.uk](mailto:clinton@iannounce.co.uk)wrote:

> On Thu, 2011-06-30 at 16:54 +0530, sandeep tiwari wrote:
> 
> > Sorry sir result is previous is correct but query is this-
> 
> > ```
> > All Things have been done perfectlly but result is
> > unexpected please help me -
> > 
> > ```
> 
> Sandeep - you clearly haven't read the docs. Go do so - I can't help you  
> if you won't help yourself.
> 
> clint

---

<div class="post-metadata">

**Author:** ![sandeep15mca](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sandeep15mca/32/3178_2.png) [@sandeep15mca](https://discuss.elastic.co/u/sandeep15mca)\
**Post date:** [July 2, 2011, 7:37am UTC](https://discuss.elastic.co/t/search-query/4682/42 "2011-07-02T07:37:03Z")

</div>

Sir!  
My database is-

Overview [http://192.168.1.100:5984/\_utils/index.html](http://192.168.1.100:5984/_utils/index.html)  
pureanalyzer\_datafeed\_db[http://192.168.1.100:5984/\_utils/database.html?pureanalyzer\_datafeed\_db](http://192.168.1.100:5984/_utils/database.html?pureanalyzer_datafeed_db)  
_86407801915707392_

- Save Document

- Add Field

- Upload Attachment…

- Delete Document…

- Fields[http://192.168.1.100:5984/\_utils/document.html?pureanalyzer\_datafeed\_db/86407801915707392#tabular](http://192.168.1.100:5984/_utils/document.html?pureanalyzer_datafeed_db/86407801915707392#tabular)

- Source[http://192.168.1.100:5984/\_utils/document.html?pureanalyzer\_datafeed\_db/86407801915707392#source](http://192.168.1.100:5984/_utils/document.html?pureanalyzer_datafeed_db/86407801915707392#source)

Fields Field Value _\_id_86407801915707392\*\_rev\*  
2-aa89d0fc127e8ba0c21486278ff1f085_BusinessAreaConfiguration_  
_GeoEnabled_true_IndustryRelevancy_  
_IsEnglish_true_IsTweet_yes_Location_New Britain, CT USA\*  
MessageEfluencerIndex\*  
_Name_jjcrocket_PlaceFullName_New Britain, CT_PlaceName_New Britain\*  
ReplyUserID_21619519_ResultType\*  
_Retweet_false_Source_web_SystemCreatedAt_2011-06-30_SystemModifiedAt_  
2011-06-30_ToUserID_  
_ToUserName_  
_TweetContry_United States_TweetCountryCode_US_TweetCreatedAt_Thu Jun 30  
12:16:40 +0000 2011_TweetData_@joenbc @morningmika Obama is the most  
arrogant, condescending brat ever in the White House. Two flights on  
CorporateJetAirForceOne today!!_TweetLatitude_  
_TweetLongigttude_  
_UserEfluncerIndex_  
_UserGender_unknown_UserID_17250739_UserName_jjcrocket_polarity_0  
Sir I want to Search date and Time in Thu Jun 30 12:16:40 +0000 2011 this  
format please hlp me to find out

On Thu, Jun 23, 2011 at 7:36 PM, Clinton Gormley [clinton@iannounce.co.uk](mailto:clinton@iannounce.co.uk)wrote:

> Hi Sandeep
> 
> On Thu, 2011-06-23 at 19:24 +0530, sandeep tiwari wrote:
> 
> > Sir!  
> > I want to all result between given date-  
> > $ curl -XGET '192.168.1.24:9200/mydb2/mytype2/\_search?pretty=true'  
> > -d '{"query"
> 
> :{"match\_all":{}},"filter":{"range":{"file\_size":{"from":"2011-09-02","to":"201
> 
> > 1-10-01"}}}}'
> 
> Why are you using the field 'file\_size' as a date field? That doesn't  
> seem to make much sense. In your previous email, you have a 'date'  
> field.
> 
> So, I think what you're looking for is:
> 
> curl -XGET '[http://127.0.0.1:9200/mydb2/mytype2/\_search?pretty=1](http://127.0.0.1:9200/mydb2/mytype2/_search?pretty=1)' -d '  
> {  
> "query" : {  
> "constant\_score" : {  
> "filter" : {  
> "range" : {  
> "date" : {  
> "lte" : "2011-10-01",  
> "gte" : "2011-09-02"  
> }  
> }  
> }  
> }  
> }  
> }  
> '
> 
> clint

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:02am UTC](https://discuss.elastic.co/t/search-query/4682/43 "2017-07-06T04:02:03Z")

</div>



[Previous page](https://discuss.elastic.co/t/search-query/4682.md?page=2)