Here is a method for retrieving all fields within embedded documents at the same level in MongoDB

Question

Here is a method for retrieving all fields within embedded documents at the same level in MongoDB

Thanks to the magic of embedded documents, we can avoid complicated join operations.

Yet, I find myself needing to extract all fields on a single level for creating lists or reports.

Is there a straightforward way to achieve this?

For example; I wish to generate a report including all the mentioned fields. In order to do so, I must flatten the JSON data structure.

{
   "_id": "1",
   "date" : "2014-07-30 02:00",
   "personnel_id": "14",
   "personnel_name": "xxxx Stackton",
   "personnel_city": "nevercity",
   "personnel_province": "neverland",
   "customer_id": "473",
   "customer_name": "xxxx Jordan",
   "payment_method": "cash",
   "payment_amount": "67.40"
}

javascript json mongodb

Answer 1

Answer №1

To loop through the keys of an object, you can use a method similar to how you would with a JSON object.

For example, the code below will display the keys name and age:

var person = { name: 'Sarah', age: 29 };

for(property in person) {
  console.log(property);
}

Answer 2

To loop through the keys of an object, you can use a method similar to how you would with a JSON object.

For example, the code below will display the keys name and age:

var person = { name: 'Sarah', age: 29 };

for(property in person) {
  console.log(property);
}

Here is a method for retrieving all fields within embedded documents at the same level in MongoDB

Answer №1

Similar questions

How can you delete using JavaScript by pressing the "Delete" key?

Creating Test Cases for Service Response Validation

Querying MongoDB for nested documents

Ways to expand the line capacity in the Mongo shell

Here's the proper method to execute this in JavaScript

What is the best way to calculate the number of days between today's date and the end of the current month using Moment.js?

What could be causing the error message "Error: Cannot modify headers after they are sent" to appear?

Can you clarify the typescript type of the Mutation list within the callback function of the mutation observer?

Trigger a random tune when hovering the mouse

Using conditional subscriptions in Meteor at the template level

Why does starting up the Firebase emulators trigger the execution of one of my functions as well?

What is the best method for integrating JavaScript into my Express.js application that is also utilizing Socket.IO?

Exploring the process of assigning custom images to individual items within arrays in React JS

Refreshing an Angular datatable using promises - reload directive

Guide to using a TypeScript interface in a JSON file with Visual Studio Code

Issues with displaying AngularJs directive template

Sorting and Deduplicating MongoDB Data with Reduce

What is the process for retrieving information from a database in Django when the submit button is clicked?

Issue with Angular custom toggle functionality not functioning properly on mobile devices

What are the best practices for integrating Firebase authentication pre-made UI in Next JS?