Query a document and its nested array









up vote
1
down vote

favorite
2












Using MongoDB and Groovy language



Having documents in a collection like the following




id: 1,
name: John,
kids: [

name: Helen,
age: 13
,

name: George,
age: 8
]



How i can make a query like



db.collection.find(name: John AND kids name: Helen)









share|improve this question



























    up vote
    1
    down vote

    favorite
    2












    Using MongoDB and Groovy language



    Having documents in a collection like the following




    id: 1,
    name: John,
    kids: [

    name: Helen,
    age: 13
    ,

    name: George,
    age: 8
    ]



    How i can make a query like



    db.collection.find(name: John AND kids name: Helen)









    share|improve this question

























      up vote
      1
      down vote

      favorite
      2









      up vote
      1
      down vote

      favorite
      2






      2





      Using MongoDB and Groovy language



      Having documents in a collection like the following




      id: 1,
      name: John,
      kids: [

      name: Helen,
      age: 13
      ,

      name: George,
      age: 8
      ]



      How i can make a query like



      db.collection.find(name: John AND kids name: Helen)









      share|improve this question















      Using MongoDB and Groovy language



      Having documents in a collection like the following




      id: 1,
      name: John,
      kids: [

      name: Helen,
      age: 13
      ,

      name: George,
      age: 8
      ]



      How i can make a query like



      db.collection.find(name: John AND kids name: Helen)






      mongodb groovy






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 9 at 13:33

























      asked Nov 9 at 12:18









      George Vardikos

      1,229417




      1,229417






















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          You can do something like this:



          mongoCommand



          db.collectionName.find(
          $and: [
          "name" : "John",
          "kids.name": "Helen"
          ]
          )


          groovy



          db.collection.find(new BasicDBObject(['name' : "John", 'kids.name' :"Helen"])).toArray().each 
          println it



          if you have any question feel fre to ask






          share|improve this answer






















          • This is not Groovy language, the question is about groovy language
            – George Vardikos
            Nov 9 at 13:36







          • 1




            sorry: please check updated answer)
            – andranikasl
            Nov 9 at 14:10










          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%2f53225590%2fquery-a-document-and-its-nested-array%23new-answer', 'question_page');

          );

          Post as a guest






























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          up vote
          0
          down vote













          You can do something like this:



          mongoCommand



          db.collectionName.find(
          $and: [
          "name" : "John",
          "kids.name": "Helen"
          ]
          )


          groovy



          db.collection.find(new BasicDBObject(['name' : "John", 'kids.name' :"Helen"])).toArray().each 
          println it



          if you have any question feel fre to ask






          share|improve this answer






















          • This is not Groovy language, the question is about groovy language
            – George Vardikos
            Nov 9 at 13:36







          • 1




            sorry: please check updated answer)
            – andranikasl
            Nov 9 at 14:10














          up vote
          0
          down vote













          You can do something like this:



          mongoCommand



          db.collectionName.find(
          $and: [
          "name" : "John",
          "kids.name": "Helen"
          ]
          )


          groovy



          db.collection.find(new BasicDBObject(['name' : "John", 'kids.name' :"Helen"])).toArray().each 
          println it



          if you have any question feel fre to ask






          share|improve this answer






















          • This is not Groovy language, the question is about groovy language
            – George Vardikos
            Nov 9 at 13:36







          • 1




            sorry: please check updated answer)
            – andranikasl
            Nov 9 at 14:10












          up vote
          0
          down vote










          up vote
          0
          down vote









          You can do something like this:



          mongoCommand



          db.collectionName.find(
          $and: [
          "name" : "John",
          "kids.name": "Helen"
          ]
          )


          groovy



          db.collection.find(new BasicDBObject(['name' : "John", 'kids.name' :"Helen"])).toArray().each 
          println it



          if you have any question feel fre to ask






          share|improve this answer














          You can do something like this:



          mongoCommand



          db.collectionName.find(
          $and: [
          "name" : "John",
          "kids.name": "Helen"
          ]
          )


          groovy



          db.collection.find(new BasicDBObject(['name' : "John", 'kids.name' :"Helen"])).toArray().each 
          println it



          if you have any question feel fre to ask







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 9 at 14:11

























          answered Nov 9 at 13:29









          andranikasl

          2644




          2644











          • This is not Groovy language, the question is about groovy language
            – George Vardikos
            Nov 9 at 13:36







          • 1




            sorry: please check updated answer)
            – andranikasl
            Nov 9 at 14:10
















          • This is not Groovy language, the question is about groovy language
            – George Vardikos
            Nov 9 at 13:36







          • 1




            sorry: please check updated answer)
            – andranikasl
            Nov 9 at 14:10















          This is not Groovy language, the question is about groovy language
          – George Vardikos
          Nov 9 at 13:36





          This is not Groovy language, the question is about groovy language
          – George Vardikos
          Nov 9 at 13:36





          1




          1




          sorry: please check updated answer)
          – andranikasl
          Nov 9 at 14:10




          sorry: please check updated answer)
          – andranikasl
          Nov 9 at 14:10

















           

          draft saved


          draft discarded















































           


          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53225590%2fquery-a-document-and-its-nested-array%23new-answer', 'question_page');

          );

          Post as a guest














































































          Popular posts from this blog

          Use pre created SQLite database for Android project in kotlin

          Darth Vader #20

          Ondo