Changes between Version 19 and Version 20 of Напредни извештаи од базата

Timestamp:

02/13/22 14:20:04 (3 years ago)

Author:

186102

Comment:

--

Напредни извештаи од базата

@@ -15 +15 @@
 join project.store as str on pr.store_name = str.store_name
 join project.delivery as dlv on dlv.delivery_id = o.delivery_id
-where now() - interval '3 months' <= dlv."date"
+where now() - interval '3 months' <= dlv."date" and dlv.status='Delivered'
 ) as t1,
 (
@@ -29 +29 @@
 join project.store as str on pr.store_name = str.store_name
 join project.delivery as dlv on dlv.delivery_id = o.delivery_id
-where now() - interval '3 months' <= dlv."date"
+where now() - interval '3 months' <= dlv."date" and dlv.status='Delivered'
 ) as t2
 }}}