आप इसके लिए $ जहाँ ऑपरेटर का उपयोग कर सकते हैं। आइए पहले दस्तावेजों के साथ एक संग्रह बनाएं -
>db.searchDocumentArrayIntegerDemo.insertOne({"StudentFirstName":"John",,"StudentScores":[45,78,89,90]});{ "acknowledge" :true, "insertId" :ObjectId("5cd2a219345990cee87fd88c ")}>db.searchDocumentArrayIntegerDemo.insertOne({"StudentFirstName":"Larry",,"StudentScores":[45,43,34,33]});{ "स्वीकृत" :सच, "insertId" :ObjectId("5cd2a22a345990cee87fd88d ")}>db.searchDocumentArrayIntegerDemo.insertOne({"StudentFirstName":"Chris",,"StudentScores":[]});{ "स्वीकृत" :सच, "insertId" :ObjectId("5cd2a23c345990cee87fd88e")}>db.searchDocumentArrayIntegerDemo .insertOne({"StudentFirstName":"David",,"StudentScores":[99]});{ "acknowledge" :true, "insertId" :ObjectId("5cd2a24d345990cee87fd88f")}
खोज () विधि की मदद से संग्रह से सभी दस्तावेजों को प्रदर्शित करने के लिए क्वेरी निम्नलिखित है -
> db.searchDocumentArrayIntegerDemo.find().pretty();
यह निम्नलिखित आउटपुट देगा -
{ "_id" :ObjectId("5cd2a219345990cee87fd88c"), "StudentFirstName" :"John", "StudentScores" :[45, 78, 89, 90 ]}{ "_id" :ObjectId("5cd2a22a345990cee"), "fd88d") स्टूडेंटफर्स्टनाम" :"लैरी", "स्टूडेंटस्कोर" :[ 45, 43, 34, 33 ]}{ "_id" :ObjectId("5cd2a23c345990cee87fd88e"), "StudentFirstName" :"Chris", "StudentScores" :[ ]}{ " _id" :ObjectId("5cd2a24d345990cee87fd88f"), "StudentFirstName" :"David", "StudentScores" :[ 99 ]}
केस 1 - क्वेरी जब सरणी में कम से कम एक मान हो -
> db.searchDocumentArrayIntegerDemo.find({ $where:"this.StudentScores.length>=1"});
यह निम्नलिखित आउटपुट देगा -
{ "_id" :ObjectId("5cd2a219345990cee87fd88c"), "StudentFirstName" :"John", "StudentScores" :[45, 78, 89, 90 ] }{ "_id" :ObjectId("5cd2a22a345990cee87fd88d"), "fd88d") स्टूडेंटफर्स्टनाम":"लैरी", "स्टूडेंटस्कोर":[45, 43, 34, 33] }{ "_id" :ObjectId("5cd2a24d345990cee87fd88f"), "StudentFirstName" :"David", "StudentScores" :[ 99 ] }पूर्व>केस 2 − क्वेरी जब सरणी में सभी दस्तावेज़ों में एक समान मान हो -
> db.searchDocumentArrayIntegerDemo.find({StudentScores:45}, {StudentScores:1});यह निम्नलिखित आउटपुट देगा -
{ "_id" :ObjectId("5cd2a219345990cee87fd88c"), "StudentScores" :[45, 78, 89, 90 ] }{ "_id" :ObjectId("5cd2a22a345990cee87fd88d"), "StudentScores", "StudentScores" 34, 33 ] }