python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - groq

How do I query referenced document fields within an array of objects in Sanity with GROQ?

I have a document which has an array of objects of which one of the fields is a reference to another document. The following query returns the referenced document _id and _type only, and I need other ...
test-img

Anthony

sanity

groq

Votes: 0

Answers: 1

Latest Answer

You need to do a join on the reference: *[slug.current == $slug] { title, slug, objectArray[] { documentReference-> } } The syntax objectArray[] can be thought of as "for each ele...
test-img

Alexander Staubo

How to filter Sanity.io dataset based on a field on references

How to get all posts by a category slug in GROQ? You can see that a post is added to one or more categories. I would like to get all posts by a category slug to show the posts on a category page. I am...
test-img

Ben Jonson

sanity

groq

Votes: 0

Answers: 1

Latest Answer

I got the solution at Sanity's slack channel. The following code helps to get the posts from a category by it's slug. `*[_type == 'post' && $slug in categories[]->slug.current ]`;
test-img

Ben Jonson

Sanity.io GROQ: retrieve documents that have a key defined inside array of objects

I have documents that look like this { "_type": "celeb", "name": "foo", "facts: [ {a: 1, topics: {_ref: 'asd', _type: 'reference'}}, {a: 2}, ...
test-img

M.K. Safi

sanity

groq

Votes: 0

Answers: 1

Latest Answer

defined(foo) is just shorthand for foo != null, so that won't work. The solution is to count: *[_type == 'celeb' && count(facts[].topics) > 0]
test-img

Alexander Staubo

How to compare arrays in GROQ

I have a blog with sanity CMS and I want to request related posts depending on corresponding tags from the current post which means I have to compare two arrays of tags. My tags are described in post ...
test-img

Quentin C

subquery

sanity

groq

array-comparison

Votes: 0

Answers: 1

Latest Answer

The count trick should work, but since you are comparing multiple tags against multiple tags, you need to iterate over them: count(tags[@ in ^.^.tags]) > 0 In other words, it filters the tags by w...
test-img

Alexander Staubo

Posts

Questions

Blogs

Jobs