Discussion about filtering out draft articles in Sanity.io API query

Hi team, why this is not filter out draft articles https://*******.api.sanity.io/v1/data/query/pre-prod?query=*[_type=='article' && !(_id in path('drafts.*'))]

It's currently looking for something that exactly matches

drafts.

Does it work if you change it to

!(_id in path('drafts.**'))

? Also, it looks like you're using

v1

of the API. You may also want to change over to a more recent version .

without url encoding

once url encoded, I will get a result but draft articles also included in the result

encoded URL: https://*******api.sanity.io/v2021-10-21/data/query/pre-prod?query=%2A%5B_type%3D%3D%2[…]26%20%21%28_id%20in%20path%28%27drafts.%2A%2A%27%29%29%5D

drafts not filter out from above URL as well, updated api version and used this filter !(_id in path('drafts.**'))

Where are you running this query? If you run it in Vision do you get the correct results? I can't verify it since you've blocked out your document id.

Where are you running this query? If you run it in Vision do you get the correct results? I can't verify it since you've block out your document id.

Thank you very much Racheal, I'll test this on vison and let you know.

by default is it send two article objects if article is in draft status

What do you get if you run the query with the snippet I gave:

*[_type == 'article' && !(_id in path('drafts.**'))]

. Again, also make sure that you're not using v1 of the API in Vision.

I got it 🙂. once you create a article and if you never published it, then it has only a draft id. when you filter out articles from this !(_id in path('drafts.**')) those never published articles will get filtered but articles which are published at first then edited by someone won't get filtered.

Thank you very much for your quick response and guidance 😊

Happy to help! It's always fun to see folks have this start to click for them!

Hi is there a way of filter out both draft and previous state from the article list if article has a draft version.

I want to remove both 1 and 5 due to 'content test' article has a it's draft version. and I just want to select only 0, 2, 3, 4 from this article list.

Hey Dineth! You'd use the same method for excluding drafts that we worked through yesterday. As soon as edits are made to a published document, the

_id

will have the

drafts.

prepended to it again.

yes, got it. thank you Racheal 🙌

You're welcome!