My filter requirement (contains(record.Distribution,#item.code != 'AM')) However, I encountered the issue of the filter returning a document that an array Distributed object with multiple codes in example 2.json. Is that because an array Distribution object has multiple codes? How can I fix the logic not to return 2.json?
For examples:
1.json
{
"record":{
"Distribution":[
"code": "AM",
"Desc": ""
]
}
}
2.json
{
"record":{
"Distribution":[
{
"code": "XD",
"Desc": ""
},
{
"code": "AM",
"Desc": ""
}
]
}
}