Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Json – Multiple Mongo validation types on single field?

Can a field validation in MongoDB collection contain string and null both as validation types.

{
  "$jsonSchema": {
    "bsonType": "object",
    "title": "Validations",
    "properties": {
      "t1": {
        "bsonType": "string",
        "description": "label field is required with min. 1 character in length"
      }
    }
  }
}

Can we specify field t1 be either a null or string type?

Tags:

2

Answers


  1. 0

    Just use { "bsonType": [ "null", "string" ] } like the official doc did.

    {
  $jsonSchema: {
    properties: {
      t1: {
        bsonType: [
          'null',
          'string'
        ]
      }
    },
    description: 'label field is required with min. 1 character in length'
  }
}
    Login or Signup to reply.
  2. 0

    I think just add ‘null’ into bsonType. We also could combine with another validation (example with minLength). It will be validated if the value is not null

    {
  "$jsonSchema": {
    "bsonType": "object",
    "title": "Validations",
    "properties": {
      "t1": {
        "bsonType": ["string", "null"],
        "description": "t1 field can be a string with at least [number] character or null",
        "minLength": [number]
      }
    },
  }
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search