findOneAndUpdate nested object in array

Question

Trying to use findOneAndUpdate() to change an object inside an array within MongoDB. The documentation for mongoDB's nodeJS driver isn't clear to me. The document looks like this:

{
  _id:ObjectID(),
  some: string,
  body: string,
  steps:[
   [0]{name: "foo", state:"Q"},
   [1]{name: "bar", state:"Q"},
   [n]{name: "fooBar", state:"Q"}
 ]
}

I need to lookup the steps name (foo) and set it's state to P (for in progress) and then to C (for complete) when the task has been executed or E when it errors.

I'll then need to also grab the name of the next step to.

Finding the document isn't hard as I will have the _id already, it's the update portion that's getting me.

EDIT: This is what I've got so far

  async msg => {
    const _id = msg.content.toString();
    const id = new objectId(_id);
    logger.info(`${name} consumer - Recieved new task, fetching details`, {
      id
    });
    try {
      const jobDetails = await collection.findOneAndUpdate(
        { _id: id },
        {
          /**/
        }
      );
      await consumer.task(jobDetails);
    } catch (e) {}
  },

It's the framework for a rabbitMQ consumer

Added existing code, though it's incomplete. The area I need is in the /* */ — Alistair Hardy
– Alistair Hardy, Commented Jun 10, 2019 at 13:26
So basically you did nothing in terms of writing the update query apart from stating that docs are not clear. Sounds like "write it for me" question. Take a look at docs.mongodb.com/manual/reference/method/… it has some almost copy-pasteable examples for your usecase. — Alex Blex
– Alex Blex, Commented Jun 10, 2019 at 13:34
No, I'd read that, but I if you don't understand the documentation, it's hard to apply it to your use case. — Alistair Hardy
– Alistair Hardy, Commented Jun 10, 2019 at 14:02

Daniyal Lukmanov · Accepted Answer · 2019-06-10 13:39:56Z

13

I don't know how would you choose wich letter to set - P, C or E, because it is not quite clear, but for replacing a value in mongoDB it would look like this (let's say for 'P'):

myCollection.findOneAndUpdate({"_id": docId, "steps.name": "foo"},
    {$set: {"steps.$.state": "P"}})

Find the document you need to change.
Find the object inside the array "steps.name": "foo". And you get the position of that object in array.
You're setting new value for the object's property ( $ reflects the position).

edited Jun 10, 2019 at 13:39

answered Jun 10, 2019 at 13:33

Daniyal Lukmanov

1,22912 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alistair Hardy Over a year ago

Thanks, that did the trick. I know when to set each state. P is set when the consumer receives the task, C when it completes the job and E when it errors (so in the catch(e){...} ).

tmsnvk Over a year ago

thanks, dude! I was looking for a solution like this.

Collectives™ on Stack Overflow

findOneAndUpdate nested object in array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related