Changes between Version 16 and Version 17 of AdvancedReports

Timestamp:

05/04/24 14:33:22 (8 weeks ago)

Author:

216049

Comment:

--

AdvancedReports

@@ -70 +70 @@
   {{{#!sql
 
-select distinct l.li_id, l.li_ime, count(v.vozenje_id)
+select distinct l.li_id, l.li_ime, l.li_pravec,  count(v.vozenje_id)
 from linija l
 left join instancanalinija inl on inl.li_id = l.li_id
 left join vozenje v on v.inl_id = inl.inl_id and v.vozenje_start between date_trunc('year', now()) 
 and date_trunc('month', date_trunc('year', now())+ interval '7 months')
-group by l.li_id, l.li_ime
+group by l.li_id, l.li_ime, l.li_pravec 
+order by li_ime
 
   }}}