Schema Specification for a Document - Is There a Way to Specify That Field To Be Unique?
6 repliesLast updated: Jul 13, 2020
In schema specification for a document, is there a way to specify that I want a field to be unique? That no two documents with the same content in that field can exist? I find myself cleaning up duplicates quite a lot...
If this is an array field for example, you could add the
unique()function to the validation. This requires all values within the array to be unique by doing a deep comparison.
{
title: 'Category Set',
name: 'categorySet',
type: 'array',
of: [{type: 'string'}],
validation: Rule => Rule.unique()
}Hmm... Can the validation rule be put on other types as well, or does it have to be an array?
Given this:
I want the
Given this:
type: 'document',
title: 'Language texts',
name: 'i18n',
fields: [
{
name: 'key',
title: 'Identifier',
type: 'string',
},
{
name: 'value',
title: 'Translations',
type: 'localeString',
},
]keyfield to be unique.
Yes it can be applied to the
keyfield. Thank you very much! 🙂
Indeed! Thanks for posting back 🙂
Well I was a bit quick on reporting success with the validation rule here. The
That leaves me with trying to create a custom rule which queries for document keys on input. Anybody have a clue as to how I can query existing objects inside a custom rule?
uniquerule is not valid on document descriptors. I wish it was.
That leaves me with trying to create a custom rule which queries for document keys on input. Anybody have a clue as to how I can query existing objects inside a custom rule?
Found it: https://sanity-io-land.slack.com/archives/C9Z7RC3V1/p1562247073232000?thread_ts=1562246653.231700&cid=C9Z7RC3V1
This should be part of the documentation.
This should be part of the documentation.
Was this answer helpful?
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.
