search - Elasticsearch. Range query for strings with dashes -


i'm using elasticsearch data have string-field date values, this:

"2016-01-25 18:40:18.933"

i'm trying use range filter getting values date date. example: 

    "query" : {         "filtered" : {             "query" : {                 "range" : {                     "createddate" : {                         "gte": "2015-11-01",                          "lte": "2016-01-25"                     }                 }             }         }       }     }

but results doesn't contain values "createddate": "2015-12-14 20:28:23.557"

if use "gte": "2015" or "gte": "2014-12-31", values "createddate": "2015-12-14" included in results.

what's wrong in query?

if want able run range queries on dates, need map field date field, otherwise won't work expect. in mapping shared, createddate string. need wipe index , create new 1 proper mapping createddate field, this:

curl -xpost localhost:9200/documents -d '{    "mappings": {       "order": {          "properties": {              "createddate": {                 "type": "date"              }          }       }    } }'

then can reindex data , range query work expected.


Comments

Post a Comment

Popular posts from this blog

java - Callback from new thread to class from which thread was initiated -

i have class calling new thread. public class mainclass{ private void cleardata() { // on separate thread new thread(new runnable() { @override public void run() { //do //after notify mainclass thing has been done , pass value. } } } private void callbackfunc(int a){ // based on value of } } i have function in mainclass. how call function new thread, receive callback. thanks. you should able call method in mainclass name if calling directly inside mainclass (as opposed inner class). if method name want call happens conflict 1 inner class has inherited object can prefix call mainclass.this , e.g. mainclass.this.tostring() calls tostring on mainclass , whereas tostring() calls on inner class instance.
Read more

Receive udp packets in android gstreamer -

i using eclipse juno in windows 7. doing programming on android 4.2 platform. want receive udp packets in gstreamer application. giving uri udp://127.0.0.1:1234 , sending file vlc player same computer. emulator giving message could not get/set setting from/on resource while in case of rtp, giving message no uri implementer found rtp ideas how receive streaming media in android?
Read more

php - Extract Text from HTTP referer -

i using following code show referer link page on website. how can modify code shows part of link. i.e if website url www.example.com/?s=printing want extract printing. , should happen if format www.example.com/?s=aaa , not if format else www.example.com/printing. code: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; echo $_session["origurl"] ?> i figured out , following code works: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; $mysearchterm = $_server["http_referer"]; $whatiwant = substr($mysearchterm, strpos($mysearchterm, "=") +1); echo $whatiwant; ?>
Read more