{"id":270,"date":"2021-02-22T16:13:38","date_gmt":"2021-02-22T09:13:38","guid":{"rendered":"https:\/\/blog.dani.work\/?p=270"},"modified":"2021-08-27T03:11:12","modified_gmt":"2021-08-26T20:11:12","slug":"menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql","status":"publish","type":"post","link":"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/","title":{"rendered":"Menampilkan semua child dengan postgresql"},"content":{"rendered":"\n<p>Kebutuhan &#8220;<em>recursion<\/em>&#8221; pada query terbilang jarang di temukan di proyek &#8211; proyek sederhana, biasanya ini di butuhkan pada saat kita membangun aplikasi yang isinya memiliki beberapa tingkatan element.<\/p>\n\n\n\n<p>Contohnya seperti user multilevel marketing, untuk dapat menemukan semua downline seorang user sampai keakar nya perlu &#8220;<em>recursion<\/em>&#8220;.<\/p>\n\n\n\n<p>Contohlainnya Aplikasi untuk multi company, yang didalam nya terdapat unitbisnis yang cukup banyak sehingga struktur nya memiliki banyak tingkatan.<\/p>\n\n\n\n<p>Berikut ini solusi untuk menampilkan semua data <em>child&nbsp;<\/em>dari table yang sama dengan berdasarkan <em>parent_id :<\/em><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">WITH RECURSIVE childs AS (\n    SELECT t1.id,\n        t1.parent_id,\n        t1.name\n    FROM product_categories t1\n    WHERE t1.id = 12\n    UNION ALL\n    SELECT t2.id,\n        t2.parent_id,\n        t2.name\n    FROM product_categories t2\n        INNER JOIN childs ON childs.id = t2.parent_id\n)\nSELECT id,\n    parent_id,\n    name\nFROM childs;<\/code><\/pre>\n\n\n\n<p><span style=\"color: #ff0000;\">t1.id = 12 ,<\/span> merupakan id parent yang mau di tampilkan child nya.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kebutuhan &#8220;recursion&#8221; pada query terbilang jarang di temukan di proyek &#8211; proyek sederhana, biasanya ini di butuhkan pada saat kita membangun aplikasi yang isinya memiliki beberapa tingkatan element. Contohnya seperti user multilevel marketing, untuk dapat menemukan semua downline seorang user sampai keakar nya perlu &#8220;recursion&#8220;. Contohlainnya Aplikasi untuk multi company, yang didalam nya terdapat unitbisnis [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[26],"tags":[],"class_list":["post-270","post","type-post","status-publish","format-standard","hentry","category-database-sql"],"blocksy_meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Menampilkan semua child dengan postgresql<\/title>\n<meta name=\"description\" content=\"Menampilkan semua child berdasarkan parent_id di portgresql (teknik recursion)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Menampilkan semua child dengan postgresql\" \/>\n<meta property=\"og:description\" content=\"Menampilkan semua child berdasarkan parent_id di portgresql (teknik recursion)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Inside of Code\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-22T09:13:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-26T20:11:12+00:00\" \/>\n<meta name=\"author\" content=\"Dani\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dani\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/\"},\"author\":{\"name\":\"Dani\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/1c6cafc6659067aa7ac1fd1a5ced218d\"},\"headline\":\"Menampilkan semua child dengan postgresql\",\"datePublished\":\"2021-02-22T09:13:38+00:00\",\"dateModified\":\"2021-08-26T20:11:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/\"},\"wordCount\":97,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/#organization\"},\"articleSection\":[\"Database (SQL)\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/\",\"url\":\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/\",\"name\":\"Menampilkan semua child dengan postgresql\",\"isPartOf\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/#website\"},\"datePublished\":\"2021-02-22T09:13:38+00:00\",\"dateModified\":\"2021-08-26T20:11:12+00:00\",\"description\":\"Menampilkan semua child berdasarkan parent_id di portgresql (teknik recursion)\",\"breadcrumb\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/insideofcode.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Menampilkan semua child dengan postgresql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#website\",\"url\":\"https:\/\/insideofcode.com\/blog\/\",\"name\":\"Inside of Code\",\"description\":\"A software engineer who wants to share what he has learned, and document his journey.\",\"publisher\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/insideofcode.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#organization\",\"name\":\"Inside of Code\",\"url\":\"https:\/\/insideofcode.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/10\/logo-ioc.png\",\"contentUrl\":\"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/10\/logo-ioc.png\",\"width\":324,\"height\":324,\"caption\":\"Inside of Code\"},\"image\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/1c6cafc6659067aa7ac1fd1a5ced218d\",\"name\":\"Dani\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4b1e4251720747aef0418e09fe0f6e7786ff89358b57f76822f1c52c286552b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4b1e4251720747aef0418e09fe0f6e7786ff89358b57f76822f1c52c286552b?s=96&d=mm&r=g\",\"caption\":\"Dani\"},\"sameAs\":[\"https:\/\/insideofcode.com\/blog\"],\"url\":\"https:\/\/insideofcode.com\/blog\/author\/daniwork\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Menampilkan semua child dengan postgresql","description":"Menampilkan semua child berdasarkan parent_id di portgresql (teknik recursion)","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:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"Menampilkan semua child dengan postgresql","og_description":"Menampilkan semua child berdasarkan parent_id di portgresql (teknik recursion)","og_url":"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/","og_site_name":"Inside of Code","article_published_time":"2021-02-22T09:13:38+00:00","article_modified_time":"2021-08-26T20:11:12+00:00","author":"Dani","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dani","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/#article","isPartOf":{"@id":"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/"},"author":{"name":"Dani","@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/1c6cafc6659067aa7ac1fd1a5ced218d"},"headline":"Menampilkan semua child dengan postgresql","datePublished":"2021-02-22T09:13:38+00:00","dateModified":"2021-08-26T20:11:12+00:00","mainEntityOfPage":{"@id":"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/"},"wordCount":97,"commentCount":0,"publisher":{"@id":"https:\/\/insideofcode.com\/blog\/#organization"},"articleSection":["Database (SQL)"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/","url":"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/","name":"Menampilkan semua child dengan postgresql","isPartOf":{"@id":"https:\/\/insideofcode.com\/blog\/#website"},"datePublished":"2021-02-22T09:13:38+00:00","dateModified":"2021-08-26T20:11:12+00:00","description":"Menampilkan semua child berdasarkan parent_id di portgresql (teknik recursion)","breadcrumb":{"@id":"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/insideofcode.com\/blog\/menampilkan-semua-child-dengan-dengan-parent_id-di-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/insideofcode.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Menampilkan semua child dengan postgresql"}]},{"@type":"WebSite","@id":"https:\/\/insideofcode.com\/blog\/#website","url":"https:\/\/insideofcode.com\/blog\/","name":"Inside of Code","description":"A software engineer who wants to share what he has learned, and document his journey.","publisher":{"@id":"https:\/\/insideofcode.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/insideofcode.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/insideofcode.com\/blog\/#organization","name":"Inside of Code","url":"https:\/\/insideofcode.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/10\/logo-ioc.png","contentUrl":"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/10\/logo-ioc.png","width":324,"height":324,"caption":"Inside of Code"},"image":{"@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/1c6cafc6659067aa7ac1fd1a5ced218d","name":"Dani","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4b1e4251720747aef0418e09fe0f6e7786ff89358b57f76822f1c52c286552b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4b1e4251720747aef0418e09fe0f6e7786ff89358b57f76822f1c52c286552b?s=96&d=mm&r=g","caption":"Dani"},"sameAs":["https:\/\/insideofcode.com\/blog"],"url":"https:\/\/insideofcode.com\/blog\/author\/daniwork\/"}]}},"_links":{"self":[{"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/posts\/270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/comments?post=270"}],"version-history":[{"count":0,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/posts\/270\/revisions"}],"wp:attachment":[{"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/media?parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/categories?post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/tags?post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}