{"id":1040,"date":"2020-05-23T23:40:12","date_gmt":"2020-05-23T21:40:12","guid":{"rendered":"http:\/\/skolarbbos.net\/?p=1040"},"modified":"2020-05-29T14:33:46","modified_gmt":"2020-05-29T12:33:46","slug":"parametarski-upiti","status":"publish","type":"post","link":"https:\/\/skolarbbos.net\/?p=1040","title":{"rendered":"Parametarski upiti"},"content":{"rendered":"<p>Svi primeri upita do sada obja\u0161njeni bili su kriterijumski upiti. Me\u0111utim, postoje i parametarski upiti. Oni su op\u0161tiji od kriterijumskih. Npr. prikazan je upit koji vra\u0107a sve u\u010denike iz Rap\u010de. \u0160ta bi se desilo ukoliko bi bili potrebni upiti koji vra\u0107aju u\u010denike iz svakog pojedina\u010dnog mesta, a recimo da u \u0161koli postoje u\u010denicici koji dolaze iz cele Gore? Tada bi za svako mesto bio potreban po jedan upit. To je trenutak kada je potrebno iskoristiti funkcionalnosti parametarskih upita. Ovo zna\u010di da se kreira jedan upit koji kao ulazni parametar prima odre\u0111enu vrednost i na osnovu te vrednosti prilago\u0111ava i vra\u0107a rezultat. Ulazni parametar na osnovu kojeg treba dobiti u\u010denike iz \u017eeljenog mesta je upravo naziv mesta. Na slici 1\u00a0prikazan je prozor Query Design i na\u010din kreiranja opisanog parametarskog upita.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1041\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/parametarskiupit411.jpg\" alt=\"parametarskiupit411\" width=\"419\" height=\"366\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/parametarskiupit411.jpg 419w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/parametarskiupit411-300x262.jpg 300w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><br \/>\n<em>Slika\u00a01<\/em><\/p>\n<p>Sa prethodne slike (Slika 1) vidi se da upit prikazuje ime i prezime u;enika, dok je naziv mesta sakriven (opcija <strong>Show<\/strong> je isklju\u010dena). Za vrednost kriterijuma pi\u0161e u uglastim zagrada Unesi naziv mesta. <strong>Uglaste zagrade ozna\u010davaju da se radi o ulaznom parametru.<\/strong> Kada se ovaj upit pozove klikom na Run, otvara se prozor prikazan na slede\u0107oj slici (Slika 2).<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1042\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/parametarskiupit412.jpg\" alt=\"parametarskiupit412\" width=\"259\" height=\"129\" \/><br \/>\n<em>Slika\u00a02<\/em><\/p>\n<p>Vidi se da ono \u0161to je upisano u okviru kriterijuma (criteria) predstavlja neku formu pitanja ili obja\u0161njenja krajnjem korisniku, kako bi znao \u0161ta se od njega tra\u017ei da upi\u0161e u okviru polja za unos vrednosti. Kada se u ovo polje unese \u017eeljeno mesto i klikne na dugme ok, dobija se tra\u017eeni rezultat.<\/p>\n<p><video controls=\"controls\" width=\"606\" height=\"340\"><source src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2018\/05\/28.-Sortiranje-upita.-Parametarski-upit.mp4\" type=\"video\/mp4\" \/><\/video><\/p>\n","protected":false},"excerpt":{"rendered":"Svi primeri upita do sada obja\u0161njeni bili su kriterijumski upiti. Me\u0111utim, postoje<a class=\"moretag\" href=\"https:\/\/skolarbbos.net\/?p=1040\"> &lt;b&gt;[Nastavi sa \u010ditanjem...]&lt;\/b&gt;<\/a>","protected":false},"author":1,"featured_media":1002,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1040","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-access"],"_links":{"self":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/1040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1040"}],"version-history":[{"count":3,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/1040\/revisions"}],"predecessor-version":[{"id":1474,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/1040\/revisions\/1474"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/media\/1002"}],"wp:attachment":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}