I have a product metafield custom.roomvo, it’s a boolean field, I’m trying to query all products where it’s set to true. Here’s what I have for the query:
Shopify’s product search syntax does not support filtering by metafeilds, so metafields.custom.roomvo:true is simply ignored which is why you get 0 results.
The query parameter only works with indexed fields like title, vendor, tag, etc.
To filter by a metafield, you must either:
Fetch products first and filter client-side, or
Use the Storefront API with a metafield filter, or
Store the value in a tag (e.g. roomvo:true) and query by that tag.
So the query isn’t wrong, it’s just not supported by Shopify’s Admin API search.
Test queries t in shopify’s graphiql app, before trying to roundtrip everything through flow:
Unless it’s the forum software bungling text make sure your using ACTUAL straight quotes: " "
Don’t blindly copy stuff out of code generators, and especially don’t copy things out of microsoft word/excel with formatting.
I saw that.
My point is – if it worked for me, then it should work for you too and the problem is somewhere else which we can’t pinpoint because we only have information you gave us.
Also – metafield query works for me too.