How to fetch only the product attributes that its category lists in GROQ.

Hello. I'm in need of some (hopefully) quick GROQ help. My documents of type "category" have a list of references to documents of type "attribute". My documents of type "product" has a reference to a category and also have a list of "attributes". How can I make it so my query fetches only the product attributes that its category lists?To visualize, the query would theoretically be something like

*[_type == "product"] { "attrs": attributes[attrRef in @.category.attributeRefs] }

, but this doesn't work. Any ideas?

So, if I'm understanding your structure correctly:

Thanks for replying. My question is basically how to get the list of attributes from the category and only get THOSE attributes from my product, which is why I tried the "in" operator

Ah, I see now. You did previously mention that. You need to implement something much more complicated then! Something more along the lines of this . Just to get it kickstarted, maybe something like:
You may or may not need the

^

before category.

This is what I have so far:
The important part here is that "attributes[].atribute" is the actual attr reference, whereas mainCategory->featuredAttributes is an array of attr references. This is what I've been trying so far but it's just not working whatsoever and I don't understand fully why. The list of mainCategory->featuredAttributes[] is retrieved successfully no problem, but for some reason "attribute in mainCategory->featuredAttributes[]" just doesn't work at all

Ok, so attributes are references to an attribute reference, not strings?

Oh I finally got it. The issue was trying to "in" the object itself.

attributes[attribute._ref in ^.mainCategory->featuredAttributes[]._ref]

worked