V pozadavky (view)
Z Prirucky
v_pozadavky (view) je zákaznické view pro zobrazení požadavků zaměstnance.
Definice
create view v_pozadavky as select workfl_hl.id_poz, workfl_hl.os_cislo, workfl_hl.typ, pracovnici.prijmeni, pracovnici.jmeno, workfl_body.datum_od, workfl_body.datum_do,
workfl_proc.poradi, workfl_proc.stav, workfl_proc.datum, workfl_proc.cas, workfl_proc.zapsal, workfl_hl.url_odkaz
from workfl_hl, pracovnici, workfl_body, workfl_proc where workfl_hl.os_cislo = pracovnici.os_cislo and workfl_hl.id_poz = workfl_body.id_poz and workfl_hl.id_poz = workfl_proc.id_poz and
workfl_proc.poradi = (select max(poradi) from workfl_proc b where b.id_poz = workfl_proc.id_poz)