For AI agents: a documentation index is available at https://www.mongodb.com/docs/llms.txt — markdown versions of all pages are available by appending .md to any URL path.

Docs Menu

/ /

Design Search for Your Data Model

/

/

/

Design Search for Your Data Model

/

/

/

Design Search for Your Data Model

How to Run MongoDB Search Queries Across Multiple Collections

Run MongoDB Search queries across multiple collections using $lookup, $unionWith, or materialized views. Select your deployment type, interface, and language below to view the appropriate tutorial.

Deployment Type

Interface

Back

Embedded Documents

Next

Use Compatible Views

Rate this page

On this page

Search Joined Collections
Considerations
Create the MongoDB Search Index
Run $lookup with $search to Search the Collections
Combine Query Results
Create the MongoDB Search Indexes
Run $unionWith with $search to Search the Collections
Run MongoDB Search Queries Using Materialized Views
Create the purchaseOrders Collection
Create and Update the Materialized View
Create a MongoDB Search Index on the Materialized View
Run a Query on the Materialized View

On this page

Search Joined Collections
Considerations
Create the MongoDB Search Index
Run $lookup with $search to Search the Collections
Combine Query Results
Create the MongoDB Search Indexes
Run $unionWith with $search to Search the Collections
Run MongoDB Search Queries Using Materialized Views
Create the purchaseOrders Collection
Create and Update the Materialized View
Create a MongoDB Search Index on the Materialized View
Run a Query on the Materialized View