Skip to content

Instantly share code, notes, and snippets.

@bryanmtl
Created December 9, 2012 19:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bryanmtl/4246638 to your computer and use it in GitHub Desktop.
Save bryanmtl/4246638 to your computer and use it in GitHub Desktop.
Elastic search data query not returning results
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