Need to add feature: Email all registrants
Bug #378022 reported by
dcalkins
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Bot Event |
New
|
Undecided
|
Unassigned | ||
Bug Description
I tried to do a SQL queriy myself, but couldn't figure out where team email was stored...
Thanks!
Revision history for this message
| Kevin Hjelden (fryguy) wrote Re: [Bug 378022] [NEW] Need to add feature: Email all registrants | #1 |
To post a comment you must log in.
the team email is the email of the team 'captain', so you need to join
the tables. Should be something like:
select person.name, person.email
from team
left join person on person.id = team.captain
If you want it for only the registered teams, then that's a slightly
more advanced query.