Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

12/13/24 18:10:22 (5 weeks ago)

Author:

211228

Comment:

--

AdvancedReports

@@ -81 +81 @@
         FROM RoomRequest rr 
         WHERE rr.status = 'Pending' 
-        AND rr.block_id = b.block_id
+        AND rr.block_id = b.block_id AND rr.requested_time = (SELECT MIN(requested_time) from RoomRequest)
     ) AS br_studenti_koi_pobarale_soba_i_cekaat_odgovor
 FROM