{"id":905,"date":"2016-05-04T12:22:40","date_gmt":"2016-05-04T09:22:40","guid":{"rendered":"http:\/\/guvensahin.com\/?p=905"},"modified":"2020-07-05T15:06:12","modified_gmt":"2020-07-05T12:06:12","slug":"dynamics-ax-da-bir-kategorinin-tum-alt-kategorilerine-erismek","status":"publish","type":"post","link":"https:\/\/guvensahin.com\/tr\/dynamics-ax-da-bir-kategorinin-tum-alt-kategorilerine-erismek\/","title":{"rendered":"Dynamics AX da Bir Kategorinin T\u00fcm Alt Kategorilerine Eri\u015fmek"},"content":{"rendered":"<p>Merhabalar,<\/p>\n<p>Ax da bildi\u011finiz gibi \u00fcr\u00fcn kategorileri hiyerar\u015fik \u015fekilde tutulmakta. Bir kategorinin t\u00fcm alt k\u0131r\u0131l\u0131mlar\u0131nda yer alan kategorileri \u00f6\u011frenmek i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabilirsiniz. Ax kategorilerde <a href=\"https:\/\/en.wikipedia.org\/wiki\/Nested_set_model\">Nested Set Model<\/a>&#8216;i kulland\u0131\u011f\u0131 i\u00e7in a\u015fa\u011f\u0131daki sorguyu ayn\u0131 yap\u0131y\u0131 kullanan di\u011fer yerlere de uyarlayabilirsiniz.<\/p>\n<p>Ayn\u0131 \u015fekilde where ko\u015fulundan e\u015fittirleri kald\u0131rarak parent kategorinin kendisinin gelmesini engelleyebilirsiniz. Level alan\u0131na sabit de\u011fer vererek de sadece istedi\u011finiz k\u0131r\u0131l\u0131m seviyesindekilerin gelmesini sa\u011flayabilirsiniz.<\/p>\n<pre>\r\n\/\/ G\u00fcven \u015eahin\r\n\/\/ guvensahin.com\r\nstatic void PRGCategoryNestedModel(Args _args)\r\n{\r\n    EcoResCategory  childEcoResCategory;\r\n    EcoResCategory  parentEcoResCategory = EcoResCategory::find(22565422694); \/\/ parent cat\r\n    Counter         counter;\r\n\r\n    while select childEcoResCategory\r\n    where childEcoResCategory.Level >= parentEcoResCategory.Level\r\n       && childEcoResCategory.NestedSetLeft >= parentEcoResCategory.NestedSetLeft\r\n       && childEcoResCategory.NestedSetRight <= parentEcoResCategory.NestedSetRight\r\n       &#038;&#038; childEcoResCategory.CategoryHierarchy == parentEcoResCategory.CategoryHierarchy\r\n    {\r\n        counter++;\r\n        info(childEcoResCategory.name);\r\n    }\r\n\r\n    info(strFmt(\"Toplam: %1\", counter));\r\n}\r\n<\/pre>\n<p><a href=\"https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2016\/05\/ax-category-tree.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-907\" src=\"https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2016\/05\/ax-category-tree.png\" alt=\"ax-category-tree\" width=\"768\" height=\"600\" srcset=\"https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2016\/05\/ax-category-tree.png 768w, https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2016\/05\/ax-category-tree-300x234.png 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a><\/p>\n<p>Ho\u015f\u00e7akal\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar, Ax da bildi\u011finiz gibi \u00fcr\u00fcn kategorileri hiyerar\u015fik \u015fekilde tutulmakta. Bir kategorinin t\u00fcm alt k\u0131r\u0131l\u0131mlar\u0131nda yer alan kategorileri \u00f6\u011frenmek i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabilirsiniz. Ax kategorilerde Nested Set Model&#8216;i kulland\u0131\u011f\u0131 i\u00e7in a\u015fa\u011f\u0131daki sorguyu ayn\u0131 yap\u0131y\u0131 kullanan di\u011fer yerlere de uyarlayabilirsiniz. Ayn\u0131 \u015fekilde where ko\u015fulundan e\u015fittirleri kald\u0131rarak parent kategorinin kendisinin gelmesini engelleyebilirsiniz. Level alan\u0131na sabit de\u011fer vererek&hellip;&nbsp;<a href=\"https:\/\/guvensahin.com\/tr\/dynamics-ax-da-bir-kategorinin-tum-alt-kategorilerine-erismek\/\" rel=\"bookmark\">Daha fazlas\u0131n\u0131 oku &raquo;<span class=\"screen-reader-text\">Dynamics AX da Bir Kategorinin T\u00fcm Alt Kategorilerine Eri\u015fmek<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":916,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[234],"tags":[193,198,285],"class_list":["post-905","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-ax","tag-axapta","tag-dynamics-ax-2","tag-x"],"_links":{"self":[{"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts\/905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/comments?post=905"}],"version-history":[{"count":9,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts\/905\/revisions"}],"predecessor-version":[{"id":2218,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts\/905\/revisions\/2218"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/media\/916"}],"wp:attachment":[{"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/media?parent=905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/categories?post=905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/tags?post=905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}