Changes between Version 4 and Version 5 of AdvancedReports

Timestamp:

12/13/24 17:56:29 (5 weeks ago)

Author:

211228

Comment:

--

AdvancedReports

@@ -67 +67 @@
 
 
+{{{
+SELECT 
+(
+         SELECT COUNT(*) 
+     FROM RoomRequest 
+     WHERE status = 'Pending'
+) AS br_studenti_koi_pobarale_soba_i_cekaat_odgovor,
+(
+     SELECT COUNT(*) 
+     FROM Room 
+     WHERE is_available = TRUE AND capacity > 0
+) AS brojka_na_slobodni_sobi_posle_prviot_den
+}}}
+