專案

一般

配置概況

下載 (1.39 KB)

工作單 #305 » query_cardBinGroup_transactionStatus.json

evan lu, 2025-09-09 02:46

 
{
"size": 0,
"query": {
"bool": {
"filter": [
{
"range": {
"create_datetime": {
"gte": "${__from}",
"lt": "${__to}",
"format": "epoch_millis"
}
}
},
{
"term": {
"operator_id": {
"value": "${operator_id}"
}
}
},
{
"term": {
"institute_id": {
"value": "${institute_id}"
}
}
},
{
"script": {
"script": {
"params": {
"merchant": "${merchant_id}"
},
"source": "params.merchant == '*' || doc['merchant_id.keyword'].value == params.merchant"
}
}
}
]
}
},
"aggs": {
"group_by_cardbin": {
"terms": {
"field": "txInfo__cardBin",
"min_doc_count": "${min_count}",
"size": "${display_size}"
},
"aggs": {
"group_by_transStatus": {
"filters": {
"filters": {
"success_status": {
"terms": {
"feedbackInfo__transStatus": [
"A",
"Y",
"I"
]
}
},
"fail_status": {
"bool": {
"must_not": [
{
"terms": {
"feedbackInfo__transStatus": [
"A",
"Y",
"I"
]
}
}
]
}
}
}
}
}
}
}
}
}
(10-10/10)