How I Merged Two MongoDB Collections Using $unionWith

While working on a doctor listing feature, I encountered an issue where some doctors were missing from the All Doctors page.

After investigating the issue, I found that data was being fetched from two separate collections, and pagination was being applied independently. This resulted in inconsistent results and unnecessary complexity.

The Problem

I had two collections:

• ReferralUser
• user_managements

Fetching data separately caused:

• Multiple API calls
• Missing records
• Inconsistent pagination
• Additional frontend logic

The Solution

MongoDB's $unionWith aggregation stage allowed me to combine both collections into a single pipeline.

js
`db.ReferralUser.aggregate([
 {
 $unionWith: {
 coll: "user_managements"
 }
 }
]);`
---

Benefits
Reduced multiple API calls into one
Improved pagination consistency
Simplified frontend logic
Easier to maintain
Key Takeaways

When working with similar data across multiple collections, $unionWith can help simplify the API and provide more consistent results.

Thanks for reading! 🚀