Get help on Discord

GROQ Query - Can I Get Draft Version of a Document Referenced by the Parent Document?

3 replies

Last updated: Jul 28, 2022

Hello all. Need some help in knowing if this is practically allowed in GROQ query.Can I get the draft version of the document (if present, else published) referenced by the parent document with id
xxxx (and not

drafts.xxxx

). So if parent document is referencing

xxxx

, can I show the draft document drafts.xxxx if it exists even though the direct reference of the draft is not added in parent?I tried using match, coalesce but do not seem to get the expected result.

https://groq.dev/jonYis0Kvftcb7RPxZO62V

Jul 27, 2022, 6:03 PM

Something like this should work… interestingly it’s matching against docs with the same

_rev

attribute

*[_type == "user" && _id == "5766c34-8b0f-db36-67ef-7a0df57770c8"]
{
  ...,
  posts[]->{
    ...,
    "hasDraft": *[_type == "post" && _id in path("drafts.**")]
  }
}

Jul 27, 2022, 6:25 PM

Thanks

user J

for the response. Turns out I was able to get what I was looking for from below GROQ -

*[_type == "user"]
{
  ...,
  'posts': *[_type == 'post' && (_id in (^.posts[]._ref )|| _id in ^.posts[]{ '_ref': 'drafts.'+_ref }._ref )]
}

Jul 28, 2022, 1:03 PM

This gives both versions (draft & published) of the referenced document which can be fed into a system which can determine which version to pick. Thanks for the lead.🤘 Regarding the

_rev

, I think that was my bad in preparing the mock scenario data.

Jul 28, 2022, 1:06 PM

Sanity – Build the way you think, not the way your CMS thinks

Sanity is the developer-first content operating system that gives you complete control. Schema-as-code, GROQ queries, and real-time APIs mean no more workarounds or waiting for deployments. Free to start, scale as you grow.

Get started for free Explore the demo

Was this answer helpful?