Changes between Version 16 and Version 17 of ImportantUseCase3

Timestamp:

12/14/22 22:11:21 (2 years ago)

Author:

201057

Comment:

--

ImportantUseCase3

@@ -33 +33 @@
 join potrosuvac p on p.lokacija_id = l.lokacija_id
 join naracka n on n.potrosuvac_id = p.korisnik_id
-where lower(n.status) = 'spremna' or lower(n.status) = 'спремна'
+where (n.dostavuvac_id = 6) and 
+(lower(n.status) = 'spremna' or lower(n.status) = 'спремна')
 }}}
+''земени е пример ID вредност''
 
 === Чекор 5 ===