Help with GROQ join in Sanity.io for searching products by category.

Hello! I'm new here and am learning Sanity for a job I just got. I've been messing with the default ecommerce dummy data and am having a lot of trouble doing a GROQ join. Basically I am trying to search for a product with a category name, something like this but I am sure I am quite off base what I've tried so far. Thanks for any help 🙂

Welcome M M! When I’m trying more complex GROQ queries, I will usually try to simplify them to isolate the bit that isn’t working for me. In your example, I would try each of the three parts of the

categories

filter on its own to see what works and what doesn’t.
Are you comfortable using Vision for testing?

For example, when you run this do you get data back?

Hey Geoff! Yes I am using vision right now, have been at this for a bit haha. I am just a jr dev so I am comfortable with basic SQL joins but still relatively fresh haha

I get back all my products when I do that query!

so now I need to be able to search my categories table for the slug.current or title

Perfect. I’m wondering about that last bit—`slug.current == 'swedish'`—since the slug will normally be specific to one document.

Rather than typing it in GROQ, what are you hoping for your query to do?

well I am doing various search features for my product list

I have a category select drop down menu that displays dynamically from my getinitialprops in next and was hoping to filter by category

If you remove

&& slug.current == "swedish"

how close do you get to your desired result?

It doesn't, I believe it needs to reference category id somewhere and then search for the category title/slug

I finally got it 🙂

thanks so much for helping me Geoff! Loving Sanity so far, it is really powerful

Excellent! Nice work! 🙌
Yes, it sure is! Enjoy your time with it!
🙂