Skip to main content

Projection in MongoDB



In MongoDB, projection means selecting only the necessary data rather than 

selecting the whole of the data of a document. If a document has 5 fields and 

you need to show only 3, then select only 3 fields from them.


You may also like MongoDb insert.


1)Projection in find.



Here 0 means not to project i.e exclusion and 1 means project i.e inclusion as per MongoDB.

Projection cannot have a mix of inclusion and exclusion but only the _id field can exclude with inclusion.



db.collection("companies").find({name:"Dvara SmartGold"},{projection: { _id:0,id: 1, name: 1 } }).toArray()



Or



db.collection("companies").find({name:"Dvara SmartGold"}).project({_id:0,id: 1, name: 1}).toArray()



This will give us all documents inside companies collection as per filter with only name and id fields.



2)Projection in findOne.



db.collection("companies").findOne({name:"Dvara SmartGold"},{projection: { _id:0,id: 1, name: 1 } })

//This will give us one document inside companies collection as per filter with only name and id fields.



3)Projection in Arregation.

db.collection('companies').aggregate([

    {

        $match: { 'name': 'Dvara SmartGold' },

    },

    {



        $lookup: {

            from: "partners",

            localField: "id",

            foreignField: "refid",

            as: "partner"

        }

    },

    {

        $project: {

            id: 1,

            name: 1,

            partner: 1

        },

    },



]).toArray();



This will give us documents inside companies collection and also we have join partners collection as per filter with only name, partner, and id fields.

Comments

Post a Comment

Popular posts from this blog

Coding Interview Questions Set 1

From this article, I will be sharing with you all a series of articles on coding interview questions. So please stay connected for the latest set of questions. It will be a good brainstorming exercise and will also prepare you for coding interviews and will definitely boost your confidence. So let's start, 1)Reverse of a string with only O(1) extra memory. Solution: var reverse = function(string) {     let result = ''     for(let i= string.length -1; i >= 0; i--){         result += string[i];     }     return result; }; 2)Fizz Buzz: Write a program that will accept a number n and will output number till n but for multiples of three it should output “Fizz” instead of the number and for the multiples of five output “Buzz”. For numbers which are multiples of both three and five output “FizzBuzz”. Solution: var fizzBuzz= function(n) {     const arr=[]     for(i=1; i<=n; i++){ ...
9 comments
Read more

JavaScript: Debouncing | Flipkart UI Interview Question.

To understand this programming practice will go with a quick example. We all do online shopping and we do search for products on Flipkart on the search bar. So when we type on search bar i.e on every keypress we are actually giving API requests to the server, which in response gives us suggestions. Actually, it's a time-consuming task and may degrade the performance of the webpage. So to improve the performance we use debounce function which actually acts as a controller which reduces the API request to the server on keypress event. In simple terms, we are giving API request only after a certain amount of time between two keypress events. A debounce is a higher-order function. Higher-order function: A function that returns another function. Let's dive deep: HTML Code: <input type="text" onkeyup="searchProducts()"/> Consider this as a search bar for Flipkart. On any keypress, we are calling searchProducts() function. Javascri...
Post a Comment
Read more

Node.js: Bundling your Node.js application to single executable for Windows.

In this article, we will see how to bundle Node.js application to a single executable for Windows. What's the need? Well recently, I had taken a work where I needed to convert pdf's(Of similar format) to excel sheet. So I was reading the pdf's from a folder in desktop and I was storing the output excel sheet into a separate folder on the desktop. I used Node.js for the program. Now the client wanted it to install the program on 25 windows machine and his budget was really low. So it was also not possible for me to install node.js for 25 machines and then install the required dependency for each one. One of the solution: While I was searching for an easy solution I found this amazing npm module pkg . This module can make your node.js app work like plug and play type. No need to install Node.js on the client machine or any other dependency.  It helps to make a commercial or trial version of your node.js application without exposing the source code. I found ...
Post a Comment
Read more