{"id":2417,"date":"2023-07-22T09:05:39","date_gmt":"2023-07-22T09:05:39","guid":{"rendered":"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/"},"modified":"2023-07-22T09:05:39","modified_gmt":"2023-07-22T09:05:39","slug":"mongodb-bukan-nol","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/","title":{"rendered":"Mongodb: bagaimana cara menanyakan &quot;bukan nol&quot;? di wilayah tertentu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menemukan semua dokumen yang bidang tertentunya bukan nol di MongoDB:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.collection.find({\" <span style=\"color: #ff0000;\">field_name<\/span> \":{ <span style=\"color: #ff0000;\">$ne<\/span> : <span style=\"color: #3366ff;\">null<\/span> }}) \n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Kueri untuk \u201cbukan nol\u201d di bidang tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Anggaplah kita memiliki <span style=\"padding: 1px; border: 1px solid black;\">tim<\/span> pengumpulan dengan dokumen-dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Mavs<\/span> \", position: <span style=\"color: #3366ff;\">null<\/span> , points: <span style=\"color: #ff0000;\">31<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Spurs<\/span> \", position: \" <span style=\"color: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">22<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Rockets<\/span> \", position: <span style=\"color: #3366ff;\">null<\/span> , points: <span style=\"color: #ff0000;\">19<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Warriors<\/span> \", position: \" <span style=\"color: #008000;\">Forward<\/span> \", points: <span style=\"color: #ff0000;\">26<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Cavs<\/span> \", position: \" <span style=\"color: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">33<\/span> })<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menemukan semua dokumen yang kolom \u201cposisinya\u201d bukan nol:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.find({\" <span style=\"color: #ff0000;\">position<\/span> \":{ <span style=\"color: #ff0000;\">$ne<\/span> : <span style=\"color: #3366ff;\">null<\/span> }})\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri ini mengembalikan dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ObjectId(\"618bf18f35d8a762d3c28717\"),\n  team: 'Spurs',\n  position: 'Guard',\n  points: 22 }\n\n{ _id: ObjectId(\"618bf18f35d8a762d3c28719\"),\n  team: 'Warriors',\n  position: 'Forward',\n  points: 26 }\n\n{ _id: ObjectId(\"618bf18f35d8a762d3c2871a\"),\n  team: 'Cavs',\n  position: 'Guard',\n  points: 33 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa satu-satunya dokumen yang dikembalikan adalah dokumen yang bidang &#8220;posisinya&#8221; bukan nol.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Kueri untuk \u201cnot null\u201d (jika semua dokumen tidak berisi kolom tersebut)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Anggaplah kita memiliki <span style=\"padding: 1px; border: 1px solid black;\">tim<\/span> pengumpulan dengan dokumen-dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Mavs<\/span> \", position: <span style=\"color: #3366ff;\">null<\/span> , points: <span style=\"color: #ff0000;\">31<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Spurs<\/span> \", points: <span style=\"color: #ff0000;\">22<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Rockets<\/span> \", position: <span style=\"color: #3366ff;\">null<\/span> , points: <span style=\"color: #ff0000;\">19<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Warriors<\/span> \", position: \" <span style=\"color: #008000;\">Forward<\/span> \", points: <span style=\"color: #ff0000;\">26<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Cavs<\/span> \", position: \" <span style=\"color: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">33<\/span> })<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dokumen kedua dalam koleksi bahkan tidak memiliki kolom &#8220;posisi&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menemukan semua dokumen yang kolom \u201cposisinya\u201d bukan nol:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.find({\" <span style=\"color: #ff0000;\">position<\/span> \":{ <span style=\"color: #ff0000;\">$ne<\/span> : <span style=\"color: #3366ff;\">null<\/span> }})\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri ini mengembalikan dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ObjectId(\"618bf18f35d8a762d3c28719\"),\n  team: 'Warriors',\n  position: 'Forward',\n  points: 26 }\n\n{ _id: ObjectId(\"618bf18f35d8a762d3c2871a\"),\n  team: 'Cavs',\n  position: 'Guard',\n  points: 33 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Karena dokumen kedua bahkan tidak memiliki bidang &#8220;posisi&#8221;, maka dokumen tersebut tidak dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa dua dokumen lainnya yang memiliki nilai <strong>null<\/strong> di bidang &#8220;posisi&#8221; juga tidak dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ringkasan<\/strong> : Dengan menggunakan sintaks <strong>$ne:null<\/strong> , kami hanya mengembalikan dokumen yang kolomnya ada <em>dan<\/em> bukan null.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di MongoDB:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kueri-mirip-dengan-mongodb\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara melakukan kueri dengan ekspresi reguler \u201cSuka\u201d.<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mongodb-berisi\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara memeriksa apakah bidang berisi string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mongodb-menambahkan-bidang\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara menambahkan bidang baru ke koleksi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bidang-hapus-mongodb\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara menghapus bidang dari setiap dokumen<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menemukan semua dokumen yang bidang tertentunya bukan nol di MongoDB: db.collection.find({&#8221; field_name &#8220;:{ $ne : null }}) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh 1: Kueri untuk \u201cbukan nol\u201d di bidang tertentu Anggaplah kita memiliki tim pengumpulan dengan dokumen-dokumen berikut: db.teams.insertOne({team: &#8221; Mavs &#8220;, position: null [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MongoDB: Cara mencari &quot;bukan nol&quot; di bidang tertentu - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menanyakan dokumen di MongoDB yang &quot;non-null&quot; di bidang tertentu.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MongoDB: Cara mencari &quot;bukan nol&quot; di bidang tertentu - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menanyakan dokumen di MongoDB yang &quot;non-null&quot; di bidang tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T09:05:39+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/\",\"url\":\"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/\",\"name\":\"MongoDB: Cara mencari &quot;bukan nol&quot; di bidang tertentu - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T09:05:39+00:00\",\"dateModified\":\"2023-07-22T09:05:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menanyakan dokumen di MongoDB yang &quot;non-null&quot; di bidang tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mongodb: bagaimana cara menanyakan &quot;bukan nol&quot;? di wilayah tertentu\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MongoDB: Cara mencari &quot;bukan nol&quot; di bidang tertentu - Statologi","description":"Tutorial ini menjelaskan cara menanyakan dokumen di MongoDB yang &quot;non-null&quot; di bidang tertentu.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/","og_locale":"id_ID","og_type":"article","og_title":"MongoDB: Cara mencari &quot;bukan nol&quot; di bidang tertentu - Statologi","og_description":"Tutorial ini menjelaskan cara menanyakan dokumen di MongoDB yang &quot;non-null&quot; di bidang tertentu.","og_url":"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/","og_site_name":"Statorials","article_published_time":"2023-07-22T09:05:39+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/","url":"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/","name":"MongoDB: Cara mencari &quot;bukan nol&quot; di bidang tertentu - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T09:05:39+00:00","dateModified":"2023-07-22T09:05:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menanyakan dokumen di MongoDB yang &quot;non-null&quot; di bidang tertentu.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/mongodb-bukan-nol\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/mongodb-bukan-nol\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Mongodb: bagaimana cara menanyakan &quot;bukan nol&quot;? di wilayah tertentu"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2417"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2417"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2417\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}