$replaceWith (Replace With)

Last updated: 2026-10-09

$replaceWith (Replace With)

$replaceWith is like $replaceRoot but tolerates null or missing expression results, keeping the original document instead of failing. It fits promote-if-possible scenarios. Everything else matches $replaceRoot semantics.

CategoryCore Stages
MongoDB Version4.2+
Example Languagemongosh (Shell)

📝 Syntax

{ $replaceWith: <document expression> }

⚙️ Parameters

document expressionExpression whose result replaces the document; may be null or missing.

Returns:Replaced document stream (original kept when result is null)

▶ Example

Run the commands below in your local mongosh (requires a running mongod):

// $replaceWith: promote detail when present
db.orders.aggregate([
  { $replaceWith: '$detail' }
])

Output:

// Orders with detail output it; others pass through unchanged

📌 Notes

More hands-on cases coming soon.

📚 Related Tutorials

❓ FAQ

QWhat is the difference between $replaceWith and $replaceRoot?
A$replaceWith emits the original document when the result is null; $replaceRoot errors.
QHow do I merge several fields into a new document?
ACombine with $mergeObjects, e.g. { $replaceWith: { $mergeObjects: ['$a', '$b'] } }.
QDoes $replaceWith keep _id?
ANo, unless the expression explicitly includes _id.
Web-Tutorial.com

Web-Tutorial Tech Team

A team of developers maintaining programming tutorials. Each tutorial is written and reviewed by developers with expertise in that field. We work to keep our content accurate and reliable — if you spot an issue, please let us know.

100%

🙏 帮我们做得更好

我们是刚上线的编程教程站,几个人的小团队,精力有限。页面虽经检查,难免还有疏漏——链接失效、排版错乱、内容有误、语言生硬……

如果您发现了,麻烦告诉我们,我们会在收到反馈后第一时间进行修复,再次感谢您的光临 🙏