Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

02/03/24 21:59:48 (8 months ago)

Author:

201171

Comment:

--

AdvancedReports

@@ -3 +3 @@
 === Извештај за сите продукти како и нивното име кои се доставени во последните 3 месеци
 {{{
-select 
-count(order_table.order_id),
-product.product_name
+select
+    count(order_table.order_id),
+    product.product_name
 from order_table
-left join order_table_contains_product on order_table_contains_product.order_id = order_table.order_id
-left join product on product.product_id  = order_table_contains_product.product_id
+    left join order_table_contains_product on order_table_contains_product.order_id = order_table.order_id
+    left join product on product.product_id  = order_table_contains_product.product_id
 where order_table.order_status = 'Delivered' 
-and order_table.order_date between  now() - interval '3 months' and now()
+    and order_table.order_date between  now() - interval '3 months' and now()
 group by product.product_name
 }}}