{"id":577,"date":"2010-08-06T22:57:18","date_gmt":"2010-08-06T19:57:18","guid":{"rendered":"https:\/\/enginhafizoglu.com\/?p=577"},"modified":"2011-09-29T10:18:38","modified_gmt":"2011-09-29T07:18:38","slug":"standart-deger-listesini-form-kisisellestirme-ile-sinirlama","status":"publish","type":"post","link":"https:\/\/enginhafizoglu.com\/?p=577","title":{"rendered":"Standart De\u011fer Listesini Form Ki\u015fiselle\u015ftirme \u0130le S\u0131n\u0131rlama"},"content":{"rendered":"<p><!--more--><img decoding=\"async\" src=\"https:\/\/enginhafizoglu.com\/wp-content\/uploads\/2010\/08\/080610_1957_StandartDee1.png\" alt=\"\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/enginhafizoglu.com\/wp-content\/uploads\/2010\/08\/080610_1957_StandartDee2.png\" alt=\"\" \/><span style=\"font-family: Times New Roman; font-size: 12pt;\"><br \/>\n<\/span><\/p>\n<p>Hangi alan\u0131 k\u0131s\u0131tlayacaksak o alan trigger object k\u0131sm\u0131nda se\u00e7ilir. Trigger Event WHEN-NEW-ITEM-INSTANCE se\u00e7ilir. EAM_WORKORDERS.OWNING_DEPARTMENT_CODE_MIR<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/enginhafizoglu.com\/wp-content\/uploads\/2010\/08\/080610_1957_StandartDee3.png\" alt=\"\" \/><span style=\"font-family: Times New Roman; font-size: 12pt;\"><br \/>\n<\/span><\/p>\n<p>\u0130lk a\u015famada Type Builtin olarak se\u00e7ilir. Builtin Type olarak &#8220;Create Record Group from Query&#8221; se\u00e7ilir.<\/p>\n<p>Argument k\u0131sm\u0131na formda yap\u0131lan sorgu ile ayn\u0131 \u015fekilde k\u0131s\u0131tlaman\u0131n yap\u0131ld\u0131\u011f\u0131 sql yaz\u0131l\u0131r.<\/p>\n<p>[sql]select department_id, department_code, description from bom_departments where organization_id = :parameter.org_id and nvl(disable_date, sysdate+2) &gt; sysdate<br \/>\nand DEPARTMENT_CLASS_CODE=&#8217;Maint Dept&#8217; &#8211;sonradan eklenen k\u0131s\u0131tlama<br \/>\norder by department_code[\/sql]<\/p>\n<p><span style=\"color: black;\"><span style=\"background-color: lime;\">Yap\u0131lan sorgunun formun i\u00e7indeki sorgu ile uyumlu olmas\u0131 gerekli!!!<\/span><\/span><\/p>\n<p>Grup ismi elle girilir. \u00d6rnek:GROUP_NAME_EH<img decoding=\"async\" src=\"https:\/\/enginhafizoglu.com\/wp-content\/uploads\/2010\/08\/080610_1957_StandartDee4.png\" alt=\"\" \/><span style=\"font-family: Times New Roman; font-size: 12pt;\"><br \/>\n<\/span>Alt sat\u0131ra (11) Property se\u00e7ilir. Object Type LOV olarak se\u00e7ilir. Target Object s\u0131n\u0131rlanmas\u0131 istenen de\u011fer listesidir. Property Name:Group_Name se\u00e7ilir. Value ise bir \u00fcst sat\u0131rda girilen grup ad\u0131 olarak girilir.<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[102,103,35,37],"class_list":["post-577","post","type-post","status-publish","format-standard","hentry","category-oracle-e-is-yonetim-sistemi","tag-form-kisisellestirme","tag-lov-customization","tag-oracle","tag-personalization"],"_links":{"self":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=577"}],"version-history":[{"count":5,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/577\/revisions"}],"predecessor-version":[{"id":579,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/577\/revisions\/579"}],"wp:attachment":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}