Query an array field by string

Discussion Ask a question
,
1

Hi everyone !

I am looking for a method to query a WIX database and return only the items in which a specific string could be contained in one of the item’s array field.

For example, I have a database of videos and I have an Array field called activeUsers where each item looks like this :

item.activeUsers = { "userId" : "000001", "Expiration": "someDate"}

Now I want to query the database and only retieve items that fits a specific userId…

Thank you !

2

Optionally, it would even be easier if I had a method to filter a dataset the same way… I tried this one but it doesn’t work :

$w("#dataset1").setFilter(wixData.filter()
            .hasSome("activeUsers", user.id)
        );