we want to selct donations >= $120.00
authorAndrew Engelbrecht <andrew@fsf.org>
Fri, 19 May 2023 16:14:01 +0000 (12:14 -0400)
committerAndrew Engelbrecht <andrew@fsf.org>
Fri, 19 May 2023 16:14:01 +0000 (12:14 -0400)
board-forum-contacts.sql

index 98079d2133bad101cd356565c3300ce50b930058..cff379808a379bb064112781fedc8d63c32719a7 100644 (file)
@@ -24,7 +24,7 @@ and c.id not in (
                 select contact_id from civicrm_contribution
                 where contribution_status_id = 1 and receive_date >= '2018-01-19' and receive_date <= '2022-10-19'
                 group by contact_id
-                having sum(total_amount) > '120.00' -- donated $120 or more during time period
+                having sum(total_amount) >= '120.00' -- donated $120 or more during time period
             )
         )
     )