Created
December 9, 2012 19:30
-
-
Save bryanmtl/4246638 to your computer and use it in GitHub Desktop.
Elastic search data query not returning results
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Query: | |
curl -X GET "http://localhost:9200/spree_products/spree%2Fproduct/_search?from=0&load=false&page=1&per_page=20&size=20&pretty=true" -d '{"query":{"bool":{"must":[{"query_string":{"query":"Carry","default_operator":"AND"}},{"range":{"available_on":{"lte":"2011-12-08T11:43:53Z"}}}]}},"size":20,"from":0}' | |
Returns: | |
{ | |
"took" : 7, | |
"timed_out" : false, | |
"_shards" : { | |
"total" : 5, | |
"successful" : 5, | |
"failed" : 0 | |
}, | |
"hits" : { | |
"total" : 0, | |
"max_score" : null, | |
"hits" : [ ] | |
} | |
}% | |
Without the range: | |
{ | |
"took" : 21, | |
"timed_out" : false, | |
"_shards" : { | |
"total" : 5, | |
"successful" : 5, | |
"failed" : 0 | |
}, | |
"hits" : { | |
"total" : 13, | |
"max_score" : 1.0686294, | |
"hits" : [ { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "39100", | |
"_score" : 1.0686294, "_source" : {"product":{"album_id":34537,"artist_id":23010,"available_on":"2012-01-17T00:00:00Z","count_on_hand":0,"created_at":"2012-09-27T21:59:23Z","deleted_at":null,"description":null,"discontinued_at":"1900-01-01T00:00:00Z","id":39100,"label_studio_number":"PETS RECORDINGS","meta_description":null,"meta_keywords":null,"name":"FRIENDS WILL CARRY YOU HOME","permalink":"friends-will-carry-you-home","rovi_release_id":"MR0003533602","shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-12-07T11:29:05Z","unormalized_artist_name":"FRIENDS WILL CARRY YOU HOME","artist_name":"Various Artists"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "26425", | |
"_score" : 1.0141755, "_source" : {"product":{"album_id":null,"artist_id":11702,"available_on":"2012-06-05T00:00:00Z","count_on_hand":0,"created_at":"2012-09-27T20:25:53Z","deleted_at":null,"description":"IMPORT-CAN","discontinued_at":"1900-01-01T00:00:00Z","id":26425,"label_studio_number":"PID","meta_description":null,"meta_keywords":null,"name":"CURRENT WILL CARRY US","permalink":"current-will-carry-us","rovi_release_id":null,"shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-09-27T20:25:53Z","unormalized_artist_name":"COUNTERPARTS","artist_name":"COUNTERPARTS"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "21", | |
"_score" : 1.0141755, "_source" : {"product":{"album_id":3469,"artist_id":19,"available_on":"2012-10-17T03:39:58Z","count_on_hand":0,"created_at":"2012-09-27T17:35:43Z","deleted_at":null,"description":" NR","discontinued_at":"1900-01-01T00:00:00Z","id":21,"label_studio_number":"MVD/CHERRY RED","meta_description":null,"meta_keywords":null,"name":"CARRY ON UP THE CHARTS","permalink":"carry-on-up-the-charts","rovi_release_id":null,"shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-11-20T23:53:46Z","unormalized_artist_name":"BEAUTIFUL SOUTH","artist_name":"The Beautiful South"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "12408", | |
"_score" : 0.98949826, "_source" : {"product":{"album_id":16551,"artist_id":8014,"available_on":"2004-03-23T00:00:00Z","count_on_hand":1,"created_at":"2012-09-27T18:50:18Z","deleted_at":null,"description":null,"discontinued_at":"1900-01-01T00:00:00Z","id":12408,"label_studio_number":"WEA/RHINO","meta_description":null,"meta_keywords":null,"name":"CARRY IT ON: MUSICAL LEGACY","permalink":"carry-it-on-musical-legacy","rovi_release_id":null,"shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-11-24T05:24:09Z","unormalized_artist_name":"PETER PAUL & MARY","artist_name":"Peter, Paul and Mary"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "28830", | |
"_score" : 0.98949826, "_source" : {"product":{"album_id":null,"artist_id":17894,"available_on":"2005-02-08T00:00:00Z","count_on_hand":1,"created_at":"2012-09-27T20:44:33Z","deleted_at":null,"description":null,"discontinued_at":"1900-01-01T00:00:00Z","id":28830,"label_studio_number":"MARQUIS NON MUSIC VIDEO","meta_description":null,"meta_keywords":null,"name":"CARRY ME HOME","permalink":"carry-me-home","rovi_release_id":null,"shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-10-31T07:14:29Z","unormalized_artist_name":"NATHANIEL DETT CHORALE","artist_name":"Nathaniel Dett"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "69562", | |
"_score" : 0.98949826, "_source" : {"product":{"album_id":32728,"artist_id":38174,"available_on":"2012-12-11T00:00:00Z","count_on_hand":1,"created_at":"2012-11-27T22:53:04Z","deleted_at":null,"description":"IMPORT-GBR","discontinued_at":"1900-01-01T00:00:00Z","id":69562,"label_studio_number":"FICTION","meta_description":null,"meta_keywords":null,"name":"CARRY ON","permalink":"carry-on-3","rovi_release_id":null,"shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-12-09T07:39:36Z","unormalized_artist_name":"MASON,WILLY","artist_name":"Willy Mason"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "9114", | |
"_score" : 0.9519038, "_source" : {"product":{"album_id":5433,"artist_id":6246,"available_on":"2008-12-09T00:00:00Z","count_on_hand":0,"created_at":"2012-09-27T18:29:19Z","deleted_at":null,"description":null,"discontinued_at":"1900-01-01T00:00:00Z","id":9114,"label_studio_number":"FORCEX","meta_description":null,"meta_keywords":null,"name":"CARRY ON SAMPLER 1","permalink":"carry-on-sampler-1","rovi_release_id":"MR0001012888","shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-11-27T21:00:06Z","unormalized_artist_name":"EFDEMIN","artist_name":"Efdemin"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "14724", | |
"_score" : 0.9519038, "_source" : {"product":{"album_id":13371,"artist_id":9579,"available_on":"2009-01-06T00:00:00Z","count_on_hand":0,"created_at":"2012-09-27T19:04:23Z","deleted_at":null,"description":null,"discontinued_at":"1900-01-01T00:00:00Z","id":14724,"label_studio_number":"BURNT TOAST VINYL","meta_description":null,"meta_keywords":null,"name":"CARRY THE WEIGHT","permalink":"carry-the-weight","rovi_release_id":"MR0001008132","shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-11-23T19:38:09Z","unormalized_artist_name":"WITMER,DENISON","artist_name":"Denison Witmer"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "30237", | |
"_score" : 0.9519038, "_source" : {"product":{"album_id":34539,"artist_id":18688,"available_on":"2011-10-11T00:00:00Z","count_on_hand":0,"created_at":"2012-09-27T20:54:45Z","deleted_at":null,"description":null,"discontinued_at":"1900-01-01T00:00:00Z","id":30237,"label_studio_number":"EMM/BRIDGE 9","meta_description":null,"meta_keywords":null,"name":"LIFE LESS PLAGUED","permalink":"life-less-plagued","rovi_release_id":"MR0003456871","shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-12-07T11:29:12Z","unormalized_artist_name":"CARRY ON","artist_name":"Carry On"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "46018", | |
"_score" : 0.9519038, "_source" : {"product":{"album_id":5217,"artist_id":26429,"available_on":"2012-07-17T00:00:00Z","count_on_hand":12,"created_at":"2012-09-27T22:52:03Z","deleted_at":null,"description":null,"discontinued_at":"1900-01-01T00:00:00Z","id":46018,"label_studio_number":"ATO","meta_description":null,"meta_keywords":null,"name":"CARRY ME BACK","permalink":"carry-me-back","rovi_release_id":"MR0003673471","shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-12-09T07:42:07Z","unormalized_artist_name":"OLD CROW MEDICINE SHOW","artist_name":"Old Crow Medicine Show"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "61814", | |
"_score" : 0.9519038, "_source" : {"product":{"album_id":null,"artist_id":6246,"available_on":"2008-12-09T00:00:00Z","count_on_hand":0,"created_at":"2012-09-28T00:41:00Z","deleted_at":null,"description":"IMPORT-EU","discontinued_at":"1900-01-01T00:00:00Z","id":61814,"label_studio_number":"PID","meta_description":null,"meta_keywords":null,"name":"CARRY ON PRETEND WE RE NOT IN THE","permalink":"carry-on-pretend-we-re-not-in-the","rovi_release_id":null,"shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-11-27T21:35:31Z","unormalized_artist_name":"EFDEMIN","artist_name":"Efdemin"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "15729", | |
"_score" : 0.7915986, "_source" : {"product":{"album_id":802,"artist_id":10316,"available_on":"2009-05-19T00:00:00Z","count_on_hand":0,"created_at":"2012-09-27T19:10:39Z","deleted_at":null,"description":"7 INCH SINGLE","discontinued_at":"1900-01-01T00:00:00Z","id":15729,"label_studio_number":"POLYVINYL","meta_description":null,"meta_keywords":null,"name":"YOUR FRIENDS WILL CARRY YOU HOME","permalink":"your-friends-will-carry-you-home","rovi_release_id":"MR0001153198","shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-11-27T21:04:32Z","unormalized_artist_name":"FAUX HOAX","artist_name":"Faux Hoax"}} | |
}, { | |
"_index" : "spree_products", | |
"_type" : "spree/product", | |
"_id" : "39296", | |
"_score" : 0.67309767, "_source" : {"product":{"album_id":3542,"artist_id":22631,"available_on":"2012-07-31T00:00:00Z","count_on_hand":0,"created_at":"2012-09-27T22:01:01Z","deleted_at":null,"description":null,"discontinued_at":"1900-01-01T00:00:00Z","id":39296,"label_studio_number":"CARRY ON","meta_description":null,"meta_keywords":null,"name":"NUFF SAID","permalink":"nuff-said","rovi_release_id":"MR0003722675","shipping_category_id":null,"tax_category_id":null,"updated_at":"2012-11-27T22:36:36Z","unormalized_artist_name":"ELEF","artist_name":"Elef"}} | |
} ] | |
} | |
}% |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment