Help with GROQ query to select blog posts with specific category in Sanity

Hello everyone! How are you?I'm still stuck with the same problem.

actually I want to make a GROQ query that selects all my blog post with a category with the slug "content-marketing".

I search this problem in google and find a solution at StackOverflow, but it doesn't work for me.

How can i do that?

Thanks for your reply.

Its doesn't work 😔

Looks like it didn’t copy over quite right. You’ll want

slug.current]

after the

->

.

I'm sorry.

But I want to use this query in sanity vision, so I replace slug.current with content-marketing. Am I wrong?

Don’t be sorry! It can be confusing stuff to get used to.
It’s actually the query itself that will do that work for you. That’s what the
part is doing. It’s saying “traverse through each of the categories in the

categories

array (that’s in

post

documents), get the actual category documents (using the

->

dereference operator—otherwise, you’ll only have the reference properties), get

slug.current

for each of those documents and put them into an array, and finally, see if any of them are

content-marketing

. Where they are, return that

post

document.”
All of that said, it assumes that your schema is set up with

post

documents that have an array of references named

categories

that references your category documents, and that they have a slug on them.

Don’t be sorry! It can be confusing stuff to get used to.
It’s actually the query itself that will do that work for you. That’s what the
part is doing. It’s saying “traverse through each of the categories (in

post

documents), get the actual category documents (using the

->

dereference operator—otherwise, you’ll only have the reference properties), get

slug.current

for each of those documents and put them into an array, and finally, see if any of them are

content-marketing

. Where they are, return that

post

document.

Thanks a lot.

No problem. If it still doesn’t work, you can post what you get when you run

*[_type == 'post']

and we’ll figure it out from there.

Can i share my category schema with you?

This is my category schema

This is my post schema

Ahh, perfect! So this is a direct reference rather than an array of references (meaning you can only ever select one). My fault for assuming otherwise.
You’ll want to change your query so that rather than looking for a string in an array, you’re testing equality. You’ll remove the array traversal of categories (

[]

) and will change

in

to

==

. Can you try this?

Thanks a lot ❤️. Its work. Many many thanks

You’re welcome. Have fun building!

Hello sir! I need some help, if you are free.

Hello sir! I need some help, if you are free.