Mongo query to fetch selective fields from the collection [duplicate]












-2
















This question already has an answer here:




  • How to select a single field in MongoDB?

    15 answers




Is it possible to fetch selective fields from mongo collections.



Say if my collections is 



USer_info



{"_id" : ObjectId("56e0a3a2d59feaa43fba49d5", "date":"2018-07-23T00:00:00.000Z", "Name":"ABC", "ID": "1234", "Subjects":"[Maths, Physics, Science, Music]"}

{"_id" : ObjectId("56e0a3a2d5hjhfjtaese45d5", "date":"2018-07-23T00:00:00.000Z", "Name":"BCS", "ID": "3456", "Subjects":"[CS, Physics, Business]"}

{"_id" : ObjectId("56e0a3a2d59feaa43fba49d6", "date":"2018-07-23T00:00:00.000Z", "Name":"XYZ", "ID": "786", "Subjects": "[Agricultar, Business, Music]"}


Query to list only Name and SUbjects fields:



{"Name":"ABC", "Subjects":"[Maths, Physics, Science, Music]"}

{"Name":"BCS", "Subjects":"[CS, Physics, Business]"}

{"Name":"XYZ", "Subjects": "[Agricultar, Business, Music]"}


Not sure if this a duplicate, but i did not get anything similar so posting it.






mongodb mongodb-query pymongo







share|improve this question













marked as duplicate by Neil Lunn mongodb
Users with the  mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
 Nov 24 '18 at 9:31


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.























    -2
















    This question already has an answer here:




    • How to select a single field in MongoDB?

      15 answers




    Is it possible to fetch selective fields from mongo collections.



    Say if my collections is 



    USer_info
    

    
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d5", "date":"2018-07-23T00:00:00.000Z", "Name":"ABC", "ID": "1234", "Subjects":"[Maths, Physics, Science, Music]"}
    
{"_id" : ObjectId("56e0a3a2d5hjhfjtaese45d5", "date":"2018-07-23T00:00:00.000Z", "Name":"BCS", "ID": "3456", "Subjects":"[CS, Physics, Business]"}
    
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d6", "date":"2018-07-23T00:00:00.000Z", "Name":"XYZ", "ID": "786", "Subjects": "[Agricultar, Business, Music]"}


    Query to list only Name and SUbjects fields:



    {"Name":"ABC", "Subjects":"[Maths, Physics, Science, Music]"}
    
{"Name":"BCS", "Subjects":"[CS, Physics, Business]"}
    
{"Name":"XYZ", "Subjects": "[Agricultar, Business, Music]"}


    Not sure if this a duplicate, but i did not get anything similar so posting it.






    mongodb mongodb-query pymongo







    share|improve this question













    marked as duplicate by Neil Lunn mongodb
    Users with the  mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.

    StackExchange.ready(function() {
    if (StackExchange.options.isMobile) return;

    $('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
    var $hover = $(this).addClass('hover-bound'),
    $msg = $hover.siblings('.dupe-hammer-message');

    $hover.hover(
    function() {
    $hover.showInfoMessage('', {
    messageElement: $msg.clone().show(),
    transient: false,
    position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
    dismissable: false,
    relativeToBody: true
    });
    },
    function() {
    StackExchange.helpers.removeMessages();
    }
    );
    });
    });
     Nov 24 '18 at 9:31


    This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.





















      -2












      -2








      -2









      This question already has an answer here:




      • How to select a single field in MongoDB?

        15 answers




      Is it possible to fetch selective fields from mongo collections.



      Say if my collections is 



      USer_info
      

      
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d5", "date":"2018-07-23T00:00:00.000Z", "Name":"ABC", "ID": "1234", "Subjects":"[Maths, Physics, Science, Music]"}
      
{"_id" : ObjectId("56e0a3a2d5hjhfjtaese45d5", "date":"2018-07-23T00:00:00.000Z", "Name":"BCS", "ID": "3456", "Subjects":"[CS, Physics, Business]"}
      
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d6", "date":"2018-07-23T00:00:00.000Z", "Name":"XYZ", "ID": "786", "Subjects": "[Agricultar, Business, Music]"}


      Query to list only Name and SUbjects fields:



      {"Name":"ABC", "Subjects":"[Maths, Physics, Science, Music]"}
      
{"Name":"BCS", "Subjects":"[CS, Physics, Business]"}
      
{"Name":"XYZ", "Subjects": "[Agricultar, Business, Music]"}


      Not sure if this a duplicate, but i did not get anything similar so posting it.






      mongodb mongodb-query pymongo







      share|improve this question















      This question already has an answer here:




      • How to select a single field in MongoDB?

        15 answers




      Is it possible to fetch selective fields from mongo collections.



      Say if my collections is 



      USer_info
      

      
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d5", "date":"2018-07-23T00:00:00.000Z", "Name":"ABC", "ID": "1234", "Subjects":"[Maths, Physics, Science, Music]"}
      
{"_id" : ObjectId("56e0a3a2d5hjhfjtaese45d5", "date":"2018-07-23T00:00:00.000Z", "Name":"BCS", "ID": "3456", "Subjects":"[CS, Physics, Business]"}
      
{"_id" : ObjectId("56e0a3a2d59feaa43fba49d6", "date":"2018-07-23T00:00:00.000Z", "Name":"XYZ", "ID": "786", "Subjects": "[Agricultar, Business, Music]"}


      Query to list only Name and SUbjects fields:



      {"Name":"ABC", "Subjects":"[Maths, Physics, Science, Music]"}
      
{"Name":"BCS", "Subjects":"[CS, Physics, Business]"}
      
{"Name":"XYZ", "Subjects": "[Agricultar, Business, Music]"}


      Not sure if this a duplicate, but i did not get anything similar so posting it.





      This question already has an answer here:




      • How to select a single field in MongoDB?

        15 answers







      mongodb mongodb-query pymongo




      mongodb mongodb-query pymongo






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 21 '18 at 18:17









      RachelRachel

      949




      949




      marked as duplicate by Neil Lunn mongodb
      Users with the  mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.

      StackExchange.ready(function() {
      if (StackExchange.options.isMobile) return;

      $('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
      var $hover = $(this).addClass('hover-bound'),
      $msg = $hover.siblings('.dupe-hammer-message');

      $hover.hover(
      function() {
      $hover.showInfoMessage('', {
      messageElement: $msg.clone().show(),
      transient: false,
      position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
      dismissable: false,
      relativeToBody: true
      });
      },
      function() {
      StackExchange.helpers.removeMessages();
      }
      );
      });
      });
       Nov 24 '18 at 9:31


      This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.









      marked as duplicate by Neil Lunn mongodb
      Users with the  mongodb badge can single-handedly close mongodb questions as duplicates and reopen them as needed.

      StackExchange.ready(function() {
      if (StackExchange.options.isMobile) return;

      $('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
      var $hover = $(this).addClass('hover-bound'),
      $msg = $hover.siblings('.dupe-hammer-message');

      $hover.hover(
      function() {
      $hover.showInfoMessage('', {
      messageElement: $msg.clone().show(),
      transient: false,
      position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
      dismissable: false,
      relativeToBody: true
      });
      },
      function() {
      StackExchange.helpers.removeMessages();
      }
      );
      });
      });
       Nov 24 '18 at 9:31


      This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


























          1 Answer
          1






          active

          oldest

          votes


















          1














          You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:



          col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })





          share|improve this answer






























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            1














            You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:



            col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })





            share|improve this answer




























              1














              You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:



              col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })





              share|improve this answer


























                1












                1








                1







                You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:



                col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })





                share|improve this answer













                You have to define projection part of .find() method to specify which fields should be returned. You alsow have to explicitly exclude _id, try:



                col.find({}, { "_id": 0, "Name": 1, "Subjects": 1 })






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 21 '18 at 18:28









                micklmickl

                13.6k51536




                13.6k51536

















                    Popular posts from this blog

                    android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

                    Image
                    .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 This is a simple project showing cubes on Unity, exported to android project and imported on Android studio. On maifest file it showed following warning: Expecting <uses-feature android:name="android.software.leanback" android:required="false" /> tag I have no information about it. And also on default emptyview android project does not use/mention this feature. I know it is required by TV's and such but why its not added by default? Why is this? And Should I concern about it? android unity3d
                    Read more

                    SQL update select statement

                    Image
                    0 I'm trying to update an entry in my database (postgresql). I'm having a problem with updating the query: INSERT INTO prices (price, product_id) SELECT product_price, commn_id FROM products_temp as prod WHERE NOT EXISTS (SELECT * FROM prices od WHERE prod.commn_id = od.product_id) OR prod.product_price != ( SELECT price FROM prices as p WHERE p.product_id = prod.commn_id order by p.end desc LIMIT 1 ) Query works fine when i delete: OR prod.product_price != ( SELECT price FROM prices as p WHERE p.product_id = prod.commn_id order by p.end desc LIMIT 1 ) So it seems to me that it's looping through this operation. My question is, how can I fix it? sql postgresql
                    Read more

                    WPF add header to Image with URL pettitions [duplicate]

                    Image
                    up vote 0 down vote favorite This question already has an answer here: Image source URI requiring authorization 3 answers Add header to all* HTTP requests on a machine 1 answer first of all sorry for my english. Recently I added some security in the backend of my project, and now I need to send a validation code(apiKey) inside the headers to retrieve the images. I have a problem with ALL images in my project that I had attached in my UI. For example, before I had: <Image Height="90" Source="{Binding Video.Thumbnail}"/> Now I need to change my code to create a CUSTOM petition add the apiKey in the header:
                    Read more