I am trying to use the hasSome. According to the documentation:
The hasSome() function refines a WixDataQuery or WixDataFilter to only match items where the array value of the specified property contains any of the specified values.
When I try it it looks the haSome does EQUAL comparison and not CONTAINS. A record is selected only if one of the value in the hasSome fully EQUALS to a value in the collection and not contained in the collection.
if "colors" field of record #1 has the value of: "red,purple" and I do
let newQuery = query.hasSome("colors", "red", "yellow", "blue");
then record #1 will not be selected.
however it will be selected if I do:
let newQuery = query.hasSome("colors", "red,purple", "yellow", "blue");