MongoDB $toBool Operator

What You’ll Learn

The $toBool operator converts values to boolean (true or false) in MongoDB aggregation pipelines. Use it to normalize mixed-type flags, clean imported data, and prepare fields for conditional logic.

Definition and Usage

In MongoDB’s aggregation framework, the $toBool operator converts an expression to a boolean value. It is part of the type-conversion family alongside $toInt, $toString, and $toDate. Real-world data often stores flags as numbers (0/1), strings ("yes"/""), or actual booleans — $toBool helps normalize them.

$toBool is shorthand for { $convert: { input: <expression>, to: "bool" } }. It follows MongoDB’s built-in boolean conversion rules rather than JavaScript’s truthiness rules.

📝 Syntax

The $toBool operator takes one expression:

{ $toBool: <expression> }

Literal Examples

{ $toBool: 1 }
// Result: true

{ $toBool: 0 }
// Result: false

{ $toBool: "" }
// Result: false

{ $toBool: "hello" }
// Result: true

{ $toBool: "$isActive" }
// Convert the isActive field

Conversion Rules

• null — returns null.
• Boolean — returns the same boolean value.
• Number — 0, -0, and NaN become false; all other numbers become true.
• String — empty string "" becomes false; any non-empty string becomes true.
• Array — empty array becomes false; non-empty array becomes true.
• Date, ObjectId, document — non-null values become true.
• Use inside $project, $addFields, or $set.

Examples Gallery

Normalize mixed-type user flags, convert numeric 0/1 values, and filter documents after boolean conversion.

[
  { "_id": 1, "name": "Alice", "active": true },
  { "_id": 2, "name": "Bob",   "active": 0 },
  { "_id": 3, "name": "Carol", "active": 1 },
  { "_id": 4, "name": "Dave",  "active": "" },
  { "_id": 5, "name": "Eve",   "active": "enabled" }
]

db.users.aggregate([
  {
    $project: {
      name: 1,
      active: 1,
      isActive: { $toBool: "$active" }
    }
  }
])

{ "_id": 1, "name": "Alice", "active": true,      "isActive": true }
{ "_id": 2, "name": "Bob",   "active": 0,        "isActive": false }
{ "_id": 3, "name": "Carol", "active": 1,        "isActive": true }
{ "_id": 4, "name": "Dave",  "active": "",       "isActive": false }
{ "_id": 5, "name": "Eve",   "active": "enabled","isActive": true }

db.products.aggregate([
  {
    $addFields: {
      inStock: { $toBool: "$stockCount" }
    }
  }
])

// stockCount: 0   → inStock: false
// stockCount: 15  → inStock: true
// stockCount: -3  → inStock: true (non-zero)

db.orders.aggregate([
  {
    $project: {
      orderId: 1,
      hasItems: { $toBool: "$items" },
      hasNotes: { $toBool: "$notes" }
    }
  }
])

// items: ["a", "b"]  → hasItems: true
// items: []          → hasItems: false
// notes: ""           → hasNotes: false
// notes: "rush"       → hasNotes: true

db.users.aggregate([
  {
    $addFields: {
      isActive: { $toBool: "$active" }
    }
  },
  {
    $match: {
      isActive: true
    }
  },
  {
    $project: {
      name: 1,
      isActive: 1
    }
  }
])

// Returns Alice, Carol, and Eve (active values that convert to true)
{ "_id": 1, "name": "Alice", "isActive": true }
{ "_id": 3, "name": "Carol", "isActive": true }
{ "_id": 5, "name": "Eve",   "isActive": true }

db.settings.aggregate([
  {
    $project: {
      viaToBool: { $toBool: "$flag" },
      viaCond: {
        $cond: [
          { $eq: [ "$flag", "true" ] },
          true,
          false
        ]
      }
    }
  }
])

// flag: "false"
// viaToBool → true  (non-empty string!)
// viaCond   → false (explicit comparison)

🚀 Use Cases

• Data migration cleanup — normalize legacy 0/1 integer flags to proper booleans.
• Feature flags — convert mixed-type settings fields before conditional logic.
• Presence checks — test whether strings or arrays are empty with a boolean result.
• Reporting filters — create a clean boolean field, then filter or group on it.
• ETL pipelines — prepare boolean columns for export to systems that require strict types.

💡 Best Practices