Hi Guys,
I have some problem with filtered query.
I need to add some filter like this
in sql is like mtart in ('NLAG','ROH') AND werks in ('F230','F232') OR waers in ('RMB') AND zzcgrp in ('Venice')
so I used filtered query like this
MUST (mtart:NLAG or mtart:ROH) AND (werks:F230 or werks:F232)
MUST (waers:RMB) AND (zzcgrp:Venice)
and for query criteria, I used query_string.
So if if type mtart:HALB the result should be empty because I just want to show mtart=NLAG or mtart=ROH.
Can anyone help me?? Thanks
here is my query but when I tried to run this query. only one terms remaining. I don't know what the problem is??
{
"query" : {
"filtered" : {
"filter" : {
"bool" : {
"must" : {
"terms": {
"mtart": [
"roh",
"nlag"
]
}
},
"must" : {
"terms": {
"werks": [
"f230",
"f232"
]
}
},
"must" : {
"terms": {
"waers": [
"rmb"
]
}
},
"must" : {
"terms": {
"zzcgrp": [
"venice"
]
}
}
}
},
"query": { "query_string": {
"query": "HALB"
}}
}
}
}
when I run the query will become
{
"query": {
"filtered": {
"filter": {
"bool": {
"must": {
"terms": {
"zzcgrp": [
"venice"
]
}
}
}
},
"query": {
"query_string": {
"query": "HALB"
}
}
}
}
}