ES Aggregations

aggs_data.json

#Delete the index if one exists
curl -XDELETE 'http://localhost:9200/products' && echo
 
#Create a new products index
curl -XPUT 'http://localhost:9200/products' -d '{}'  && echo
 
#Create SKU's under producsts index
curl -XPUT 'http://localhost:9200/products/item/0011' -d '{"categories":["men","baby"],"Brand":"diesel","active":1,"listprice":10,"offerprice":5,"size":"small","offers":["Clearance"],"name":"","shortDescription":"V-necked casual slip dress with spaghetti straps and flowery print","longDescription":"V-necked dress that can be worn in any season and suitable for every occasion. Look like a dream in this flowery print with the wind ruffling the uneven hem and your hair."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0012' -d '{"categories":["men","baby"],"Brand":"Calvin Klein","active":1,"listprice":20,"offerprice":20,"size":"Medium","offers":["Price Cut"],"name":"","shortDescription":"Brown microsuede mid-calf boots with stilettos and modern buckle","longDescription":"Mid-calf boots that can be slipped on and buckled up with minimum effort. The clean lines, platform, and stilettos enhance the classic silhouette. Elegant and comfortable, these boots have a soft microsuede upper, padded insole, and the soft lining."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0013' -d '{"categories":["women","men"],"Brand":"Levis","active":1,"listprice":30,"offerprice":20,"size":"Large","offers":["Sale"],"name":"","shortDescription":"Black leather stiletto boots with almond toe","longDescription":"Clean lines and stilettos define this classic design. The silhouette is perfect and add miles to your legs. The slightly padded footbed and the soft lining keep your feet cosy. Dress up your feet with the stylish shaft and the almond toe."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0014' -d '{"categories":["baby"],"Brand":"Volcom","active":0,"listprice":30,"offerprice":20,"size":"Large","offers":["Sale"],"name":"","shortDescription":"Black leather stiletto boots with almond toe","longDescription":"Clean lines and stilettos define this classic design. The silhouette is perfect and add miles to your legs. The slightly padded footbed and the soft lining keep your feet cosy. Dress up your feet with the stylish shaft and the almond toe."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0015' -d '{"categories":["men"],"Brand":"Puma","active":0,"listprice":30,"offerprice":10,"size":"Large","offers":["Sale"],"name":"","shortDescription":"Black leather stiletto boots with almond toe","longDescription":"Clean lines and stilettos define this classic design. The silhouette is perfect and add miles to your legs. The slightly padded footbed and the soft lining keep your feet cosy. Dress up your feet with the stylish shaft and the almond toe."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0016' -d '{"categories":["men"],"Brand":"Puma","active":0,"listprice":30,"offerprice":5,"size":"Large","offers":["Sale"],"name":"","shortDescription":"Black leather stiletto boots with almond toe","longDescription":"Clean lines and stilettos define this classic design. The silhouette is perfect and add miles to your legs. The slightly padded footbed and the soft lining keep your feet cosy. Dress up your feet with the stylish shaft and the almond toe."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0017' -d '{"categories":["men"],"Brand":"Puma","active":0,"listprice":30,"offerprice":2,"size":"Large","offers":["Sale"],"name":"","shortDescription":"Black leather stiletto boots with almond toe","longDescription":"Clean lines and stilettos define this classic design. The silhouette is perfect and add miles to your legs. The slightly padded footbed and the soft lining keep your feet cosy. Dress up your feet with the stylish shaft and the almond toe."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0018' -d '{"categories":["women"],"Brand":"Volcom","active":0,"listprice":30,"offerprice":20,"size":"Large","offers":["Sale"],"name":"","shortDescription":"Black leather stiletto boots with almond toe","longDescription":"Clean lines and stilettos define this classic design. The silhouette is perfect and add miles to your legs. The slightly padded footbed and the soft lining keep your feet cosy. Dress up your feet with the stylish shaft and the almond toe."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0019' -d '{"categories":["women"],"Brand":"Volcom","active":0,"listprice":30,"offerprice":20,"size":"Large","offers":["Sale"],"name":"","shortDescription":"Black leather stiletto boots with almond toe","longDescription":"Clean lines and stilettos define this classic design. The silhouette is perfect and add miles to your legs. The slightly padded footbed and the soft lining keep your feet cosy. Dress up your feet with the stylish shaft and the almond toe."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0020' -d '{"categories":["women"],"Brand":"Volcom","active":0,"listprice":30,"offerprice":20,"size":"Large","offers":["Sale"],"name":"","shortDescription":"Black leather stiletto boots with almond toe","longDescription":"Clean lines and stilettos define this classic design. The silhouette is perfect and add miles to your legs. The slightly padded footbed and the soft lining keep your feet cosy. Dress up your feet with the stylish shaft and the almond toe."}'  && echo
curl -XPUT 'http://localhost:9200/products/item/0021' -d '{"categories":["women"],"Brand":"Volcom","active":0,"listprice":30,"offerprice":20,"size":"Large","offers":["Sale"],"name":"","shortDescription":"Black leather stiletto boots with almond toe","longDescription":"Clean lines and stilettos define this classic design. The silhouette is perfect and add miles to your legs. The slightly padded footbed and the soft lining keep your feet cosy. Dress up your feet with the stylish shaft and the almond toe."}'  && echo

aggs_query.json

#Get Navigation results for all products in men's category
curl -XGET 'http://localhost:9200/products/_search?pretty=true' -d '{
     "from" : 0, "size" : 5,
    "query" : {
        "match" : { "categories" : "men" }
    },
	"aggs" : {
	       "offerprice" : {
			"range" : {
				"field" : "offerprice",
				"keyed" : true,
				"ranges" : [
				    { "to" : 5 },
				    { "from" : 5, "to" : 10},
				    { "from" : 10, "to" : 20},
				    { "from" : 20, "to" : 30}
				]
			}
		},
	       "size" : {"terms" : {"field" : "size","order": { "_count" : "asc" }}},
	       "Deals" : {"terms" : {"field" : "offers","order": { "_count" : "asc" }}},
	       "Brand" : {"terms" : {"field" : "Brand","order": { "_count" : "desc" }}}
	},
	"sort" : [{"offerprice" : {"order" : "asc", "mode" : "avg", "ignore_unmapped":true, "missing":"_last"}},"_score"]
	    
}'


# Get search results and facets for men's category, filter by facet selection Brand = "diesel"
curl -XGET 'http://localhost:9200/products/_search?pretty=true' -d '{
    "from" : 0, "size" : 5,
    "query": {"filtered": {"filter": {"term": {"Brand": "diesel"}}, "query": { "term" : { "categories" : "men" }}}},
	"aggs" : {
	       "offerprice" : {
			"range" : {
				"field" : "offerprice",
				"keyed" : true,
				"ranges" : [
				    { "to" : 5 },
				    { "from" : 5, "to" : 10},
				    { "from" : 10, "to" : 20},
				    { "from" : 20, "to" : 30}
				]
			}
		},
	       "size" : {"terms" : {"field" : "size","order": { "_count" : "asc" }}},
	       "Deals" : {"terms" : {"field" : "offers","order": { "_count" : "asc" }}},
	       "Brand" : {"terms" : {"field" : "Brand","order": { "_count" : "desc" }}}
	},
	"sort" : [{"offerprice" : {"order" : "asc", "mode" : "avg", "ignore_unmapped":true, "missing":"_last"}},"_score"]
	    
}'


# Get search results and facets for men's category, filter by facet selection Brand = "diesel" and Size "small"
curl -XGET 'http://localhost:9200/products/_search?pretty=true' -d '{
    "from" : 0, "size" : 5,
    "query": {"filtered": {"filter": {
                "and": [
                {
                    "term": {
                        "Brand":"diesel"    
                    }
                    
                },
                {
                    "term": {
                        "size":"small"
                    }
                    
                }]
            }, "query": { "term" : { "categories" : "men" }}}},
	"aggs" : {
	       "offerprice" : {
			"range" : {
				"field" : "offerprice",
				"keyed" : true,
				"ranges" : [
				    { "to" : 5 },
				    { "from" : 5, "to" : 10},
				    { "from" : 10, "to" : 20},
				    { "from" : 20, "to" : 30}
				]
			}
		},
	       "size" : {"terms" : {"field" : "size","order": { "_count" : "asc" }}},
	       "Deals" : {"terms" : {"field" : "offers","order": { "_count" : "asc" }}},
	       "Brand" : {"terms" : {"field" : "Brand","order": { "_count" : "desc" }}}
	},
	"sort" : [{"offerprice" : {"order" : "asc", "mode" : "avg", "ignore_unmapped":true, "missing":"_last"}},"_score"]
	    
}'