This is our query
{
"from": 0,
"size": 30,
"sort": [
{
"ins": {
"order": "desc"
}
},
"_score"
],
"query": {
"bool": {
"filter": {
"bool": {
"must": [
],
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "child_d"
}
}
}
},
{
"term": {
"child_d": "1"
}
}
]
}
},
"must": {
"function_score": {
"query": {
"bool": {
"filter": {
"bool": {
"must": [
{
"exists": {
"field": "pr"
}
},
{
"exists": {
"field": "bid"
}
},
{
"exists": {
"field": "sw"
}
}
],
"must_not": [
{
"ids": {
"values": [
21,
22,
23
]
}
},
{
"terms": {
"me": [
1,
2
]
}
},
{
"terms": {
"v_id": [
]
}
}
]
}
},
"must": {
"bool": {
"should": [
{
"multi_match": {
"query": "samsung",
"analyzer": "word_delimiter_analyzer",
"fields": [
"c_name^2",
"br^3",
"cfp^1.1",
"na^1.2",
"chil",
"desc",
"attr",
"attri_l^1.2"
],
"type": "cross_fields",
"tie_breaker": 0.3,
"minimum_should_match": "100%"
}
}
]
}
}
}
},
"functions": [
{
"script_score": {
"script": {
"lang": "expression",
"inline": "0 + (log10((doc['pvc'].value * pow(0.9, doc['pm_updated_at'].value ? ( 1537813800000 - doc['pm_updated_at'].value)/(24*60*60*1000): 0))+1)*(2))"
}
}
}
],
"boost_mode": "sum",
"score_mode": "sum"
}
}
}
},
"post_filter": {
"bool": {
"must": [
{
"terms": {
"bid": [
"222222"
]
}
}
]
}
},
"aggs": {
"categories": {
"filter": {
"bool": {
"must": [
{
"exists": {
"field": "pri"
}
},
{
"terms": {
"bid": [
"2222"
]
}
}
]
}
},
"aggs": {
"cats": {
"terms": {
"field": "cid",
"order": {
"_count": "desc"
},
"size": 50
}
}
}
},
"bra": {
"filter": {
"bool": {
"must": [
{
"exists": {
"field": "pr"
}
},
{
"terms": {
"bid": [
"2222"
]
}
}
],
"must_not": [
{
"terms": {
"bid": [
3333 ]
}
}
]
}
},
"aggs": {
"brds": {
"terms": {
"field": "bid",
"order": {
"_count": "desc"
},
"size": 50
}
}
}
},
"min_pr": {
"filter": {
"bool": {
"must": [
{
"exists": {
"field": "pr"
}
},
{
"terms": {
"bid": [
"3333"
]
}
}
]
}
},
"aggs": {
"min_pr": {
"min": {
"field": "pr"
}
}
}
},
"max_pr": {
"filter": {
"bool": {
"must": [
{
"exists": {
"field": "pr"
}
},
{
"terms": {
"bid": [
"333"
]
}
}
]
}
},
"aggs": {
"max_pr": {
"max": {
"field": "pr"
}
}
}
}
}
}