Find a single patient document with `_id: "p2"` from the `patients` collection.
Problem Statement
Examples
Input: patients collection: +-----+---------+-----+ | _id | name | age | +-----+---------+-----+ | p1 | Alice | 30 | | p2 | Bob | 45 | | p3 | Charlie | 28 | +-----+---------+-----+
Output: +-----+------+-----+ | _id | name | age | +-----+------+-----+ | p2 | Bob | 45 | +-----+------+-----+
Explanation: The query projects only the requested document fields matching the criteria.
Complexity
Time Complexity: -
Space Complexity: -
Hints
Editorial & Approach
Problem Overview & Intuition
To solve "Find One Document (findOne)", we query the MongoDB document store. The goal is to find a single patient document with `_id: "p2"` from the `patients` collection. Using a targeted find query, the database engine filters and structures the BSON documents efficiently.
Step-by-Step Approach
- Identify Target Collection: Access the collection through the
dbinstance. - Construct Query / Pipeline: Build the query filter with appropriate comparison operators.
- Resolve Cursor: Invoke
.toArray()to transform the query cursor into the required array of documents.
Optimal Implementation (MongoDB)
function solve(db) {
return db.patients.findOne({ _id: "p2" });
}
Complexity Analysis
Key Considerations & Edge Cases
- Empty Collections: If no documents match, the query cleanly returns an empty array
[]. - Missing / NULL Fields: Missing fields in documents are handled safely without throwing runtime exceptions.
- Type Coercion: BSON types (ObjectId, Numbers, Strings) are compared strictly according to MongoDB specifications.