{"id":1784,"date":"2019-03-22T19:49:45","date_gmt":"2019-03-22T16:49:45","guid":{"rendered":"http:\/\/guvensahin.com\/?p=1784"},"modified":"2020-05-12T23:58:41","modified_gmt":"2020-05-12T20:58:41","slug":"dynamics-ax-enum-etiketlerine-sqlden-erismek","status":"publish","type":"post","link":"https:\/\/guvensahin.com\/tr\/dynamics-ax-enum-etiketlerine-sqlden-erismek\/","title":{"rendered":"Dynamics AX Enum Etiketlerine SQL&#8217;den Eri\u015fmek"},"content":{"rendered":"\n<p>AX&#8217;\u0131n veritaban\u0131ndan benim gibi s\u0131k s\u0131k sorgu \u00e7ekiyorsan\u0131z veya ax&#8217;dan veri \u00e7eken bir entegrasyon yaz\u0131yorsan\u0131z, enum tipindeki alanlarda g\u00f6rd\u00fc\u011f\u00fcn\u00fcz say\u0131sal de\u011ferin label kar\u015f\u0131l\u0131\u011f\u0131n\u0131 g\u00f6rmek isteyebilirsiniz.<\/p>\n\n\n\n<p>Ax i\u00e7inde standart olarak gelen <strong>SRSAnalysisEnums<\/strong> tablosunda i\u015f zekas\u0131 ile ilgili baz\u0131 enum labellar\u0131 bulunuyor. Bu tabloyu <strong>BIGenerator::populateSRSAnalysisEnums()<\/strong> method&#8217;u dolduruyor. \u0130nternette \u00e7e\u015fitli kaynaklar, bu s\u0131n\u0131f\u0131 modifiye ederek istedi\u011finiz enumlar i\u00e7in nas\u0131l \u00e7al\u0131\u015ft\u0131raca\u011f\u0131n\u0131zdan bahsediyor. Fakat bu i\u015flemler gereksiz uzun.<\/p>\n\n\n\n<p>Ben yine bu s\u0131n\u0131f\u0131 temel alan ve kullanmas\u0131 \u00e7ok daha basit bir s\u0131n\u0131f haz\u0131rlad\u0131m. Bu yard\u0131mc\u0131 s\u0131n\u0131f\u0131 ax&#8217;a dahil ettikten sonra a\u015fa\u011f\u0131daki job&#8217;\u0131 \u00e7al\u0131\u015ft\u0131rarak istedi\u011finiz enumlar\u0131n, istedi\u011finiz dildeki labellar\u0131n\u0131  <br><strong>SRSAnalysisEnums<\/strong> tablosuna kaydediyor. Art\u0131k SQL&#8217;den direkt bu tabloya sorgu \u00e7ekerek labellara eri\u015febilirsiniz.<\/p>\n\n\n\n<p><strong>S\u0131n\u0131f\u0131 <a href=\"https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2019\/03\/PrivateProject_GvnEnumLabelGenerator.zip\">buradan indirebilirsiniz.<\/a><\/strong><\/p>\n\n\n\n<pre>\/\/ G\u00fcven \u015eahin\n\/\/ guvensahin.com\nstatic void GvnEnumLabelGeneratorJob(Args _args)\n{\n    GvnEnumLabelGenerator   GvnEnumLabelGenerator;\n    container               conLanguage;\n    container               conEnumNum;\n    ;\n\n    conLanguage = [\"en-us\", \"en-au\"];\n\n    conEnumNum += enumNum(DmrItemLabelType);\n    conEnumNum += enumNum(DmrPassportType);\n\n\n    GvnEnumLabelGenerator = new GvnEnumLabelGenerator(conLanguage, conEnumNum);\n    GvnEnumLabelGenerator.run();\n\n    info(\"done. check SRSAnalysisEnums table.\");\n}<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"603\" src=\"https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2019\/03\/GvnEnumLabelGenerator-1024x603.png\" alt=\"\" class=\"wp-image-1791\" srcset=\"https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2019\/03\/GvnEnumLabelGenerator-1024x603.png 1024w, https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2019\/03\/GvnEnumLabelGenerator-300x177.png 300w, https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2019\/03\/GvnEnumLabelGenerator-768x452.png 768w, https:\/\/guvensahin.com\/tr\/wp-content\/uploads\/2019\/03\/GvnEnumLabelGenerator.png 1240w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Son olarak ben sadece AX 2012 de test ettim. Fakat kodlar Dynamics 365 F&amp;O i\u00e7inde ge\u00e7erli.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>AX&#8217;\u0131n veritaban\u0131ndan benim gibi s\u0131k s\u0131k sorgu \u00e7ekiyorsan\u0131z veya ax&#8217;dan veri \u00e7eken bir entegrasyon yaz\u0131yorsan\u0131z, enum tipindeki alanlarda g\u00f6rd\u00fc\u011f\u00fcn\u00fcz say\u0131sal de\u011ferin label kar\u015f\u0131l\u0131\u011f\u0131n\u0131 g\u00f6rmek isteyebilirsiniz. Ax i\u00e7inde standart olarak gelen SRSAnalysisEnums tablosunda i\u015f zekas\u0131 ile ilgili baz\u0131 enum labellar\u0131 bulunuyor. Bu tabloyu BIGenerator::populateSRSAnalysisEnums() method&#8217;u dolduruyor. \u0130nternette \u00e7e\u015fitli kaynaklar, bu s\u0131n\u0131f\u0131 modifiye ederek istedi\u011finiz enumlar i\u00e7in&hellip;&nbsp;<a href=\"https:\/\/guvensahin.com\/tr\/dynamics-ax-enum-etiketlerine-sqlden-erismek\/\" rel=\"bookmark\">Daha fazlas\u0131n\u0131 oku &raquo;<span class=\"screen-reader-text\">Dynamics AX Enum Etiketlerine SQL&#8217;den 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,434,285],"class_list":["post-1784","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-ax","tag-axapta","tag-dynamics-ax-2","tag-sql","tag-x"],"_links":{"self":[{"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts\/1784","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=1784"}],"version-history":[{"count":12,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts\/1784\/revisions"}],"predecessor-version":[{"id":1822,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/posts\/1784\/revisions\/1822"}],"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=1784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/categories?post=1784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guvensahin.com\/tr\/wp-json\/wp\/v2\/tags?post=1784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}