projects
/
civicrm-scripts.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(from parent 1:
6dd9355
)
we want to selct donations >= $120.00
author
Andrew Engelbrecht
<andrew@fsf.org>
Fri, 19 May 2023 16:14:01 +0000
(12:14 -0400)
committer
Andrew Engelbrecht
<andrew@fsf.org>
Fri, 19 May 2023 16:14:01 +0000
(12:14 -0400)
board-forum-contacts.sql
patch
|
blob
|
blame
|
history
diff --git
a/board-forum-contacts.sql
b/board-forum-contacts.sql
index 98079d2133bad101cd356565c3300ce50b930058..cff379808a379bb064112781fedc8d63c32719a7 100644
(file)
--- a/
board-forum-contacts.sql
+++ b/
board-forum-contacts.sql
@@
-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
)
)
)