{"id":993,"date":"2021-05-31T08:52:01","date_gmt":"2021-05-31T08:52:01","guid":{"rendered":"https:\/\/podpora.nuggetsw.cz\/?post_type=lsvr_kba&#038;p=993"},"modified":"2026-04-30T13:25:32","modified_gmt":"2026-04-30T13:25:32","slug":"query","status":"publish","type":"lsvr_kba","link":"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/query\/","title":{"rendered":"Sestavy: Query"},"content":{"rendered":"\n<p>Query slou\u017e\u00ed k vytv\u00e1\u0159en\u00ed vlastn\u00edch p\u0159ehled\u016f a v\u00fdstupn\u00edch sestav dle konkr\u00e9tn\u00edch po\u017eadavk\u016f u\u017eivatele. Umo\u017e\u0148uj\u00ed kombinovat r\u016fzn\u00e9 \u00fadaje a p\u0159ipravit si v\u00fdstupy p\u0159esn\u011b podle pot\u0159eby.<\/p>\n\n\n\n<p>U\u017eivatelsk\u00e9 query se vytv\u00e1\u0159ej\u00ed a eviduj\u00ed <strong>samostatn\u011b pro modul Mzdy a samostatn\u011b pro modul Personalistika<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"572\" height=\"394\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-44.png\" alt=\"\" class=\"wp-image-12380\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-44.png 572w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-44-300x207.png 300w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/figure><\/div>\n\n\n<p><strong>Funkce<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Mzdy: 12-4<\/strong><\/li>\n\n\n\n<li><strong>Personalistika: 4-3<\/strong><\/li>\n<\/ol>\n\n\n\n<p><strong>V\u00fdstupn\u00ed soubor:<\/strong> V obou modulech se vytvo\u0159en\u00fd v\u00fdstup ukl\u00e1d\u00e1 do pracovn\u00edho adres\u00e1\u0159e u\u017eivatele ve form\u00e1tu CSV.<\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Funkce v tabulce &#8222;U\u017eivatelsk\u00e9 query&#8220;<\/h3>\n\n\n\n<p><strong>Upravit<\/strong>: N\u00e1hled \u010di aktualizace ji\u017e d\u0159\u00edve vytvo\u0159en\u00e9 sestavy.<\/p>\n\n\n\n<p><strong>V\u00fdstup do Excelu<\/strong>: Tvorba v\u00fdstupu do pracovn\u00edho adres\u00e1\u0159e. V z\u00e1vislosti na vlo\u017een\u00fdch \u00fadaj\u00edch se bu\u010f sestava rovnou vytvo\u0159\u00ed nebo v\u00e1s syst\u00e9m vyzve k potvrzen\u00ed \u010di \u00faprav\u011b vstupn\u00edch parametr\u016f.<\/p>\n\n\n\n<p><strong>Nov\u00fd z\u00e1znam<\/strong>: Pro tvorbu nov\u00e9 sestavy.<\/p>\n\n\n\n<p><strong>Kopie<\/strong>: Zkop\u00edrov\u00e1n\u00ed ji\u017e existuj\u00edc\u00ed sestavy bez ovlivn\u011bn\u00ed p\u016fvodn\u00ed sestavy.<\/p>\n\n\n\n<p><strong>P\u0159ejmenovat<\/strong>: Umo\u017e\u0148uje p\u0159ejmenov\u00e1n\u00ed st\u00e1vaj\u00edc\u00ed sestavy.<\/p>\n\n\n\n<p><strong>Smazat z\u00e1znam<\/strong>: Smaz\u00e1n\u00ed sestavy, kter\u00e1 ji\u017e nen\u00ed pot\u0159eba nebo byla vytvo\u0159ena omylem.<\/p>\n\n\n\n<p><strong>\u010c\u00edseln\u00edk \u00fadaj\u016f<\/strong>: Pomoc\u00ed \u010d\u00edseln\u00edku lze trvale upravit n\u00e1zvy vybran\u00fdch polo\u017eek, aby je nebylo nutn\u00e9 p\u0159ejmenov\u00e1vat p\u0159i ka\u017ed\u00e9m vlo\u017een\u00ed do sestavy (nap\u0159. \u201eosobn\u00ed \u010d\u00edslo\u201c \u2192 \u201eos.\u010d.\u201c).<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\">Vytvo\u0159en\u00ed a pr\u00e1ce s query<\/h2>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Vytvo\u0159en\u00ed nov\u00e9 sestavy<\/h3>\n\n\n\n<p><strong>Funkce Mzdy 12-4 \/ Pers 4-3 &#8222;Query&#8220; &#8211; &#8222;Nov\u00fd z\u00e1znam<\/strong>&#8222;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"460\" height=\"177\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-45.png\" alt=\"\" class=\"wp-image-12381\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-45.png 460w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-45-300x115.png 300w\" sizes=\"auto, (max-width: 460px) 100vw, 460px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>zadejte:\n<ul class=\"wp-block-list\">\n<li><strong>Query = n\u00e1zev<\/strong> (doporu\u010dujeme n\u00e1zev zvolit kr\u00e1tk\u00fd a unik\u00e1tn\u00ed, bez mezer; duplicitn\u00ed n\u00e1zev program nepovol\u00ed)<\/li>\n\n\n\n<li><strong>N\u00e1zev = popis sestavy<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>Po potvrzen\u00ed tla\u010d\u00edtkem OK:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>query se ulo\u017e\u00ed do seznamu<\/li>\n\n\n\n<li>z\u00e1rove\u0148 se otev\u0159e okno \u201eDefinice query\u201c<\/li>\n<\/ul>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary><em>Definice query &#8211; obr\u00e1zek<\/em><\/summary>\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"934\" height=\"743\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-56.png\" alt=\"\" class=\"wp-image-12392\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-56.png 934w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-56-300x239.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-56-768x611.png 768w\" sizes=\"auto, (max-width: 934px) 100vw, 934px\" \/><\/figure>\n<\/details>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Definice query<\/h3>\n\n\n\n<p>Slou\u017e\u00ed k nastaven\u00ed struktury v\u00fdsledn\u00e9 sestavy. V t\u00e9to \u010d\u00e1sti ur\u010dujete:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>jak\u00e9 \u00fadaje budou ve v\u00fdstupu,<\/li>\n\n\n\n<li>v jak\u00e9m po\u0159ad\u00ed se zobraz\u00ed,<\/li>\n\n\n\n<li>jak se budou jmenovat \u00fadaje v hlavi\u010dce dan\u00e9ho sloupce.<\/li>\n<\/ul>\n\n\n\n<p>\u00dadaje vyb\u00edr\u00e1te z lev\u00e9 \u010d\u00e1sti obrazovky a p\u0159esouv\u00e1te do prav\u00e9 \u010d\u00e1sti, kter\u00e1 p\u0159edstavuje fin\u00e1ln\u00ed podobu v\u00fdstupu. <\/p>\n\n\n\n<p>P\u0159esun \u00fadaj\u016f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>pomoc\u00ed \u0161ipky doprava, <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"894\" height=\"90\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-71.png\" alt=\"\" class=\"wp-image-12411\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-71.png 894w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-71-300x30.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-71-768x77.png 768w\" sizes=\"auto, (max-width: 894px) 100vw, 894px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>dvojklikem lev\u00e9ho tla\u010d\u00edtka my\u0161i,<\/li>\n\n\n\n<li>nebo p\u0159eta\u017een\u00edm my\u0161\u00ed zleva doprava.<\/li>\n<\/ul>\n\n\n\n<p>Vyhled\u00e1v\u00e1n\u00ed:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>pou\u017eijte filtr pod levou tabulkou<\/li>\n\n\n\n<li>zadejte za\u010d\u00e1tek n\u00e1zvu \u00fadaje a zobraz\u00ed se odpov\u00eddaj\u00edc\u00ed polo\u017eky<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"648\" height=\"60\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-46.png\" alt=\"\" class=\"wp-image-12382\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-46.png 648w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-46-300x28.png 300w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">\u00daprava sloupc\u016f (prav\u00e1 \u010d\u00e1st obrazovky)<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"431\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-57.png\" alt=\"\" class=\"wp-image-12393\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-57.png 494w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-57-300x262.png 300w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>zm\u011bna po\u0159ad\u00ed<\/strong>: modr\u00e9 \u0161ipky nahoru \/ dol\u016f<\/li>\n\n\n\n<li><strong>p\u0159ejmenov\u00e1n\u00ed \u00fadaje (sloupce<\/strong>): ve \u017elut\u00e9m poli \u201eText do hlavi\u010dky\u201c (max. 20 znak\u016f)<\/li>\n<\/ul>\n\n\n\n<p>Ulo\u017een\u00ed: tla\u010d\u00edtko OK<\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Roz\u0161\u00ed\u0159en\u00ed souboru o dal\u0161\u00ed \u00fadaje \u2013 tla\u010d\u00edtko \u201eSoubor\u201c<\/h3>\n\n\n\n<p>Pou\u017eijte v p\u0159\u00edpad\u011b, \u017ee pot\u0159ebujete pracovat s \u00fadaji, kter\u00e9 nejsou v z\u00e1kladn\u00ed nab\u00eddce, tedy v z\u00e1kladn\u00edm souboru LS001.<\/p>\n\n\n\n<p>Postup:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>V okn\u011b \u201eDefinice query\u201c klikn\u011bte na tla\u010d\u00edtko \u201eSoubor\u201c (vlevo dole pod tabulkou s \u00fadaji).<\/li>\n\n\n\n<li>Otev\u0159e se seznam dostupn\u00fdch datov\u00fdch soubor\u016f.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"606\" height=\"395\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-59.png\" alt=\"\" class=\"wp-image-12395\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-59.png 606w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-59-300x196.png 300w\" sizes=\"auto, (max-width: 606px) 100vw, 606px\" \/><\/figure><\/div>\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Vyberte po\u017eadovan\u00fd soubor (nap\u0159. adresy, st\u0159ediska, sr\u00e1\u017eky apod.).<\/li>\n\n\n\n<li>P\u0159\u00edpadn\u011b nastavte parametr \u201eHistorie\u201c (viz n\u00ed\u017ee).<\/li>\n\n\n\n<li>U v\u00edce\u0159\u00e1dkov\u00fdch dat ur\u010dete, zda chcete pou\u017e\u00edt parametr &#8222;V\u017edy generovat data z kmenov\u00e9ho souboru&#8220; (viz n\u00ed\u017ee).<\/li>\n\n\n\n<li>V\u00fdb\u011br potvr\u010fte tla\u010d\u00edtkem OK.<\/li>\n\n\n\n<li>Zvolen\u00fd soubor se p\u0159id\u00e1 do nab\u00eddky \u00fadaj\u016f \u2013 nov\u00e9 polo\u017eky se zobraz\u00ed v lev\u00e9 \u010d\u00e1sti tabulky (obvykle na konci seznamu).<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"407\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-50.png\" alt=\"\" class=\"wp-image-12386\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-50.png 377w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-50-278x300.png 278w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><\/figure><\/div>\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>N\u00e1sledn\u011b z t\u011bchto nov\u011b p\u0159idan\u00fdch \u00fadaj\u016f vyb\u00edrejte stejn\u00e9 jako ze z\u00e1kladn\u00edho souboru (p\u0159esunem doprava).<\/li>\n<\/ol>\n\n\n\n<p><strong>Dostupn\u00e9 soubory, kter\u00e9 lze p\u0159idat:<\/strong> Ozna\u010den\u00ed v z\u00e1vorce se zobrazuje ve v\u00fdb\u011bru \u00fadaj\u016f (v horn\u00ed lev\u00e9 \u010d\u00e1sti obrazovky).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>adresy (LS019)<\/li>\n\n\n\n<li>st\u0159ediska (LS040)<\/li>\n\n\n\n<li>stavy (STAVY)<\/li>\n\n\n\n<li>rodinn\u00ed p\u0159\u00edslu\u0161n\u00edci (LS004)<\/li>\n\n\n\n<li>sr\u00e1\u017eky (LS043)<\/li>\n\n\n\n<li>sr\u00e1\u017eky na \u00fa\u010det (LS044)<\/li>\n\n\n\n<li>mzdov\u00e9 statistiky (LS722, LS723)<\/li>\n<\/ul>\n\n\n\n<p><strong>Upozorn\u011bn\u00ed:<\/strong> Po p\u0159id\u00e1n\u00ed dal\u0161\u00edho souboru (nap\u0159. soubor LS019, LS040, apod.):<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>se jeho \u00fadaje zobraz\u00ed a\u017e na konci seznamu,<\/li>\n\n\n\n<li>je nutn\u00e9 je ru\u010dn\u011b vybrat do prav\u00e9 \u010d\u00e1sti (nep\u0159idaj\u00ed se automaticky)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Kombinace p\u0159id\u00e1van\u00fdch soubor\u016f<\/h3>\n\n\n\n<p>Kombinace soubor\u016f m\u00e1 sv\u00e1 pravidla:<\/p>\n\n\n\n<p><strong>Lze kombinovat:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LS001 (z\u00e1kladn\u00ed soubor)<\/li>\n\n\n\n<li>LS019 (adresy)<\/li>\n\n\n\n<li>LS040 (st\u0159ediska)<\/li>\n\n\n\n<li>STAVY<\/li>\n\n\n\n<li>LS043 (sr\u00e1\u017eky)<\/li>\n<\/ul>\n\n\n\n<p><strong>Nelze kombinovat:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LS004 (rodinn\u00ed p\u0159\u00edslu\u0161n\u00edci)<\/li>\n\n\n\n<li>LS044 (sr\u00e1\u017eky na \u00fa\u010det)<\/li>\n\n\n\n<li>mzdov\u00e9 statistiky<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Parametr \u201eHistorie\u201c<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"598\" height=\"377\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-58.png\" alt=\"\" class=\"wp-image-12394\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-58.png 598w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-58-300x189.png 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/figure><\/div>\n\n\n<p>Parametr \u201eHistorie\u201c ur\u010duje, jak se budou zobrazovat \u010dasov\u011b prom\u011bnn\u00e9 \u00fadaje.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>neza\u0161krtnuto<\/strong>: zobraz\u00ed se aktu\u00e1ln\u00ed (posledn\u00ed platn\u00e1) hodnota<\/li>\n\n\n\n<li><strong>za\u0161krtnuto<\/strong>: zobraz\u00ed se jednotliv\u00e9 z\u00e1znamy historicky (po m\u011bs\u00edc\u00edch \u2013 ka\u017ed\u00fd z\u00e1znam jako samostatn\u00fd \u0159\u00e1dek)<\/li>\n<\/ul>\n\n\n\n<p>Pou\u017eit\u00ed:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>vhodn\u00e9 nap\u0159. pro sledov\u00e1n\u00ed zm\u011bn v \u010dase<\/li>\n\n\n\n<li>nevhodn\u00e9 pro jednoduch\u00e9 p\u0159ehledy, kde m\u00e1 b\u00fdt jeden \u0159\u00e1dek = jeden zam\u011bstnanec<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Parametr &#8222;V\u017edy generovat data z kmenov\u00e9ho souboru&#8220;<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"117\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-60.png\" alt=\"\" class=\"wp-image-12396\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-60.png 614w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-60-300x57.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/figure><\/div>\n\n\n<p>P\u0159i pr\u00e1ci s v\u00edce\u0159\u00e1dkov\u00fdmi daty (nap\u0159. rodinn\u00ed p\u0159\u00edslu\u0161n\u00edci, statistiky) se zobraz\u00ed volba \u201ev\u017edy generovat data z kmenov\u00e9ho \u00fadaje\u201c. Tento parametr ur\u010duje, zda se ve v\u00fdsledn\u00e9 sestav\u011b zobraz\u00ed v\u0161ichni zam\u011bstnanci, nebo pouze ti, kte\u0159\u00ed maj\u00ed k dan\u00e9mu \u00fadaji data.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Za\u0161krtnuto<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>do v\u00fdstupu se zobraz\u00ed v\u0161ichni zam\u011bstnanci ze z\u00e1kladn\u00edho souboru (LS001),<\/li>\n\n\n\n<li>i ti, kte\u0159\u00ed nemaj\u00ed k dan\u00e9mu \u00fadaji \u017e\u00e1dnou hodnotu,<\/li>\n\n\n\n<li>u t\u011bchto zam\u011bstnanc\u016f bude hodnota pr\u00e1zdn\u00e1 nebo 0<\/li>\n<\/ul>\n\n\n\n<p><em>Pou\u017eit\u00ed<\/em>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>chcete kompletn\u00ed p\u0159ehled v\u0161ech zam\u011bstnanc\u016f,<\/li>\n\n\n\n<li>nap\u0159. kontroln\u00ed sestavy, porovn\u00e1n\u00ed, p\u0159ehledy.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Neza\u0161krtnuto<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>do v\u00fdstupu se zobraz\u00ed pouze zam\u011bstnanci, kte\u0159\u00ed maj\u00ed k dan\u00e9mu \u00fadaji z\u00e1znam,<\/li>\n\n\n\n<li>zam\u011bstnanci bez hodnoty se do sestavy v\u016fbec nedostanou.<\/li>\n<\/ul>\n\n\n\n<p><em>Pou\u017eit\u00ed<\/em>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>chcete pouze zam\u011bstnance, kter\u00fdch se dan\u00fd \u00fadaj t\u00fdk\u00e1, nap\u0159. jen zam\u011bstnance se sr\u00e1\u017ekami, \u0161kolen\u00edm, statistikou apod.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Parametry: Mzdov\u00e9 statistiky (LS722, LS723)<\/h3>\n\n\n\n<p>Mo\u017enost napojen\u00ed:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LS722 \u2013 zam\u011bstnanci podle kmenov\u00fdch st\u0159edisek (2-7-3)<\/li>\n\n\n\n<li>LS723 \u2013 \u010dasov\u00e9 \u0159ady (2-7-4)<\/li>\n<\/ul>\n\n\n\n<p>Po p\u0159id\u00e1n\u00ed se op\u011bt polo\u017eky zobraz\u00ed na konci seznamu \u00fadaj\u016f a je nutn\u00e9 je p\u0159idat do seznamu vpravo. Lze p\u0159ipojit pouze jednu mzdovou statistiku (LS722 nebo LS723) a nelze kombinovat v\u00edce statistik mezi sebou.<\/p>\n\n\n\n<p>P\u0159i zm\u011bn\u011b mzdov\u00e9 statistiky:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>je nutn\u00e9 ru\u010dn\u011b upravit i query,<\/li>\n\n\n\n<li>p\u0159i odebr\u00e1n\u00ed slo\u017eky z\u016fstane v query pr\u00e1zdn\u00e1 hodnota.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Dal\u0161\u00ed tla\u010d\u00edtka v tabulce \u201eDefinice query\u201c<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"930\" height=\"71\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-64.png\" alt=\"\" class=\"wp-image-12401\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-64.png 930w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-64-300x23.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-64-768x59.png 768w\" sizes=\"auto, (max-width: 930px) 100vw, 930px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">T\u0159\u00edd\u011bn\u00ed<\/h3>\n\n\n\n<p>Pomoc\u00ed t\u00e9to funkce definujete t\u0159\u00edd\u011bn\u00ed \u00fadaj\u016f ve v\u00fdstupn\u00edm souboru:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>lze nastavit v\u00edce \u00farovn\u00ed t\u0159\u00edd\u011bn\u00ed<\/li>\n\n\n\n<li>nap\u0159. nejprve podle jm\u00e9na, n\u00e1sledn\u011b podle st\u0159ediska<\/li>\n\n\n\n<li>u ka\u017ed\u00e9ho \u00fadaje lze zvolit:\n<ul class=\"wp-block-list\">\n<li>vzestupn\u011b<\/li>\n\n\n\n<li>sestupn\u011b<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Port\u00e1l &#8211; nutno m\u00edt zakoupen\u00fd HR Port\u00e1l<\/h3>\n\n\n\n<p>Podm\u00ednkou pou\u017eit\u00ed je zakoupen\u00fd modul HR Port\u00e1l.<\/p>\n\n\n\n<p>Tla\u010d\u00edtko Port\u00e1l slou\u017e\u00ed k p\u0159i\u0159azen\u00ed nad\u0159\u00edzen\u00fdch zam\u011bstnanc\u016f (dle osobn\u00edch \u010d\u00edsel), kte\u0159\u00ed budou m\u00edt opr\u00e1vn\u011bn\u00ed zobrazit dan\u00e9 query v HR Port\u00e1lu v modulu Reporty.<\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">V\u00fdb\u011brov\u00e9 krit\u00e9rium<\/h3>\n\n\n\n<p>Pomoc\u00ed t\u00e9to funkce lze zadat a trvale ulo\u017eit filtr pro v\u00fdb\u011br dat.<\/p>\n\n\n\n<p><strong>Pou\u017eit\u00ed existuj\u00edc\u00edho krit\u00e9ria<\/strong>: vyberete ji\u017e ulo\u017een\u00e9 v\u00fdb\u011brov\u00e9 krit\u00e9rium ze seznamu<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Vytvo\u0159en\u00ed nov\u00e9ho v\u00fdb\u011brov\u00e9ho krit\u00e9ria<\/h4>\n\n\n\n<p>Postup:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Klikn\u011bte na \u201e*DFT Prvotn\u00ed krit\u00e9rium MZDY\u201c \u2013 \u201eUpravit\u201c.<\/li>\n\n\n\n<li>Otev\u0159e se okno pro definici podm\u00ednek.<\/li>\n\n\n\n<li>Klikn\u011bte na \u201eP\u0159idat podm\u00ednku\u201c nebo p\u0159epi\u0161te st\u00e1vaj\u00edc\u00ed \u0159\u00e1dek s L0001.<\/li>\n\n\n\n<li>Do pole \u201e\u00dadaj\u201c vyberte po\u017eadovan\u00fd \u00fadaj (nap\u0159. L0002 pracovn\u00ed st\u0159edisko).<\/li>\n\n\n\n<li>Do pole \u201eTest\u201c zvolte podm\u00ednku (nap\u0159. = je rovno).<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"244\" height=\"198\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-54.png\" alt=\"\" class=\"wp-image-12390\"\/><\/figure><\/div>\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>Do pole \u201eHodnota\u201c vyberte konkr\u00e9tn\u00ed hodnotu (nap\u0159. konkr\u00e9tn\u00ed st\u0159edisko).\n<ul class=\"wp-block-list\">\n<li>P\u0159\u00edklad:\n<ul class=\"wp-block-list\">\n<li>Chci zobrazit pouze zam\u011bstnance z ur\u010dit\u00e9ho st\u0159ediska:\n<ul class=\"wp-block-list\">\n<li>\u00dadaj: L0002 pracovn\u00ed st\u0159edisko<\/li>\n\n\n\n<li>Test: = (je rovno)<\/li>\n\n\n\n<li>Hodnota: vybran\u00e9 st\u0159edisko<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"661\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-53.png\" alt=\"\" class=\"wp-image-12389\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-53.png 772w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-53-300x257.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-53-768x658.png 768w\" sizes=\"auto, (max-width: 772px) 100vw, 772px\" \/><\/figure><\/div>\n\n\n<ol start=\"7\" class=\"wp-block-list\">\n<li>Klikn\u011bte vlevo na tla\u010d\u00edtko \u201eUlo\u017eit jako\u201c.<\/li>\n\n\n\n<li>Zadejte n\u00e1zev krit\u00e9ria.<\/li>\n\n\n\n<li>Zvolte, zda bude:\n<ul class=\"wp-block-list\">\n<li>pouze pro u\u017eivatele<\/li>\n\n\n\n<li>pro v\u0161echny u\u017eivatele<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"499\" height=\"214\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-55.png\" alt=\"\" class=\"wp-image-12391\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-55.png 499w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-55-300x129.png 300w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/figure><\/div>\n\n\n<ol start=\"10\" class=\"wp-block-list\">\n<li>Potvr\u010fte OK a cel\u00e9 ulo\u017ete OK.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\">V\u00fdstup do Excelu<\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"387\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-65.png\" alt=\"\" class=\"wp-image-12403\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-65.png 570w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-65-300x204.png 300w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/figure><\/div>\n\n\n<p>Chov\u00e1n\u00ed tla\u010d\u00edtka \u201e<strong>V\u00fdstup do Excelu<\/strong>\u201c se li\u0161\u00ed podle typu sestavy.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>u n\u011bkter\u00fdch sestav (zejm\u00e9na s p\u0159ipojen\u00fdmi soubory p\u0159es tla\u010d\u00edtko \u201eSoubor\u201c \u2013 LSxxx\/Sxxx)\n<ul class=\"wp-block-list\">\n<li>se po stisknut\u00ed tla\u010d\u00edtka v\u00fdstup rovnou vygeneruje, p\u0159\u00edpadn\u011b se automaticky zobraz\u00ed okno pro zad\u00e1n\u00ed krit\u00e9ri\u00ed<\/li>\n\n\n\n<li>nen\u00ed mo\u017en\u00e9 volit mezi \u201eStandardn\u00ed\u201c a \u201eVoliteln\u00e9 parametry\u201c<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>u jednodu\u0161\u0161\u00edch sestav je mo\u017en\u00e9 vybrat zp\u016fsob v\u00fdstupu (Standardn\u00ed \/ Voliteln\u00e9 parametry)<\/li>\n<\/ul>\n\n\n\n<p>V\u00fdstupn\u00ed soubor se v\u017edy ukl\u00e1d\u00e1 do pracovn\u00edho adres\u00e1\u0159e a jeho n\u00e1zev odpov\u00edd\u00e1 n\u00e1zvu query.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"357\" height=\"139\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-68.png\" alt=\"\" class=\"wp-image-12406\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-68.png 357w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-68-300x117.png 300w\" sizes=\"auto, (max-width: 357px) 100vw, 357px\" \/><\/figure><\/div>\n\n\n<h4 class=\"wp-block-heading\">Standardn\u00ed v\u00fdstup<\/h4>\n\n\n\n<p>Po stisknut\u00ed: \u201eV\u00fdstup do Excelu\u201c \u2013 \u201eStandardn\u00ed\u201c se soubor rovnou vygeneruje do pracovn\u00edho adres\u00e1\u0159e. N\u00e1zev odpov\u00edd\u00e1 n\u00e1zvu query.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Voliteln\u00e9 parametry<\/strong><\/h4>\n\n\n\n<p>Slou\u017e\u00ed pro jednor\u00e1zov\u00e9 pou\u017eit\u00ed &#8222;V\u00fdb\u011brov\u00e9ho krit\u00e9ria&#8220; p\u0159i spu\u0161t\u011bn\u00ed v\u00fdstupu.<\/p>\n\n\n\n<p>Pou\u017eit\u00ed:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>nap\u0159. chcete v\u00fdstup pouze za jedno st\u0159edisko<\/li>\n\n\n\n<li>ale nechcete toto omezen\u00ed trvale ukl\u00e1dat do query<\/li>\n<\/ul>\n\n\n\n<p>V tomto p\u0159\u00edpad\u011b filtr nezad\u00e1v\u00e1te do v\u00fdb\u011brov\u00e9ho krit\u00e9ria, ale nastav\u00edte ho pouze p\u0159i spu\u0161t\u011bn\u00ed v\u00fdstupu.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"984\" height=\"241\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-70.png\" alt=\"\" class=\"wp-image-12408\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-70.png 984w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-70-300x73.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-70-768x188.png 768w\" sizes=\"auto, (max-width: 984px) 100vw, 984px\" \/><\/figure><\/div>\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\">Query v modulu Personalistika<\/h2>\n\n\n\n<p>V modulu Personalistika se li\u0161\u00ed v\u00fdb\u011br \u00fadaj\u016f pro v\u00fdsledn\u00fd soubor oproti modulu Mzdy. D\u016fvodem je odli\u0161n\u00e1 struktura dat \u2013 modul Personalistika obsahuje jin\u00e9 \u00fadaje v kmenov\u00e9 v\u011bt\u011b ne\u017e modul Mzdy.<\/p>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">P\u0159id\u00e1v\u00e1n\u00ed soubor\u016f LSxxx\/PSxxx pomoc\u00ed tla\u010d\u00edtka &#8222;Soubor&#8220;<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"347\" height=\"453\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-61.png\" alt=\"\" class=\"wp-image-12397\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-61.png 347w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-61-230x300.png 230w\" sizes=\"auto, (max-width: 347px) 100vw, 347px\" \/><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Pokud pot\u0159ebujete pouze \u00fadaje ze z\u00e1kladn\u00edho souboru (LS001), nen\u00ed nutn\u00e9 tla\u010d\u00edtko \u201eSoubor\u201c pou\u017e\u00edvat.<\/li>\n\n\n\n<li>Pokud pot\u0159ebujete dal\u0161\u00ed \u00fadaje, je nutn\u00e9 je p\u0159idat p\u0159es tla\u010d\u00edtko \u201eSoubor\u201c.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Dostupn\u00e9 soubory k p\u0159id\u00e1n\u00ed<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>u\u017eivatelsk\u00e9 \u00fadaje (PS008)<\/li>\n\n\n\n<li>adresy (LS019)<\/li>\n\n\n\n<li>st\u0159ediska (LS040)<\/li>\n\n\n\n<li>stavy (STAVY)<\/li>\n\n\n\n<li>rodinn\u00ed p\u0159\u00edslu\u0161n\u00edci (LS004)<\/li>\n\n\n\n<li>zdravotn\u00ed prohl\u00eddky (PS060)<\/li>\n\n\n\n<li>\u0161kolen\u00ed (PS062)<\/li>\n\n\n\n<li>pl\u00e1n \u0161kolen\u00ed (PS078)<\/li>\n\n\n\n<li>pl\u00e1n prohl\u00eddek (PS178)<\/li>\n\n\n\n<li>vybaven\u00ed (PS163)<\/li>\n\n\n\n<li>systematizace (PS004)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Kombinace soubor\u016f<\/h3>\n\n\n\n<p>Kombinace m\u00e1 sv\u00e1 logick\u00e1 omezen\u00ed.<\/p>\n\n\n\n<p><strong>Lze kombinovat<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LS001 (z\u00e1kladn\u00ed soubor)<\/li>\n\n\n\n<li>PS008 (u\u017eivatelsk\u00e9 \u00fadaje)<\/li>\n\n\n\n<li>LS019 (adresy)<\/li>\n\n\n\n<li>LS040 (st\u0159ediska)<\/li>\n\n\n\n<li>STAVY<\/li>\n\n\n\n<li>PS004 (systematizace)<\/li>\n<\/ul>\n\n\n\n<p><strong>Nelze kombinovat:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LS004 (rodinn\u00ed p\u0159\u00edslu\u0161n\u00edci)<\/li>\n\n\n\n<li>PS060 (zdravotn\u00ed prohl\u00eddky)<\/li>\n\n\n\n<li>PS062 (\u0161kolen\u00ed)<\/li>\n\n\n\n<li>PS078 (pl\u00e1n \u0161kolen\u00ed)<\/li>\n\n\n\n<li>PS178 (pl\u00e1n prohl\u00eddek)<\/li>\n\n\n\n<li>PS163 (vybaven\u00ed)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Parametr \u201eHistorie\u201c<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"321\" height=\"410\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-62.png\" alt=\"\" class=\"wp-image-12398\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-62.png 321w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-62-235x300.png 235w\" sizes=\"auto, (max-width: 321px) 100vw, 321px\" \/><\/figure><\/div>\n\n\n<p>P\u0159i za\u0161krtnut\u00ed parametru \u201eHistorie\u201c:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>se zobrazuj\u00ed \u00fadaje historicky (po jednotliv\u00fdch obdob\u00edch)<\/li>\n\n\n\n<li>doch\u00e1z\u00ed k omezen\u00ed dostupn\u00fdch kombinac\u00ed<\/li>\n<\/ul>\n\n\n\n<p>Aktivn\u00ed z\u016fst\u00e1vaj\u00ed pouze:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>LS001 (z\u00e1kladn\u00ed soubor)<\/li>\n\n\n\n<li>PS008 (u\u017eivatelsk\u00e9 \u00fadaje)<\/li>\n\n\n\n<li>STAVY<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">\u00dadaj \u201eSTAVY\u201c \u2013 vysv\u011btlen\u00ed<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"587\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-63.png\" alt=\"\" class=\"wp-image-12399\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-63.png 411w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/image-63-210x300.png 210w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/figure><\/div>\n\n\n<h4 class=\"wp-block-heading\">Dny v m\u011bs\u00edci<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1 = osoba mimo eviden\u010dn\u00ed stav<\/li>\n\n\n\n<li>2 = osoba v eviden\u010dn\u00edm stavu<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Eviden\u010dn\u00ed stavy \u2013 p\u0159\u00edtomnost<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>0 = osoba nen\u00ed posledn\u00ed den v m\u011bs\u00edci v eviden\u010dn\u00edm stavu<\/li>\n\n\n\n<li>1 = osoba byla alespo\u0148 jeden den v m\u011bs\u00edci v eviden\u010dn\u00edm stavu<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Ostatn\u00ed pr\u00e1ce s query<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ostatn\u00ed pr\u00e1ce s query (v\u00fdb\u011br \u00fadaj\u016f, t\u0159\u00edd\u011bn\u00ed, v\u00fdb\u011brov\u00e1 krit\u00e9ria, v\u00fdstup) funguje stejn\u011b jako v modulu Mzdy.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\">P\u0159\u00edklad \u2013 vytvo\u0159en\u00ed query se mzdovou statistikou<\/h2>\n\n\n\n<p>P\u0159\u00edklad na vytvo\u0159en\u00ed mzdov\u00e9 statistiky najdete <a href=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/mzdova-statistika\/\" target=\"_blank\" rel=\"noopener noreferrer\">zde<\/a>. N\u00ed\u017ee navazujeme na ji\u017e vytvo\u0159enou mzdovou statistiku.<\/p>\n\n\n\n<p>C\u00edlem je vytvo\u0159it sestavu, kter\u00e1 bude obsahovat: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00fadaje z kmenov\u00e9ho souboru zam\u011bstnanc\u016f,<\/li>\n\n\n\n<li>z\u00e1rove\u0148 i \u00fadaje ze mzdov\u00e9 statistiky.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Postup<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>V okn\u011b \u201eDefinice query\u201c vyberte z\u00e1kladn\u00ed \u00fadaje zam\u011bstnance:\n<ul class=\"wp-block-list\">\n<li>v lev\u00e9 \u010d\u00e1sti vyhledejte po\u017eadovan\u00e9 \u00fadaje,<\/li>\n\n\n\n<li>p\u0159esu\u0148te je do prav\u00e9 \u010d\u00e1sti,<\/li>\n\n\n\n<li>p\u0159\u00edpadn\u011b upravte n\u00e1zvy ve sloupci \u201eText do hlavi\u010dky\u201c.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"926\" height=\"742\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query1.jpg\" alt=\"\" class=\"wp-image-1449\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query1.jpg 926w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query1-300x240.jpg 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query1-768x615.jpg 768w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/figure><\/div>\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Klikn\u011bte na tla\u010d\u00edtko \u201eSoubor\u201c\n<ul class=\"wp-block-list\">\n<li>vyberte LS722 \u2013 Mzdov\u00e1 statistika,<\/li>\n\n\n\n<li>zvolte konkr\u00e9tn\u00ed mzdovou statistiku.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>D\u00e1le:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>za\u0161krtn\u011bte <img loading=\"lazy\" decoding=\"async\" width=\"246\" height=\"24\" class=\"size-full wp-image-1451 alignnone\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query3.jpg\" alt=\"\"> (zajist\u00ed, \u017ee se zobraz\u00ed v\u0161ichni zam\u011bstnanci, i ti s nulovou hodnotou)<\/li>\n\n\n\n<li>Potvr\u010fte tla\u010d\u00edtkem OK<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"332\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query2.jpg\" alt=\"\" class=\"wp-image-1450\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query2.jpg 580w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query2-300x172.jpg 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/figure><\/div>\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Dopln\u011bn\u00ed \u00fadaj\u016f z p\u0159idan\u00e9 mzdov\u00e9 statistiky\n<ul class=\"wp-block-list\">\n<li>v lev\u00e9 \u010d\u00e1sti se nov\u011b zobraz\u00ed \u00fadaje ze souboru LS722<\/li>\n\n\n\n<li>tyto \u00fadaje najdete a\u017e na konci seznamu (je nutn\u00e9 sjet dol\u016f)<\/li>\n\n\n\n<li>vybran\u00e9 polo\u017eky p\u0159esu\u0148te do prav\u00e9 \u010d\u00e1sti<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"928\" height=\"742\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query4.jpg\" alt=\"\" class=\"wp-image-1452\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query4.jpg 928w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query4-300x240.jpg 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query4-768x614.jpg 768w\" sizes=\"auto, (max-width: 928px) 100vw, 928px\" \/><\/figure><\/div>\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Dokon\u010den\u00ed sestavy\n<ul class=\"wp-block-list\">\n<li>p\u0159\u00edpadn\u011b nastavte v\u00fdb\u011brov\u00e9 krit\u00e9rium<\/li>\n\n\n\n<li>potvr\u010fte tla\u010d\u00edtkem OK<\/li>\n\n\n\n<li>query se ulo\u017e\u00ed<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Vytvo\u0159en\u00ed v\u00fdstupu\n<ul class=\"wp-block-list\">\n<li>vyberte po\u017eadovan\u00e9 obdob\u00ed<\/li>\n\n\n\n<li>klikn\u011bte na \u201eV\u00fdstup do Excelu\u201c<\/li>\n\n\n\n<li>potvr\u010fte OK<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>V\u00fdstupn\u00ed soubor najdete v pracovn\u00edm adres\u00e1\u0159i.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"489\" height=\"217\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query5.jpg\" alt=\"\" class=\"wp-image-1453\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query5.jpg 489w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query5-300x133.jpg 300w\" sizes=\"auto, (max-width: 489px) 100vw, 489px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading has-text-align-center\">Kontrola dat<\/h3>\n\n\n\n<p>V n\u00e1vaznosti na pou\u017eitou mzdovou statistiku:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>lze vytvo\u0159it sou\u010dtov\u00fd \u0159\u00e1dek<\/li>\n\n\n\n<li>zkontrolovat sou\u010det (nap\u0159. celkovou hrubou mzdu)<\/li>\n\n\n\n<li>porovnat s jin\u00fdmi sestavami (nap\u0159. sou\u010dtov\u00e1 v\u00fdplatn\u00ed p\u00e1ska)<\/li>\n<\/ul>\n\n\n\n<p>Upozorn\u011bn\u00ed: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>N\u011bkter\u00e9 \u00fadaje jsou v\u017edy zapisov\u00e1ny na pracovn\u00ed pom\u011br 0.<\/li>\n\n\n\n<li>D\u016fsledek:\n<ul class=\"wp-block-list\">\n<li>pokud m\u00e1 zam\u011bstnanec v\u00edce pracovn\u00edch pom\u011br\u016f (nap\u0159. neaktivn\u00ed PP = 0 a aktivn\u00ed PP = 1), mohou se n\u011bkter\u00e9 hodnoty zobrazit na PP = 0<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Nejedn\u00e1 se o chybu, ale o zp\u016fsob z\u00e1pisu dat v syst\u00e9mu.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1544\" height=\"480\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7.jpg\" alt=\"\" class=\"wp-image-1454\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7.jpg 1544w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7-300x93.jpg 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7-1024x318.jpg 1024w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7-768x239.jpg 768w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2021\/05\/query7-1536x478.jpg 1536w\" sizes=\"auto, (max-width: 1544px) 100vw, 1544px\" \/><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>Query slou\u017e\u00ed k vytv\u00e1\u0159en\u00ed vlastn\u00edch p\u0159ehled\u016f a v\u00fdstupn\u00edch sestav dle konkr\u00e9tn\u00edch po\u017eadavk\u016f u\u017eivatele. Umo\u017e\u0148uj\u00ed kombinovat r\u016fzn\u00e9 \u00fadaje a p\u0159ipravit si v\u00fdstupy p\u0159esn\u011b podle pot\u0159eby. U\u017eivatelsk\u00e9 query se vytv\u00e1\u0159ej\u00ed a eviduj\u00ed samostatn\u011b pro modul Mzdy a samostatn\u011b pro modul Personalistika. Funkce: V\u00fdstupn\u00ed soubor: V obou modulech se vytvo\u0159en\u00fd v\u00fdstup ukl\u00e1d\u00e1 do pracovn\u00edho adres\u00e1\u0159e u\u017eivatele ve form\u00e1tu [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"template":"","format":"standard","meta":{"footnotes":""},"lsvr_kba_cat":[83,77],"lsvr_kba_tag":[168,270],"class_list":["post-993","lsvr_kba","type-lsvr_kba","status-publish","format-standard","hentry","lsvr_kba_cat-personalni-reporty","lsvr_kba_cat-uzivatelske-sestavy","lsvr_kba_tag-query","lsvr_kba_tag-query-se-mzdovou-statistikou"],"_links":{"self":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba\/993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba"}],"about":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/types\/lsvr_kba"}],"author":[{"embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":13,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba\/993\/revisions"}],"predecessor-version":[{"id":12520,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba\/993\/revisions\/12520"}],"wp:attachment":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/media?parent=993"}],"wp:term":[{"taxonomy":"lsvr_kba_cat","embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba_cat?post=993"},{"taxonomy":"lsvr_kba_tag","embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_kba_tag?post=993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}