Search In Array of String

Saurav_Dudeja · February 25, 2021, 2:35pm

I want to search on the below document on basis of data in the label array.

e.g. All Docs with labels contains: “soft_engg”.

[
{
“panel_survey”: {
“completed”: false,
“deleted”: false,
“labels”: [
“soft_engg”,
“english”,
“male”,
“computer”
]
}
}
]

Can someone please help me with this?

vsr1 · February 25, 2021, 3:20pm

CREATE INDEX ix1 ON mybucket(DISTINCT labels);
SELECT * 
FROM mybucket
WHERE ANY v IN labels SATISFIES v = "soft_engg" END;

Saurav_Dudeja · February 25, 2021, 3:28pm

Thanks a lot. Can you help me with the JPA query as well?

vsr1 · February 25, 2021, 3:36pm

Don’t know what is JPA query. Open a separate post, any one can help you.