{"id":2757,"date":"2023-07-20T20:34:55","date_gmt":"2023-07-20T20:34:55","guid":{"rendered":"https:\/\/statorials.org\/id\/panjang-string-mongodb\/"},"modified":"2023-07-20T20:34:55","modified_gmt":"2023-07-20T20:34:55","slug":"panjang-string-mongodb","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panjang-string-mongodb\/","title":{"rendered":"Mongodb: cara mencari panjang string"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk menemukan panjang string di MongoDB dan menggunakan panjang string tersebut dalam kueri:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Temukan panjang rantai<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.myCollection.aggregate([\n  { <span style=\"color: #3366ff;\">$project<\/span> : {\n        \"name\": 1,\n        \"length\": { <span style=\"color: #3366ff;\">$strLenCP<\/span> : \" <span style=\"color: #ff0000;\">$name<\/span> \" }\n  }}\n])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Temukan dokumen yang stringnya lebih besar dari panjang tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.myCollection.find({ \n    \"name\": { <span style=\"color: #3366ff;\">$exists<\/span> : true },\n    <span style=\"color: #3366ff;\">$expr<\/span> : { <span style=\"color: #3366ff;\">$gt<\/span> : [ { <span style=\"color: #3366ff;\">$strLenCP<\/span> : \" <span style=\"color: #ff0000;\">$name<\/span> \" }, <span style=\"color: #008000;\">14<\/span> ] } \n})\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dengan<\/span> <span style=\"padding: 1px; border: 1px solid black;\">tim<\/span> pengumpulan <span style=\"color: #000000;\">dengan dokumen berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.insertOne({name: \" <span style=\"color: #008000;\">Dallas Mavs<\/span> \", points: 31})\ndb.teams.insertOne({name: \" <span style=\"color: #008000;\">San Antonio Spurs<\/span> \", points: 22})\ndb.teams.insertOne({name: \" <span style=\"color: #008000;\">Houston Rockets<\/span> \", points: 19})\ndb.teams.insertOne({name: \" <span style=\"color: #008000;\">Boston Celtics<\/span> \", points: 26})\ndb.teams.insertOne({name: \" <span style=\"color: #008000;\">Cleveland Cavs<\/span> \", points: 33})<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Mencari Panjang Tali<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk menghitung panjang string di kolom &#8220;nama&#8221; setiap dokumen:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.aggregate([\n  { <span style=\"color: #3366ff;\">$project<\/span> : {\n        \"name\": 1,\n        \"length\": { <span style=\"color: #3366ff;\">$strLenCP<\/span> : \" <span style=\"color: #ff0000;\">$name<\/span> \" }\n  }}\n])<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kode ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ObjectId(\"62014eff4cb04b772fd7a93d\"),\n  name: 'Dallas Mavs',\n  length: 11 }\n{ _id: ObjectId(\"62014eff4cb04b772fd7a93e\"),\n  name: 'San Antonio Spurs',\n  length: 17 }\n{ _id: ObjectId(\"62014eff4cb04b772fd7a93f\"),\n  name: 'Houston Rockets',\n  length: 15 }\n{ _id: ObjectId(\"62014eff4cb04b772fd7a940\"),\n  name: 'Boston Celtics',\n  length: 14 }\n{ _id: ObjectId(\"62014eff4cb04b772fd7a941\"),\n  name: 'Cleveland Cavs',\n  length: 14 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Nilai panjang menampilkan panjang string di kolom &#8220;nama&#8221;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Panjang rantai &#8220;Dallas Mavs&#8221; adalah <strong>11<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Panjang rantai &#8216;San Antonio Spurs&#8217; adalah <strong>17<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa panjangnya juga menghitung ruang kosong.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Temukan dokumen yang stringnya lebih besar dari panjang tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengembalikan hanya dokumen yang stringnya di kolom &#8220;nama&#8221; lebih besar dari <strong>14<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>db.teams.find({ \n    \"name\": { <span style=\"color: #3366ff;\">$exists<\/span> : true },\n    <span style=\"color: #3366ff;\">$expr<\/span> : { <span style=\"color: #3366ff;\">$gt<\/span> : [ { <span style=\"color: #3366ff;\">$strLenCP<\/span> : \" <span style=\"color: #ff0000;\">$name<\/span> \" }, <span style=\"color: #008000;\">14<\/span> ] } \n})<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri ini mengembalikan hasil berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{ _id: ObjectId(\"62014eff4cb04b772fd7a93e\"),\n  name: 'San Antonio Spurs',\n  points: 22 }\n{ _id: ObjectId(\"62014eff4cb04b772fd7a93f\"),\n  name: 'Houston Rockets',\n  points: 19 }<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa hanya dua tim yang dikembalikan adalah tim yang kolom &#8220;nama&#8221;-nya lebih besar dari <strong>14<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi <strong>$strLenCP<\/strong> <a href=\"https:\/\/docs.mongodb.com\/manual\/reference\/operator\/aggregation\/strLenCP\/\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/string-terpisah-mongodb\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara membagi string menjadi array substring<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/string-rangkaian-mongodb\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara menggabungkan string dari dua bidang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/string-pengganti-mongodb\/\" target=\"_blank\" rel=\"noopener\">MongoDB: Cara mengganti string di<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk menemukan panjang string di MongoDB dan menggunakan panjang string tersebut dalam kueri: Metode 1: Temukan panjang rantai db.myCollection.aggregate([ { $project : { &#8220;name&#8221;: 1, &#8220;length&#8221;: { $strLenCP : &#8221; $name &#8221; } }} ]) Metode 2: Temukan dokumen yang stringnya lebih besar dari panjang tertentu db.myCollection.find({ &#8220;name&#8221;: { $exists [&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 panjang string - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan panjang string di MongoDB dan menggunakan panjang string tersebut dalam kueri.\" \/>\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\/panjang-string-mongodb\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MongoDB: Cara mencari panjang string - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan panjang string di MongoDB dan menggunakan panjang string tersebut dalam kueri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panjang-string-mongodb\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T20:34:55+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\/panjang-string-mongodb\/\",\"url\":\"https:\/\/statorials.org\/id\/panjang-string-mongodb\/\",\"name\":\"MongoDB: Cara mencari panjang string - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T20:34:55+00:00\",\"dateModified\":\"2023-07-20T20:34:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan panjang string di MongoDB dan menggunakan panjang string tersebut dalam kueri.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panjang-string-mongodb\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panjang-string-mongodb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panjang-string-mongodb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mongodb: cara mencari panjang string\"}]},{\"@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 panjang string - Statologi","description":"Tutorial ini menjelaskan cara menemukan panjang string di MongoDB dan menggunakan panjang string tersebut dalam kueri.","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\/panjang-string-mongodb\/","og_locale":"id_ID","og_type":"article","og_title":"MongoDB: Cara mencari panjang string - Statologi","og_description":"Tutorial ini menjelaskan cara menemukan panjang string di MongoDB dan menggunakan panjang string tersebut dalam kueri.","og_url":"https:\/\/statorials.org\/id\/panjang-string-mongodb\/","og_site_name":"Statorials","article_published_time":"2023-07-20T20:34:55+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\/panjang-string-mongodb\/","url":"https:\/\/statorials.org\/id\/panjang-string-mongodb\/","name":"MongoDB: Cara mencari panjang string - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T20:34:55+00:00","dateModified":"2023-07-20T20:34:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan panjang string di MongoDB dan menggunakan panjang string tersebut dalam kueri.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panjang-string-mongodb\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panjang-string-mongodb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panjang-string-mongodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Mongodb: cara mencari panjang string"}]},{"@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\/2757"}],"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=2757"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2757\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}