How do I list all documents in a collection but show a single property?









up vote
0
down vote

favorite












How do I list all documents in a collection but show a single property through a console window?



//Trying to just show name property
db.mycollection.find(name);









share|improve this question

























    up vote
    0
    down vote

    favorite












    How do I list all documents in a collection but show a single property through a console window?



    //Trying to just show name property
    db.mycollection.find(name);









    share|improve this question























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      How do I list all documents in a collection but show a single property through a console window?



      //Trying to just show name property
      db.mycollection.find(name);









      share|improve this question













      How do I list all documents in a collection but show a single property through a console window?



      //Trying to just show name property
      db.mycollection.find(name);






      mongodb






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 9 at 20:30









      Rod

      5,5551775135




      5,5551775135






















          3 Answers
          3






          active

          oldest

          votes

















          up vote
          1
          down vote



          accepted










          The find mongo command accepts 2 parameters:



          db.collection.find(query, projection)


          query (Optional):




          Specifies selection filter using query operators. To return all
          documents in a collection, omit this parameter or pass an empty
          document ().




          projection (Optional):




          Specifies the fields to return in the documents that match the query
          filter. To return all fields in the matching documents, omit this
          parameter. For details, see Projection.




          In your scenario you have to use the projection parameter to specify which fields to be returned as so:



          db.mycollection.find(, _id: 0, name: 1);


          Since you do not care about providing criteria you can just leave that as empty object.



          The _id: 0, name: 1 means that you do not want the default _id field included in the results and only care/want the name field.






          share|improve this answer


















          • 2




            "jinx" 8 second difference when I answered but you gave extra insight
            – Rod
            Nov 9 at 21:18

















          up vote
          3
          down vote













          You can set your showing propertys this way:



          db.mycollection.find(name:name, _id:0, name:1);


          It will only show the name and hide the _id






          share|improve this answer



























            up vote
            0
            down vote













            db.mycollection.find(, _id:0, name: 1)






            share|improve this answer




















              Your Answer






              StackExchange.ifUsing("editor", function ()
              StackExchange.using("externalEditor", function ()
              StackExchange.using("snippets", function ()
              StackExchange.snippets.init();
              );
              );
              , "code-snippets");

              StackExchange.ready(function()
              var channelOptions =
              tags: "".split(" "),
              id: "1"
              ;
              initTagRenderer("".split(" "), "".split(" "), channelOptions);

              StackExchange.using("externalEditor", function()
              // Have to fire editor after snippets, if snippets enabled
              if (StackExchange.settings.snippets.snippetsEnabled)
              StackExchange.using("snippets", function()
              createEditor();
              );

              else
              createEditor();

              );

              function createEditor()
              StackExchange.prepareEditor(
              heartbeatType: 'answer',
              convertImagesToLinks: true,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: 10,
              bindNavPrevention: true,
              postfix: "",
              imageUploader:
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              ,
              onDemand: true,
              discardSelector: ".discard-answer"
              ,immediatelyShowMarkdownHelp:true
              );



              );













               

              draft saved


              draft discarded


















              StackExchange.ready(
              function ()
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53232869%2fhow-do-i-list-all-documents-in-a-collection-but-show-a-single-property%23new-answer', 'question_page');

              );

              Post as a guest















              Required, but never shown

























              3 Answers
              3






              active

              oldest

              votes








              3 Answers
              3






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes








              up vote
              1
              down vote



              accepted










              The find mongo command accepts 2 parameters:



              db.collection.find(query, projection)


              query (Optional):




              Specifies selection filter using query operators. To return all
              documents in a collection, omit this parameter or pass an empty
              document ().




              projection (Optional):




              Specifies the fields to return in the documents that match the query
              filter. To return all fields in the matching documents, omit this
              parameter. For details, see Projection.




              In your scenario you have to use the projection parameter to specify which fields to be returned as so:



              db.mycollection.find(, _id: 0, name: 1);


              Since you do not care about providing criteria you can just leave that as empty object.



              The _id: 0, name: 1 means that you do not want the default _id field included in the results and only care/want the name field.






              share|improve this answer


















              • 2




                "jinx" 8 second difference when I answered but you gave extra insight
                – Rod
                Nov 9 at 21:18














              up vote
              1
              down vote



              accepted










              The find mongo command accepts 2 parameters:



              db.collection.find(query, projection)


              query (Optional):




              Specifies selection filter using query operators. To return all
              documents in a collection, omit this parameter or pass an empty
              document ().




              projection (Optional):




              Specifies the fields to return in the documents that match the query
              filter. To return all fields in the matching documents, omit this
              parameter. For details, see Projection.




              In your scenario you have to use the projection parameter to specify which fields to be returned as so:



              db.mycollection.find(, _id: 0, name: 1);


              Since you do not care about providing criteria you can just leave that as empty object.



              The _id: 0, name: 1 means that you do not want the default _id field included in the results and only care/want the name field.






              share|improve this answer


















              • 2




                "jinx" 8 second difference when I answered but you gave extra insight
                – Rod
                Nov 9 at 21:18












              up vote
              1
              down vote



              accepted







              up vote
              1
              down vote



              accepted






              The find mongo command accepts 2 parameters:



              db.collection.find(query, projection)


              query (Optional):




              Specifies selection filter using query operators. To return all
              documents in a collection, omit this parameter or pass an empty
              document ().




              projection (Optional):




              Specifies the fields to return in the documents that match the query
              filter. To return all fields in the matching documents, omit this
              parameter. For details, see Projection.




              In your scenario you have to use the projection parameter to specify which fields to be returned as so:



              db.mycollection.find(, _id: 0, name: 1);


              Since you do not care about providing criteria you can just leave that as empty object.



              The _id: 0, name: 1 means that you do not want the default _id field included in the results and only care/want the name field.






              share|improve this answer














              The find mongo command accepts 2 parameters:



              db.collection.find(query, projection)


              query (Optional):




              Specifies selection filter using query operators. To return all
              documents in a collection, omit this parameter or pass an empty
              document ().




              projection (Optional):




              Specifies the fields to return in the documents that match the query
              filter. To return all fields in the matching documents, omit this
              parameter. For details, see Projection.




              In your scenario you have to use the projection parameter to specify which fields to be returned as so:



              db.mycollection.find(, _id: 0, name: 1);


              Since you do not care about providing criteria you can just leave that as empty object.



              The _id: 0, name: 1 means that you do not want the default _id field included in the results and only care/want the name field.







              share|improve this answer














              share|improve this answer



              share|improve this answer








              edited Nov 9 at 21:20

























              answered Nov 9 at 21:16









              Akrion

              7,10111222




              7,10111222







              • 2




                "jinx" 8 second difference when I answered but you gave extra insight
                – Rod
                Nov 9 at 21:18












              • 2




                "jinx" 8 second difference when I answered but you gave extra insight
                – Rod
                Nov 9 at 21:18







              2




              2




              "jinx" 8 second difference when I answered but you gave extra insight
              – Rod
              Nov 9 at 21:18




              "jinx" 8 second difference when I answered but you gave extra insight
              – Rod
              Nov 9 at 21:18












              up vote
              3
              down vote













              You can set your showing propertys this way:



              db.mycollection.find(name:name, _id:0, name:1);


              It will only show the name and hide the _id






              share|improve this answer
























                up vote
                3
                down vote













                You can set your showing propertys this way:



                db.mycollection.find(name:name, _id:0, name:1);


                It will only show the name and hide the _id






                share|improve this answer






















                  up vote
                  3
                  down vote










                  up vote
                  3
                  down vote









                  You can set your showing propertys this way:



                  db.mycollection.find(name:name, _id:0, name:1);


                  It will only show the name and hide the _id






                  share|improve this answer












                  You can set your showing propertys this way:



                  db.mycollection.find(name:name, _id:0, name:1);


                  It will only show the name and hide the _id







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 9 at 20:32









                  KeeyPee

                  734




                  734




















                      up vote
                      0
                      down vote













                      db.mycollection.find(, _id:0, name: 1)






                      share|improve this answer
























                        up vote
                        0
                        down vote













                        db.mycollection.find(, _id:0, name: 1)






                        share|improve this answer






















                          up vote
                          0
                          down vote










                          up vote
                          0
                          down vote









                          db.mycollection.find(, _id:0, name: 1)






                          share|improve this answer












                          db.mycollection.find(, _id:0, name: 1)







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered Nov 9 at 21:16









                          Rod

                          5,5551775135




                          5,5551775135



























                               

                              draft saved


                              draft discarded















































                               


                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function ()
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53232869%2fhow-do-i-list-all-documents-in-a-collection-but-show-a-single-property%23new-answer', 'question_page');

                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              Use pre created SQLite database for Android project in kotlin

                              Darth Vader #20

                              Ondo