{"id":2394,"date":"2023-07-22T11:24:01","date_gmt":"2023-07-22T11:24:01","guid":{"rendered":"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/"},"modified":"2023-07-22T11:24:01","modified_gmt":"2023-07-22T11:24:01","slug":"grup-mongodb-berdasarkan-beberapa-bidang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/","title":{"rendered":"Mongodb: cara mengelompokkan berdasarkan beberapa bidang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengelompokkan beberapa bidang dan melakukan agregasi di MongoDB:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.collection.aggregate([\n    { <span style=\"color: #ff0000;\">$group<\/span> : { <span style=\"color: #3366ff;\">_id<\/span> :{field1:\" <span style=\"color: #ff0000;\">$field1<\/span> \", field2:\" <span style=\"color: #ff0000;\">$field2<\/span> \"}, <span style=\"color: #3366ff;\">count<\/span> :{ <span style=\"color: #3366ff;\">$sum<\/span> :1}}}\n])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan sintaksis ini dengan <span style=\"padding: 1px; border: 1px solid black;\">tim<\/span> koleksi dengan 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: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">31<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Mavs<\/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;\">Mavs<\/span> \", position: \" <span style=\"color: #008000;\">Forward<\/span> \", points: <span style=\"color: #ff0000;\">19<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Rockets<\/span> \", position: \" <span style=\"color: #008000;\">Guard<\/span> \", points: <span style=\"color: #ff0000;\">26<\/span> })<\/strong>\n<strong>db.teams.insertOne({team: \" <span style=\"color: #008000;\">Rockets<\/span> \", position: \" <span style=\"color: #008000;\">Forward<\/span> \", points: <span style=\"color: #ff0000;\">33<\/span> })<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: mengelompokkan berdasarkan beberapa bidang dan menggabungkannya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengelompokkan berdasarkan &#8220;tim&#8221; dan &#8220;posisi&#8221; dan menghitung kemunculan setiap pengelompokan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n    { <span style=\"color: #ff0000;\">$group<\/span> : { <span style=\"color: #3366ff;\">_id<\/span> : {team: \" <span style=\"color: #ff0000;\">$team<\/span> \", position: \" <span style=\"color: #ff0000;\">$position<\/span> \"}, <span style=\"color: #3366ff;\">count<\/span> :{ <span style=\"color: #3366ff;\">$sum<\/span> :1}}}\n])<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: { team: ' <span style=\"color: #008000;\">Rockets<\/span> ', position: ' <span style=\"color: #008000;\">Forward<\/span> ' }, count: 1 }\n{ _id: { team: ' <span style=\"color: #008000;\">Mavs<\/span> ', position: ' <span style=\"color: #008000;\">Guard<\/span> ' }, count: 2 }\n{ _id: { team: ' <span style=\"color: #008000;\">Mavs<\/span> ', position: ' <span style=\"color: #008000;\">Forward<\/span> ' }, count: 1 }\n{ _id: { team: ' <span style=\"color: #008000;\">Rockets<\/span> ', position: ' <span style=\"color: #008000;\">Guard<\/span> ' }, count: 1 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami juga dapat melakukan agregasi yang berbeda. Misalnya, kita dapat mengelompokkan berdasarkan \u201ctim\u201d dan posisi\u201d dan mencari jumlah \u201cpoin\u201d dengan mengelompokkan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n    { <span style=\"color: #ff0000;\">$group<\/span> : { <span style=\"color: #3366ff;\">_id<\/span> : {team: \" <span style=\"color: #ff0000;\">$team<\/span> \", position: \" <span style=\"color: #ff0000;\">$position<\/span> \"}, <span style=\"color: #3366ff;\">sumPoints<\/span> <span style=\"color: #000000;\">:{<\/span> <span style=\"color: #3366ff;\"><span style=\"color: #000000;\"><span style=\"color: #3366ff;\">$sum<\/span> : \" <span style=\"color: #ff0000;\">$points<\/span> \"}}}<\/span>\n<span style=\"color: #000000;\">])<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: { team: ' <span style=\"color: #008000;\">Rockets<\/span> ', position: ' <span style=\"color: #008000;\">Forward<\/span> ' }, sumPoints: 33 }\n{ _id: { team: ' <span style=\"color: #008000;\">Mavs<\/span> ', position: ' <span style=\"color: #008000;\">Guard<\/span> ' }, sumPoints: 53 }\n{ _id: { team: ' <span style=\"color: #008000;\">Mavs<\/span> ', position: ' <span style=\"color: #008000;\">Forward<\/span> ' }, sumPoints: 19 }\n{ _id: { team: ' <span style=\"color: #008000;\">Rockets<\/span> ', position: ' <span style=\"color: #008000;\">Guard<\/span> ' }, sumPoints: 26 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah poin yang dicetak oleh pemain &#8216;Rockets&#8217; di posisi &#8216;Forward&#8217; adalah <strong>33<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah poin yang dicetak oleh pemain &#8216;Mavs&#8217; di posisi &#8216;Guard&#8217; adalah <strong>53<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2:<\/strong><\/span> <span style=\"color: #000000;\"><strong>kelompokkan berdasarkan beberapa bidang dan agregat (lalu urutkan)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengelompokkan berdasarkan &#8220;tim&#8221; dan posisi&#8221; dan mencari jumlah &#8220;poin&#8221; dengan mengelompokkannya, lalu mengurutkan hasilnya berdasarkan &#8220;poin&#8221; dalam <strong>urutan menaik<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n    { <span style=\"color: #ff0000;\">$group<\/span> : { <span style=\"color: #3366ff;\">_id<\/span> : {team: \" <span style=\"color: #ff0000;\">$team<\/span> \", position: \" <span style=\"color: #ff0000;\">$position<\/span> \"}, <span style=\"color: #3366ff;\">sumPoints<\/span> :{ <span style=\"color: #3366ff;\">$sum<\/span> : \" <span style=\"color: #ff0000;\">$points<\/span> \"}}},\n    { <span style=\"color: #ff0000;\">$sort<\/span> : { <span style=\"color: #3366ff;\">sumPoints<\/span> :1}}\n])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: { team: ' <span style=\"color: #008000;\">Mavs<\/span> ', position: ' <span style=\"color: #008000;\">Forward<\/span> ' }, sumPoints: 19 }\n{ _id: { team: ' <span style=\"color: #008000;\">Rockets<\/span> ', position: ' <span style=\"color: #008000;\">Guard<\/span> ' }, sumPoints: 26 }\n{ _id: { team: ' <span style=\"color: #008000;\">Rockets<\/span> ', position: ' <span style=\"color: #008000;\">Forward<\/span> ' }, sumPoints: 33 }\n{ _id: { team: ' <span style=\"color: #008000;\">Mavs<\/span> ', position: ' <span style=\"color: #008000;\">Guard<\/span> ' }, sumPoints: 53 }\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan <strong>-1<\/strong> untuk mengurutkan hasil berdasarkan poin dalam <strong>urutan menurun<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n    { <span style=\"color: #ff0000;\">$group<\/span> : { <span style=\"color: #3366ff;\">_id<\/span> : {team: \" <span style=\"color: #ff0000;\">$team<\/span> \", position: \" <span style=\"color: #ff0000;\">$position<\/span> \"}, <span style=\"color: #3366ff;\">sumPoints<\/span> :{ <span style=\"color: #3366ff;\">$sum<\/span> : \" <span style=\"color: #ff0000;\">$points<\/span> \"}}},\n    { <span style=\"color: #ff0000;\">$sort<\/span> : { <span style=\"color: #3366ff;\">sumPoints<\/span> :-1}}\n])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: { team: ' <span style=\"color: #008000;\">Mavs<\/span> ', position: ' <span style=\"color: #008000;\">Guard<\/span> ' }, sumPoints: 53 }\n{ _id: { team: ' <span style=\"color: #008000;\">Rockets<\/span> ', position: ' <span style=\"color: #008000;\">Forward<\/span> ' }, sumPoints: 33 }\n{ _id: { team: ' <span style=\"color: #008000;\">Rockets<\/span> ', position: ' <span style=\"color: #008000;\">Guard<\/span> ' }, sumPoints: 26 }\n{ _id: { team: ' <span style=\"color: #008000;\">Mavs<\/span> ', position: ' <span style=\"color: #008000;\">Forward<\/span> ' }, sumPoints: 19 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk <strong>$group<\/strong> <a href=\"https:\/\/docs.mongodb.com\/manual\/reference\/operator\/aggregation\/group\/\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengelompokkan beberapa bidang dan melakukan agregasi di MongoDB: db.collection.aggregate([ { $group : { _id :{field1:&#8221; $field1 &#8220;, field2:&#8221; $field2 &#8220;}, count :{ $sum :1}}} ]) Contoh berikut memperlihatkan cara menggunakan sintaksis ini dengan tim koleksi dengan dokumen berikut: db.teams.insertOne({team: &#8221; Mavs &#8220;, position: &#8221; Guard &#8220;, points: 31 }) [&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 mengelompokkan berdasarkan beberapa bidang - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan beberapa bidang di MongoDB saat menjalankan kueri, dengan beberapa contoh.\" \/>\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\/grup-mongodb-berdasarkan-beberapa-bidang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MongoDB: Cara mengelompokkan berdasarkan beberapa bidang - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan beberapa bidang di MongoDB saat menjalankan kueri, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T11:24:01+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\/grup-mongodb-berdasarkan-beberapa-bidang\/\",\"url\":\"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/\",\"name\":\"MongoDB: Cara mengelompokkan berdasarkan beberapa bidang - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T11:24:01+00:00\",\"dateModified\":\"2023-07-22T11:24:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan beberapa bidang di MongoDB saat menjalankan kueri, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mongodb: cara mengelompokkan berdasarkan beberapa bidang\"}]},{\"@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 mengelompokkan berdasarkan beberapa bidang - Statorial","description":"Tutorial ini menjelaskan cara mengelompokkan beberapa bidang di MongoDB saat menjalankan kueri, dengan beberapa contoh.","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\/grup-mongodb-berdasarkan-beberapa-bidang\/","og_locale":"id_ID","og_type":"article","og_title":"MongoDB: Cara mengelompokkan berdasarkan beberapa bidang - Statorial","og_description":"Tutorial ini menjelaskan cara mengelompokkan beberapa bidang di MongoDB saat menjalankan kueri, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/","og_site_name":"Statorials","article_published_time":"2023-07-22T11:24:01+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\/grup-mongodb-berdasarkan-beberapa-bidang\/","url":"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/","name":"MongoDB: Cara mengelompokkan berdasarkan beberapa bidang - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T11:24:01+00:00","dateModified":"2023-07-22T11:24:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan beberapa bidang di MongoDB saat menjalankan kueri, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grup-mongodb-berdasarkan-beberapa-bidang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Mongodb: cara mengelompokkan berdasarkan beberapa bidang"}]},{"@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\/2394"}],"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=2394"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2394\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}