Skip to content

Instantly share code, notes, and snippets.

@dboss101

dboss101/aggs_query.json Secret

Created February 28, 2018 15:57
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 dboss101/21e897d957ef44e6f9a73b9fc39a8305 to your computer and use it in GitHub Desktop.
Save dboss101/21e897d957ef44e6f9a73b9fc39a8305 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
aggs_query.json
{
"query": {
"bool": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"must": [{
"match": {
"title": {
"query": "black",
"boost": 3,
"type": "phrase",
"slop": 1
}
}
}],
"should": []
}
},
"aggs": {
"PriceMin": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"PriceMin": {
"min": {
"field": "someAtt.price"
}
}
}
},
"PriceMax": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"PriceMax": {
"max": {
"field": "someAtt.price"
}
}
}
},
"Manufacturer": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Manufacturer": {
"terms": {
"field": "attributes.Manufacturer.keyword",
"size": 10
}
}
}
},
"Pattern": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Pattern": {
"terms": {
"field": "attributes.Pattern.keyword",
"size": 10
}
}
}
},
"Protection": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Protection": {
"terms": {
"field": "attributes.Protection.keyword",
"size": 10
}
}
}
},
"HeelHeight": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"HeelHeight": {
"terms": {
"field": "attributes.HeelHeight.keyword",
"size": 10
}
}
}
},
"BandColour": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"BandColour": {
"terms": {
"field": "attributes.BandColour.keyword",
"size": 10
}
}
}
},
"BandWidth": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"BandWidth": {
"terms": {
"field": "attributes.BandWidth.keyword",
"size": 10
}
}
}
},
"CuffStyle": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"CuffStyle": {
"terms": {
"field": "attributes.CuffStyle.keyword",
"size": 10
}
}
}
},
"Gender": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Gender": {
"terms": {
"field": "attributes.Gender.keyword",
"size": 10
}
}
}
},
"WaterResistance": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"WaterResistance": {
"terms": {
"field": "attributes.WaterResistance.keyword",
"size": 10
}
}
}
},
"Width": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Width": {
"terms": {
"field": "attributes.Width.keyword",
"size": 10
}
}
}
},
"LensTechnology": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"LensTechnology": {
"terms": {
"field": "attributes.LensTechnology.keyword",
"size": 10
}
}
}
},
"Collar": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Collar": {
"terms": {
"field": "attributes.Collar.keyword",
"size": 10
}
}
}
},
"CupSize": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"CupSize": {
"terms": {
"field": "attributes.CupSize.keyword",
"size": 10
}
}
}
},
"Length": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Length": {
"terms": {
"field": "attributes.Length.keyword",
"size": 10
}
}
}
},
"BandMaterial": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"BandMaterial": {
"terms": {
"field": "attributes.BandMaterial.keyword",
"size": 10
}
}
}
},
"Material": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Material": {
"terms": {
"field": "attributes.Material.keyword",
"size": 10
}
}
}
},
"Style": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Style": {
"terms": {
"field": "attributes.Style.keyword",
"size": 10
}
}
}
},
"SupportType": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"SupportType": {
"terms": {
"field": "attributes.SupportType.keyword",
"size": 10
}
}
}
},
"StrapMaterial": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"StrapMaterial": {
"terms": {
"field": "attributes.StrapMaterial.keyword",
"size": 10
}
}
}
},
"Wash": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Wash": {
"terms": {
"field": "attributes.Wash.keyword",
"size": 10
}
}
}
},
"SleeveLength": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"SleeveLength": {
"terms": {
"field": "attributes.SleeveLength.keyword",
"size": 10
}
}
}
},
"Series": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Series": {
"terms": {
"field": "attributes.Series.keyword",
"size": 10
}
}
}
},
"Rise": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Rise": {
"terms": {
"field": "attributes.Rise.keyword",
"size": 10
}
}
}
},
"AgeRange": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"AgeRange": {
"terms": {
"field": "attributes.AgeRange.keyword",
"size": 10
}
}
}
},
"SizeMap": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"SizeMap": {
"terms": {
"field": "attributes.SizeMap.keyword",
"size": 10
}
}
}
},
"OperatingSystem": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"OperatingSystem": {
"terms": {
"field": "attributes.OperatingSystem.keyword",
"size": 10
}
}
}
},
"ColourMap": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"ColourMap": {
"terms": {
"field": "attributes.ColourMap.keyword",
"size": 10
}
}
}
},
"LensColour": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"LensColour": {
"terms": {
"field": "attributes.LensColour.keyword",
"size": 10
}
}
}
},
"FaceColour": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"FaceColour": {
"terms": {
"field": "attributes.FaceColour.keyword",
"size": 10
}
}
}
},
"ManufacturerWarranty": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"ManufacturerWarranty": {
"terms": {
"field": "attributes.ManufacturerWarranty.keyword",
"size": 10
}
}
}
},
"BandSize": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"BandSize": {
"terms": {
"field": "attributes.BandSize.keyword",
"size": 10
}
}
}
},
"Type": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Type": {
"terms": {
"field": "attributes.Type.keyword",
"size": 10
}
}
}
},
"Fit": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Fit": {
"terms": {
"field": "attributes.Fit.keyword",
"size": 10
}
}
}
},
"CompatibleOperatingSystem": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"CompatibleOperatingSystem": {
"terms": {
"field": "attributes.CompatibleOperatingSystem.keyword",
"size": 10
}
}
}
},
"AttachmentType": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"AttachmentType": {
"terms": {
"field": "attributes.AttachmentType.keyword",
"size": 10
}
}
}
},
"FrameColour": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"FrameColour": {
"terms": {
"field": "attributes.FrameColour.keyword",
"size": 10
}
}
}
},
"Features": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Features": {
"terms": {
"field": "attributes.Features.keyword",
"size": 10
}
}
}
},
"Network": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Network": {
"terms": {
"field": "attributes.Network.keyword",
"size": 10
}
}
}
},
"StorageCapacity": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"StorageCapacity": {
"terms": {
"field": "attributes.StorageCapacity.keyword",
"size": 10
}
}
}
},
"BandType": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"BandType": {
"terms": {
"field": "attributes.BandType.keyword",
"size": 10
}
}
}
},
"Inseam": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Inseam": {
"terms": {
"field": "attributes.Inseam.keyword",
"size": 10
}
}
}
},
"Attachment": {
"filter": {
"bool": {
"must": [{
"term": {
"inactiveVisibility": "ByAll"
}
}, {
"term": {
"status": "Active"
}
}, {
"term": {
"someAtt.status": "Active"
}
}, {
"exists": {
"field": "someAtt.id"
}
}],
"must_not": [{
"term": {
"someAtt.Id": "someId"
}
}]
}
},
"aggs": {
"Attachment": {
"terms": {
"field": "attributes.Attachment.keyword",
"size": 10
}
}
}
}
},
"size": 0,
"from": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment