Query to match with a array

SQL++
,
1

Hi,

I am getting the data from my query

select activityGroups.activities from application UNNEST activityGroups where META().id =‘app1’
[
{
“activities”: [
“View1”
]
},
{
“activities”: [
“changeview”,
“ChangeDescription”
]
},
{
“activities”: [
“ViewGroup”,
“ViewUser”
]
},
{
“activities”: [
“AddUser”,
“DeleteUser”,
“GrantAppAccess”,
“ModifyUser”
]
},
{
“activities”: [
“SimulatorUser”
]
},
{
“activities”: [
“GrantSAMDescriptionAccess”,
“GrantSAMAdminAccess”
]
},
{
“activities”: [
“AppConfiguration”
]
}
]

Trying to modify the query to match with a array so that it will return matched data
Let have the array [“View1”,“changeview”]

Want a result like
[
{
“activities”: [
“View1”
]
},
{
“activities”: [
“changeview”,
“ChangeDescription”
]
}
]

Is it possible??

2

I tried with ARRAY_INTERSECT(activityGroups.activities,[“View1”,“changeview”])

It is giving the result as well as empty objects too

3

add predicate AND ARRAY_LENGTH(ARRAY_INTERSECT(activityGroups.activities,[“View1”,“changeview”])) > 0;

4

Hi,
You just save me…
Thank you very much…