{"id":252,"date":"2007-11-30T18:31:05","date_gmt":"2007-11-30T16:31:05","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=252"},"modified":"2007-12-04T16:01:22","modified_gmt":"2007-12-04T14:01:22","slug":"problem-nie-mozna-zrobic-kompletacji","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=252","title":{"rendered":"problem &#8211; Nie mo\u017cna zrobi\u0107 kompletacji"},"content":{"rendered":"<p>Puszczamy skrypt patch <strong>4488261<\/strong> usuwa zb\u0119dne spacje z wysy\u0142ek.<\/p>\n<p>ten sql pokazuje ze mamy problem<\/p>\n<p>SELECT count(*)<!--more--><br \/>\nFROM wsh_delivery_details wdd<br \/>\nWHERE ( length(wdd.item_description) <&gt;\nnvl(length(rtrim(wdd.item_description)),0)\nOR length(wdd.shipping_instructions) <&gt;\nnvl(length(rtrim(wdd.shipping_instructions)),0)\nOR length(wdd.packing_instructions) <&gt;\nnvl(length(rtrim(wdd.packing_instructions)),0)\nOR length(wdd.cust_po_number) <&gt;\nnvl(length(rtrim(wdd.cust_po_number)),0)\nOR length(wdd.serial_number) <&gt;\nnvl(length(rtrim(wdd.serial_number)),0)\nOR length(wdd.customer_dock_code) <&gt;\nnvl(length(rtrim(wdd.customer_dock_code)),0)\nOR length(wdd.tracking_number) <&gt;\nnvl(length(rtrim(wdd.tracking_number)),0)\nOR length(wdd.TP_ATTRIBUTE15) <&gt;\nnvl(length(rtrim(wdd.TP_ATTRIBUTE15)),0)\nOR length(wdd.customer_job) <&gt; nvl(length(rtrim(wdd.customer_job)),0)\nOR length(wdd.cust_model_serial_number) <&gt;\nnvl(length(rtrim(wdd.cust_model_serial_number)),0) )\nAND wdd.source_code = 'OE'\nAND wdd.released_status in ('R','B','X','N','Y','S')\nAND wdd.container_flag = 'N';\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Puszczamy skrypt patch 4488261 usuwa zb\u0119dne spacje z wysy\u0142ek. ten sql pokazuje ze mamy problem SELECT count(*)<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[225,226],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/252"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=252"}],"version-history":[{"count":0,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/252\/revisions"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}