The documentation says the following but doesn't make any mention of options that has spaces
For example, if you have a product option called "Size," you can use productOptions.size.value in your code (note that the case of the name doesn't matter). If you have a product option called "Color," you use productOptions.color.value. You can also use any custom options you may have defined. The name you use is the name of the option in your store.
I have a productOption called "Base Color" and I have tried:
let result = await wixData.query('Stores/Products')
.hasSome('productOptions.base color.value', '#f2f2f2')
.hasSome('productOptions["Base Color"].value', '#f2f2f2')
.hasSome('productOptions.baseColor.value', '#f2f2f2')
.hasSome('productOptions.base color.description', 'white')
.hasSome('productOptions["Base Color"].description', 'white')
.hasSome('productOptions.baseColor.description', 'white')
None of these work.
Same issue
bump