How can i check an Array with in an Array

SQL++
1

I have a Doc which stores tracking info for some campaigns and i need to check if the user got this one already send.
So the Doc has a Element called emails which is an Array , which holds an object with an email array which can have more then one email address in ti.

"emails": [
      {
        "email": [
          "demo@gmail.com"
        ],
        "track_request": "track_request::2325e70b-52d0-4e23-9da5-71a4525ee368",
        "tracking_nbr": "0m8Bp4lyB"
      },

the basic clause

WHERE ANY v IN c.emails SATISFIES v.email = “demo@gmail.com” END

does not work as email is an array as well

2

WHERE ANY em IN emails SATISFIES (ANY e IN em.email SATISIFIES e = "demo@gmail.com" END) END

OR

WHERE ANY em IN emails SATISFIES "demo@gmail.com" IN em.email END

3

is there any major performance difference between both solutions ? Also how would i only return the email docs which match this clause since it will return all if i say emails in select clause

4

If you are not looking for index then you can use second.

Depends on what output you want.

You can use UNNEST

SELECT em
FROM default AS d
UNNEST d.emails AS em
WHERE "demo@gmail.com" IN em.email

OR

 SELECT ARRAY em FOR em IN d.emails WHEN "demo@gmail.com" IN em.email END AS emails
 FROM default AS d
 WHERE  ANY em IN emails SATISFIES "demo@gmail.com" IN em.email END