{"id":297,"date":"2009-04-21T11:43:13","date_gmt":"2009-04-21T09:43:13","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=297"},"modified":"2009-04-21T11:45:32","modified_gmt":"2009-04-21T09:45:32","slug":"hierarchia-stonowisk","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=297","title":{"rendered":"hierarchia stonowisk"},"content":{"rendered":"<p>Do wy\u015bwietlania hierarchii stanowisk wykorzysytwanych w module Zakupy jest raport:<\/p>\n<p><font color=\"#800000\"><strong>XX: Raport hierarchii stanowisk <\/strong><\/font><\/p>\n<p>Raport pokazuje hierarchi\u0119 stanowisk wraz z przypisanymi pracownikami. Mo\u017cliwo\u015b\u0107 wys\u0142ania danych na maila w pliku Excel.<\/p>\n<p>przydatne zpytanie:<!--more--><\/p>\n<pre lang=\"plsql\">-- selekt pokazuj\u0105ce najwy\u017csze stanowisko w hierarchii\r\nselect distinct p.NAME\r\n  from per_pos_structure_elements el, PER_POSITIONS p\r\n where el.pos_structure_version_id = 3068 -- id hierarchii do sprawdzenia w PER_POSITION_STRUCTURES\r\n   and p.POSITION_ID in\r\n       (select distinct el1.parent_position_id\r\n          from per_pos_structure_elements el1\r\n         where el1.pos_structure_version_id = 3068) -- -- id hierarchii\r\n   and p.POSITION_ID not in\r\n       (select distinct el2.subordinate_position_id\r\n          from per_pos_structure_elements el2\r\n         where el2.pos_structure_version_id = 3068) ---- id hierarchii<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Do wy\u015bwietlania hierarchii stanowisk wykorzysytwanych w module Zakupy jest raport: XX: Raport hierarchii stanowisk Raport pokazuje hierarchi\u0119 stanowisk wraz z przypisanymi pracownikami. Mo\u017cliwo\u015b\u0107 wys\u0142ania danych na maila w pliku Excel. przydatne zpytanie:<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[43,11],"tags":[225,226],"_links":{"self":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/297"}],"collection":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=297"}],"version-history":[{"count":0,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/297\/revisions"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=297"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}