{
"query": {
"bool": {
"must": {
"multi_match": {
"type": "phrase_prefix",
"query": "Text",
"operator": "or",
"fields": [
"engName",
"engName45",
"engShortName"
]
}
}
}
},
"filter": {
"query": {
"bool": {
"should": [
{
"bool": {
"should": [
{
"term": {
"Classification": "bkac"
}
}
],
"must": [
{
"term": {
"isDeleted": "n"
}
},
{
"terms": {
"status": [
"Yes",
"No"
]
}
}
],
"must_not": [
{
"terms": {
"Market": [
"f",
"s",
"fh"
]
}
}
]
}
},
{
"bool": {
"should": [
{
"range": {
"expiryDate": {
"ytd": "2022-11-10"
}
}
}
]
}
}
]
}
}
}
}
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.