Zmiany pomiędzy wersją 28 and wersją 29 dla UserGuide/AdvancedConfiguration/CreatingTemplates

Data i czas:

10/02/12 22:19:44 (12 years temu)

Autor:

JP (IP: 89.78.227.245)

Komentarz:

--

UserGuide/AdvancedConfiguration/CreatingTemplates

@@ -179 +179 @@
 WHERE d.doc_id = 905
 
+-- Kwerenda pobiera zadania ze sprawy 
+SELECT 'OPIS' AS opis, 'START' AS start, 'KONIEC' AS koniec, 'CZAS TRWANIA' AS czas
+UNION
+SELECT dscrpt, to_char(start_, 'YYYY-MM-DD HH:MI') AS start, 
+to_char(end___, 'YYYY-MM-DD HH:MI') AS end, 
+((end___ - start_)::interval)::text AS duration FRom events_view WHERE prc_id IS NULL
+ORDER BY czas DESC
 
 }}}