Add the tag `"urgent"` to the `tags` array of ticket `_id: 1`. Return the ticket.
Problem Statement
Examples
Input: tickets collection: +-----+-----------------+----------------+ | _id | subject | tags | +-----+-----------------+----------------+ | 1 | Login Bug | ["bug","auth"] | | 2 | Feature Request | ["feature"] | +-----+-----------------+----------------+
Output: +-----+-----------+-------------------------+ | _id | subject | tags | +-----+-----------+-------------------------+ | 1 | Login Bug | ["bug","auth","urgent"] | +-----+-----------+-------------------------+
Explanation: The target document is modified according to the update operators and the updated document is returned.
Complexity
Time Complexity: -
Space Complexity: -
Hints
Editorial & Approach
Problem Overview & Intuition
To solve "Push to Array ($push)", we query the MongoDB document store. The goal is to add the tag `"urgent"` to the `tags` array of ticket `_id: 1`. return the ticket. 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) {
db.tickets.updateOne({ _id: 1 }, { $push: { tags: "urgent" } });
return db.tickets.findOne({ _id: 1 });
}
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.