What is the best way to retrieve values from a nested mongodb object?

I am currently working with a Company mongodb structure that looks like this:

{ "companyName" : "SomeCompany",


"Products" : [
        {
            "productId" : "e3rQACssGkfp9zsue",
            "productCode" : "271102502",
            "memberPrice" : "200",
        },
        {
            "productId" : "e3rQACssGkfp9zsue",
            "productCode" : "271102502",
            "memberPrice" : "500",
        },
    ]
}

Within each Company, there is a nested object called Products with its own set of attributes. My goal is to loop through this object and only print out the memberPrice from Products. I have attempted to achieve this using the following code snippet:

console.log(Company.Products.memberPrice)

Unfortunately, this code returns undefined...

javascriptmongodbobject

Answer №1

Utilize the forEach() method of the array to loop through the element's property:

var obj = { 
    "companyName" : "SomeCompany",
    "Products" : [
        {
            "productId" : "e3rQACssGkfp9zsue",
            "productCode" : "271102502",
            "memberPrice" : "200",
        },
        {
            "productId" : "e3rQACssGkfp9zsue",
            "productCode" : "271102502",
            "memberPrice" : "500",
        },
    ]
};

obj.Products.forEach(function(product){
    console.log(product.memberPrice); // 200, 500
})

-- UPDATE --

If you wish to iterate through the object in the mongo shell, you may consider the following approach (credits to @Michael), using the find() cursor's forEach() method:

db.collection.find().forEach(function(doc){
    doc.Products.forEach(function(p){ 
        print(p.memberPrice);
    });
});

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Tips on retrieving an item using jQuery's select2 plugin

How can I retrieve the value (flight_no) from the processResults function in order to populate the airline name with the respective flight number when selected? I've attempted to access the (flight_no) within the processResults function, but I'm ...

javascriptphpjqueryajaxjquery-select2

Encountering issues with loading Angular formControl

I've been going through an Angular tutorial on forms, which you can check out here. In my 'datasources.component.html' file, I have the following code: <form [formGroup]="queryForm"> <label>Query: <input type="text" formCont ...

javascriptangular

Extract TypeScript classes and interfaces from a consolidated file

I am seeking a way to consolidate the export of my classes, interfaces, and enums from multiple files into a single file. In JavaScript, I achieved this using the following method: module.exports = { Something = require("./src/something").default, ...

javascriptnode.jstypescriptecmascript-6module

Django Crispy Forms do not support JavaScript functionality

In my project, I am working on creating a client form where the country, province, and city are selected based on different models: class Country(models.Model): Country = models.CharField(max_length=100, unique=True) def __str__(self): ...

javascriptdjangodjango-crispy-forms

typescript scrolling location

In my Angular UI code, I have a component class that includes the following structure: app.component.html //... <div class="banner"> <p-dialog [(visible)]="displayCOI" styleClass="coiDialog" [contentStyle]=" ...

javascriptangulartypescript

Enhance your SVG progress circle by simply selecting checkboxes

I have a unique system with 5 checkboxes that act as a To-Do list. When I click on each checkbox, the circle's diameter should progressively fill up in increments of 1/5 until all 5 checkboxes are completed. The order in which the checkboxes are click ...

javascripthtmlcsssvgcheckbox

What is the best way to utilize a promise for a singular variable?

In my code, I have a requirement where I need to make two HTTP requests. The second request is dependent on information retrieved from the first request. Initially, the first request sets the variable 'amount' which is later used in the second re ...

javascriptnode.jsrequestpromisebluebird

What is the best way to pinpoint the origin of the element.style being injected by JavaScript?

I've been tasked with updating a client's WordPress website, but I'm still getting acquainted with the overall structure of the site. When looking at the blog page (), I noticed that posts are displayed within a wrapper labeled #blogleft, a ...

javascripthtmlcssweb-inspector

Error message: Invalid input for directive, only numeric values are accepted

I need help with a directive that restricts non-numeric symbols in an input field. Below is the code for the directive: import { NgControl } from "@angular/forms"; import { HostListener, Directive } from "@angular/core"; @Direct ...

javascriptangulartypescriptangular-directiveangular-decorator

The querySelector function is now encountering errors due to a change in the data

Currently, I am utilizing a query selector to retrieve an input when a user selects different buttons. Initially, the buttons had options such as: 8x10 inch 12x16 inch 20x24 inch However, I made changes to the options format like so: 8" x 10" ...

javascripthtml

Having trouble with Discord.js version 12 and the messageReactionAdd event not triggering properly?

client.on('messageReactionAdd', (reaction, user) => { console.log('If you see this I actually work...'); }); I am having some trouble with my code. Despite setting up a simple console log, it seems like the code is not running prope ...

javascriptnode.jsvisual-studio-codediscord.js

Encountering an Uncaught TypeError when attempting to read properties of undefined, specifically 'backdrop', while incorporating a bootstrap 5 modal within a react environment

An issue occurred when attempting to display a Bootstrap 5 modal using JavaScript. const handleClick = (e) => { e.preventDefault(); const modalElement = document.getElementById('editUserModal'); const modal = Modal.getOrCreateInsta ...

javascriptreactjsbootstrap-5bootstrap5-modal

Having trouble with implementing the .addclass function in a dice roller project

I'm looking to have the element with id=die load initially, and then on a button click event labeled "click me," apply the corresponding CSS class such as 'die1,' 'die2,' and so forth. function roll() { var die = Math.floor(Ma ...

javascriptjqueryhtmlcss

The variables $invalid and $valid in my AngularJS form have not been assigned any values

I came across a post on StackOverflow discussing the issue of both "myForm.$valid" and "myForm.$invalid" being undefined on an Angular form. However, my problem is slightly different. I have defined a form like this: <form name="EntityForm" role="form ...

javascriptangularjs

Switch back and forth between adding and removing a table row using jQuery

Currently, I am developing a drop-down feature for a table that populates its data using MySQL. The functionality involves creating a new table row below the current one when a user clicks a button. However, instead of generating multiple new rows each tim ...

javascriptjqueryhtmlhtml-table

The 'file' property of undefined throws an error in ng-file-upload

I am currently exploring the functionality of ng-file-upload from this repository: https://github.com/danialfarid/ng-file-upload I have successfully implemented the basic setup as follows: HTML: <section ng-controller="MyController"> ...

javascriptangularjsdom-eventsng-file-upload

Sort columns using drag and drop feature in jQuery and AngularJS

Utilizing the drag and drop feature of jquery dragtable.js is causing compatibility issues with AngularJs, hindering table sorting functionality. The goal is to enable column sorting by clicking on the th label and allow for column rearrangement. Currentl ...

javascriptjqueryhtmlangularjs

Struggling to make partial updates to a field within my CRUD update function

Currently, I am working on developing a CRUD application using NodeJS and Express to enhance my backend programming skills. The database being used for this project is MongoDB. This particular project serves as a back office for a shop without any frontend ...

javascriptnode.jsmongodbexpressmongoose

Creating a mandatory and meaningful text input in Angular 2 is essential for a

I am trying to ensure that a text material input in my app is mandatory, with a message like "Please enter issue description." However, I have noticed that users can bypass this by entering spaces or meaningless characters like "xxx." Is there an npm pac ...

javascriptc#asp.netangulartypescript

Looking for a way to streamline data transfer using script setup in Vue 3? Consider utilizing composables to simplify the process

In the scenario where there is a parent component labeled as "1" with two child components named "2" and "3", each of these components containing its own child component, "4" for "2" and "5" for "3", the challenge arises on how to pass state from child c ...

javascriptvue.jsvue-propsemitcomposable