You can view a collection's validation rules to determine what restrictions are imposed on documents and how MongoDB handles invalid documents when they occur.
To view a collection's validation rules, use the db.getCollectionInfos() method or listCollections database command.
Both commands return the same information, but the output format differs between each command.
To run the examples on this page, create a students collection with validation rules. For more information, see Specify JSON Schema Validation.
The following command uses db.getCollectionInfos() to return the validation rules for the students collection:
db.getCollectionInfos( { name: "students" } )[0].options.validatorThe output resembles the following validation object:
{ '$jsonSchema': { bsonType: 'object', required: [ 'name', 'year', 'major', 'address' ], properties: { name: { bsonType: 'string', description: 'must be a string and is required' }, year: { bsonType: 'int', minimum: 2017, maximum: 3017, description: 'must be an integer in [ 2017, 3017 ] and is required' }, gpa: { bsonType: [ 'double' ], description: 'must be a double if the field exists' } } }}If validationAction and validationLevel are not explicitly set, db.getCollectionInfos() does not include those fields in its output.
The following command uses listCollections to return the validation rules for the students collection:
db.runCommand ( { listCollections: 1, filter: { name: "students" } } )The output resembles the following object:
{ cursor: { id: Long("0"), ns: 'test.$cmd.listCollections', firstBatch: [ { name: 'students', type: 'collection', options: { validator: { '$jsonSchema': { bsonType: 'object', required: [ 'name', 'year', 'major', 'address' ], properties: { name: { bsonType: 'string', description: 'must be a string and is required' }, gpa: { bsonType: [ 'double' ], description: 'must be a double if the field exists' } } }, validationAction: 'warn' } }, info: { readOnly: false, uuid: UUID("bf560865-5879-4ec1-b389-f77a03abbc5a") }, idIndex: { v: 2, key: { _id: 1 }, name: '_id_' } } ] }, ok: 1}RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4