MongoDB如何在返回文档全部字段的同时对指定通用字段进行条件赋值

Got it, let's solve this problem cleanly. The core issue here is that we need to keep every field from our product documents (since we don't know all possible fields upfront) while ensuring tax defaults to 0 and gtin defaults to null when those fields are missing.

MongoDB's aggregation framework is perfect for this, specifically using $replaceRoot combined with $mergeObjects and $ifNull. Here's how it works:

Step-by-Step Aggregation Pipeline #

We'll use $$ROOT to reference the entire original document, merge it with our default values for tax and gtin, then replace the root with this merged object. This way, all existing fields are preserved, and only tax/gtin are overridden (or set to defaults if missing).

const Product = mongoose.model('Product', schema);

// Example aggregation query
Product.aggregate([
  {
    $replaceRoot: {
      newRoot: {
        $mergeObjects: [
          "$$ROOT", // Includes all original fields from the document
          {
            tax: { $ifNull: ["$tax", 0] }, // Set to 0 if tax doesn't exist
            gtin: { $ifNull: ["$gtin", null] } // Set to null if gtin doesn't exist
          }
        ]
      }
    }
  }
])
.then(results => {
  console.log(results); // Will match your expected output
})
.catch(err => {
  console.error(err);
});

How This Works #

• $$ROOT: This variable represents the entire original document, so we don't have to manually list every possible field (like package_weight, screen_size, etc.).
• $mergeObjects: Merges the original document with our custom object for tax and gtin. If the original document already has tax or gtin, those values are kept; if not, our defaults are used.
• $ifNull: Checks if the field exists. If it does, returns the field's value; if not, returns our default (0 for tax, null for gtin).

Adding Query Filters (Optional) #

If you need to filter products first (e.g., by product_type), just add a $match stage at the start of the pipeline:

Product.aggregate([
  { $match: { product_type: "Electronics" } }, // Your filter condition
  {
    $replaceRoot: {
      newRoot: {
        $mergeObjects: [
          "$$ROOT",
          {
            tax: { $ifNull: ["$tax", 0] },
            gtin: { $ifNull: ["$gtin", null] }
          }
        ]
      }
    }
  }
])

Testing with Your Sample Data #

Running this pipeline against your two sample products will produce exactly the output you want:

• The Coca-Cola drink gets tax: 0 added (since it was missing)
• The Lenovo laptop gets gtin: null added (since it was missing)
• All other custom fields (package_weight, screen_size, etc.) are preserved.

内容的提问来源于stack exchange，提问作者Avani Khabiya