"in" clause in wix query

Ask the community
, ,
1

Hi,
I have a collection named “members” in wix database with fields/columns as “regno”, “name”, “email” and etc.
I want to perform a query on it using “in” clause the way we do in sql.

lets say
select * from members where regno in (271,272,273)

how this can be achieved using wix query?

I tried below, but it didn’t work

const results = await wixData.query(“members”)
.hasAll(“regno”, “271”,“272”)
.find();

2

I think you want .hasSome()

3

Hi,
I tried hasSome() as well. It is not returning any value.

const results = await wixData.query(“members”)
.hasSome(“regno”, “271”,“272”)
.find();

4

Add:

.then(res => {
    return res.items[0];
    //or if you need only one key return res.items[0][key];
});
5

And if this “rengo” field is indeed of type Text (if it’s number, remove the quotation marks from the query values).