Search_query

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.ukwrote:

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

Sir!
My database is-

Overview http://192.168.1.100:5984/_utils/index.html
pureanalyzer_datafeed_dbhttp://192.168.1.100:5984/_utils/database.html?pureanalyzer_datafeed_db
86407801915707392

Fields Field Value _id86407801915707392*_rev*
2-aa89d0fc127e8ba0c21486278ff1f085BusinessAreaConfiguration
GeoEnabledtrueIndustryRelevancy
IsEnglishtrueIsTweetyesLocationNew Britain, CT USA*
MessageEfluencerIndex*
NamejjcrocketPlaceFullNameNew Britain, CTPlaceNameNew Britain*
ReplyUserID21619519ResultType*
RetweetfalseSourcewebSystemCreatedAt2011-06-30SystemModifiedAt
2011-06-30ToUserID
ToUserName
TweetContryUnited StatesTweetCountryCodeUSTweetCreatedAtThu Jun 30
12:16:40 +0000 2011TweetData@joenbc @morningmika Obama is the most
arrogant, condescending brat ever in the White House. Two flights on
CorporateJetAirForceOne today!!TweetLatitude
TweetLongigttude
UserEfluncerIndex
UserGenderunknownUserID17250739UserNamejjcrocketpolarity0
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.ukwrote:

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' -d '
{
"query" : {
"constant_score" : {
"filter" : {
"range" : {
"date" : {
"lte" : "2011-10-01",
"gte" : "2011-09-02"
}
}
}
}
}
}
'

clint