How to get a relatedProducts array in GROQ, excluding the product itself.

For all GROQ experts here, I’m trying to do something that I thought would be easy but can’t figure it out for now.I’m trying to get a

relatedProducts

array, with all the products of the same

productType (reference)

(i.e Seating), excluding the product itself.Any ideas on how I could achieve that?

API: 2021-06-07

feel like you can do a

&& __id != ^.__id

or something close

How about:

yeah i just searched my own code for my own related and the _id != ^.id is working, i do see I sometimes reference the ^.__ref not sure why (sorry slack just keeps removing the _)

Note that this will repeat the same products in every item, which is a bit inefficient. You can save latency and bandwidth by first fetching all the products and doing a separate query to find all products related to the first batch.

Perfect! thanks guys 🙌

are you possibly suggesting a like allProducts.json you save down to static to diff against? I’ve done that for some clients probably improves query speed and non-noticable diff in the static rendering

i’ve actually used ricos next-plugins to do this for header/footer stuff

I’ve also used ricos plugins to do something similar, but I’m interested to know more

like imagine that query on 1000 products, vs do it once and pull related products on the client side from a lodash _find lookup or something

i guess if it’s a like 100 product site? maybe no big deal?

No, I mean doing a separate GROQ query after the one above it. It’s also possible to do two queries in one go:
There’s some additional complexity in matching products to related products, but shouldn’t be too bad. It’s also a question of trade-offs — if you have very few products, maybe it doesn’t make sense.

I have like 200+ products for now, but it’ll increase for sure

I love that chair, by the way. 🙂 Are you building a vintage furniture shop?

Yeah 😅