Is it possible to update a user story in a project using MongoDB?
I am looking to update the fields of a specific user story within a project by selecting the project based on its id and then selecting the user story within that project based on its id.
Question: What MongoDB query should I use for this task?
MongoDB Database Cut
{
"_id": ObjectId("4ecee95d6ce4004424000001"), //Project ID
"owner": "test2",
"stories": [
{
"_id": "75vUURHfE1bN9vkbwC2kR85s", //User story Id
"title": "ok",
"deadline": "10\/10\/2011",
"description": "ok",
"sp": "5",
"value": "5",
"roi": "1.00",
"type": "story",
"lane": 0
},
{
"_id": "nTsa8x6vFJvdXfFtEHbcFIyl",
"title": "test",
"deadline": "10\/10\/2011",
"description": "test",
"sp": "5",
"value": "5",
"roi": "1.00",
"type": "story",
"lane": 0
},
{
"_id": "i8Nd3HOhz7hZFzzInfCcapCe",
"title": "test #2",
"deadline": "10\/10\/2011",
"description": "test #2",
"sp": "5",
"value": "5",
"roi": "1.00",
"type": "story",
"lane": 0
}
],
"team": [
],
"title": "ok"
}
Using socket.io, I retrieve the following data on a socket event:
JSON
var story = {
_id: data.id,
title: data.title,
deadline: data.deadline,
description: data.description,
sp: data.sp,
value: data.value,
roi: data.roi,
type: data.type
}
I aim to update the story within 'stories' in the mongo database with the provided JSON object above.