Duplicates in Vision but not in Desk

This is a common issue! You're seeing duplicates in Vision but not in the Desk (Structure) tool because they handle document queries differently.

What's happening:

Vision queries your Content Lake directly and returns all documents that match your query, including both draft and published versions. The Desk tool, however, is smart about this - it automatically filters and merges these versions to show you just one entry (preferring the draft version when it exists).

In Sanity, when you edit a document, it creates a draft with an ID like drafts.your-doc-id while the published version keeps the ID your-doc-id. Vision sees these as two separate documents, but the Desk tool knows they're the same document in different states.

To diagnose the issue:

You can use this GROQ recipe to identify duplicates. Run this in Vision:

*[_type == $type] {
  "duplicates": *[_type == $type && @[$findDups] == ^[$findDups] && _id != ^._id && !(_id in path('drafts.**'))] {_id, $findDups: @[$findDups]}
}[count(duplicates) > 0]

// Params
{
  "type": "yourDocumentType",
  "findDups": "title"
}

Replace "yourDocumentType" with your actual document type and "title" with the field you want to check for duplicates.

To fix your Vision query:

If you want Vision to show results like the Desk tool, you can filter out drafts:

*[_type == "yourType" && !(_id in path("drafts.**"))]

Or use a newer API version (like v2021-03-25 or later) with the published perspective, which automatically handles this for you.

Is this actually a problem?

If you're only seeing drafts.doc-id and doc-id pairs, this is completely normal and not a problem - it's just how Sanity's draft/publish system works. If you're seeing true duplicates (multiple documents with the same content but different IDs), then you may need to clean up your data.