MongoDB with mongoose: how to push an object to a nested array of documents?

Question

I have my MongoDB, following this Schema:

   const userSchema = new Schema(
  {
   (...),
    therapy_records: {
     (...),
      daily_record: [
        {
          therapy_day: '',
          date: '',
          consumed: '',
          limit: '',
          goal: '',
          morning_timer: '',
        },
      ],          
  },    
)

I am trying to addAsNewItemIfArrayExists/createIfNotExists pushing a new daily_record object every time, but my code below is just adding and object with only an "_id" without records if daily_record does not exists. It does nothing when it exists.

Can anyone tell which would be the right way to do it? Thx!

const user = await User.findByIdAndUpdate(
  userId,
  {
    therapy_records: {
     (..),
     daily_record: {
          $push: [
            {
              therapy_day: anyNumber,
              date: anyDate,
              consumed: anyNumber,
              limit: anyNumber,
              goal: anyNumber,
              morning_timer: anyNumber,
            },
          ],
        },
      
     (...),
    },
  },
  { new: true, upsert: true }
)

the example above, daily_record: [] is an array but I saw at your code is object daily_record: {} — Siemhong
– Siemhong, Commented Jan 16, 2023 at 9:40

Dmitry Gorbenko · Accepted Answer · 2023-01-16 17:45:52Z

1

You need to use:

const user = await User.findByIdAndUpdate(
  userId,
  {
      $push: {
        'therapy_records.daily_record': {
          therapy_day: *anyNumber*,
          date: *anyNumber*,
          consumed: *anyNumber*,
          limit: *anyNumber*,
          goal: *anyNumber*,
          morning_timer: *anyNumber*,
        },
      },
  },
  { new: true, upsert: true }
)

answered Jan 16, 2023 at 17:45

Dmitry Gorbenko

262 bronze badges

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

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

MongoDB with mongoose: how to push an object to a nested array of documents?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related