Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

01/05/24 13:02:39 (6 months ago)

Author:

216049

Comment:

--

AdvancedReports

@@ -19 +19 @@
 select li_ime_given as li_ime, interval_1h , broj_pati
 from(
-select li_ime as li_ime_given, interval_1h , count(li_ime||'-'||interval_1h) broj_pati
-from(
-select *, 
-(to_char(extract (hour from vozenje_start), '00') || ':00 -' || to_char(extract (hour from (vozenje_start + '1 hours'::interval))::int, '00') || ':00') as interval_1h
-from project.linija li 
-left join project.instancanalinija inl on li.li_id = inl.li_id 
-left join project.vozenje v on inl.inl_id = v.inl_id 
+        select li_ime as li_ime_given, interval_1h , count(li_ime||'-'||interval_1h) broj_pati
+        from(
+                select *, 
+                (to_char(extract (hour from vozenje_start), '00') || ':00 -' || to_char(extract (hour from (vozenje_start + '1 hours'::interval))::int, '00') || ':00') as interval_1h
+                from project.linija li 
+                left join project.instancanalinija inl on li.li_id = inl.li_id 
+                left join project.vozenje v on inl.inl_id = v.inl_id 
+        )
+        group by li_ime, interval_1h 
+        order by li_ime, interval_1h
 )
-group by li_ime, interval_1h 
-order by li_ime, interval_1h
+where broj_pati = (
+        select max(broj_pati)
+        from(
+                select li_ime, interval_1h , count(li_ime||'-'||interval_1h) broj_pati
+                from(
+                        select *, 
+                        (to_char(extract (hour from vozenje_start), '00') || ':00 -' || to_char(extract (hour from (vozenje_start + '1 hours'::interval))::int, '00') || ':00') as interval_1h
+                        from project.linija li 
+                        left join project.instancanalinija inl on li.li_id = inl.li_id 
+                        left join project.vozenje v on inl.inl_id = v.inl_id 
+                        where li_ime = li_ime_given
+                )
+                group by li_ime, interval_1h 
+                order by li_ime, interval_1h 
+        )
+        group by li_ime
 )
-where broj_pati = (select max(broj_pati)
-from
-(select li_ime, interval_1h , count(li_ime||'-'||interval_1h) broj_pati
-from(
-select *, 
-(to_char(extract (hour from vozenje_start), '00') || ':00 -' || to_char(extract (hour from (vozenje_start + '1 hours'::interval))::int, '00') || ':00') as interval_1h
-from project.linija li 
-left join project.instancanalinija inl on li.li_id = inl.li_id 
-left join project.vozenje v on inl.inl_id = v.inl_id 
-where li_ime = li_ime_given
-)
-group by li_ime, interval_1h 
-order by li_ime, interval_1h )
-group by li_ime)