Searching substrings in an item of a List


(PrgKh) #1

HI

I have a document structure like :

{
"_index": "a",
"_type": "b",
"_id": "1",
"_score": 1,
"_source": {
"cId": 1,
"sampleList": [
"abc rst xyz",
"def xyz",
"rst mno"
],
}
}
{
"_index": "a",
"_type": "b",
"_id": "2",
"_score": 1,
"_source": {
"cId": 2,
"sampleList": [
"abc rst",
"def xyz",
"rst mno"
],
}
}

i want to search for "abc" & "xyz" and it should return only first one i.e. return only those where an item in a list contains both "abc" and "xyz".

What should my query be ?
please suggest

Thanks


(system) #2