Changes between Version 19 and Version 20 of AdvancedReports

Timestamp:

03/10/22 18:54:09 (3 years ago)

Author:

191151

Comment:

--

AdvancedReports

@@ -269 +269 @@
 
 {{{#!sql
--- Status 1 - vo dogovor
--- Status 2 - dogovoreni
--- Status 3 - otkazano
-
 with tempTable as (select 
-        oc.offer_id,
-        count(oc.offer_id) as num_of_comments
+        oc.offer_id,
+        count(oc.offer_id) as num_of_comments
 from offer_comments oc 
 join offers as o on o.id = oc.offer_id and 
-                                        o.status = 2
+        o.status = 'COMPLETED'
 group by oc.offer_id)
 select 
-         avg(t.num_of_comments) 
+         avg(t.num_of_comments) 
 from tempTable as t
 }}}