N1Ql query to find records based on a conditional Array Field

SQL++
1

select _id,categories from content
WHERE _type=“question” AND active=true AND userId= “abcdefghijklmnop”
AND (ANY catg IN IFMISSINGORNULL([[“ALL”, “Math”]],[ ]) SATISFIES catg = categories END)
order by modifiedAt DESC limit 25 offset 0

For the above N1Ql query “categories” field is an array which contains strings .When the input strings matches it should return some result. But it is returning nothing. In couchbase I have many records which contains the following data in “categories”
“categories”: [
“All”
“Math”
“English”
“Magic”
]

How should I query it so that it will return all the records if there is atleast one element matches the "categories " field

2 
SELECT _id, categories
FROM content
WHERE _type = "question" AND active = true AND userId = "abcdefghijklmnop"
AND (ANY catg IN categories SATISFIES catg IN ["ALL", "Math"] END)
ORDER BY modifiedAt DESC
OFFSET 0
LIMIT 25;
3

The query is working fine, but it is not returning any data in one particular case. There are many records where “categories”: [“All”].When I am writing the query as

SELECT _id, categories FROM content WHERE _type = “question” AND active = true AND userId = “abcdefghijklmnop”
AND (ANY catg IN categories SATISFIES catg IN [“ALL”] END)
ORDER BY modifiedAt DESC OFFSET 0 LIMIT 25;

I am not getting any value. Can you plzz suggest a solution for this?

4

My mistake…the solution is absolutely working fine…It’s a typo. instead of catg IN [“All”] i wrote catg IN [“ALL”].
Thank you