Ive a simple document with two arrays with in it as below.
I want to select items in Array A that doesn’t exist in Array B.
{
"id":"234233232311",
"A": ["1234", "1233", "1222"],
"B": ["1234", "1233", "1225"]
}
In the above doc, the item in Array A (1222) need to be selected in query result as it doesn’t exists in B.
How can I achieve with N1ql?