Find a contact's email address in the database

Hello. I'm trying to do some queries on the database for some external reporting. The contacts table does not contain an email address column. There is however an email_addresses table. Though I don't see anything that links these email addresses back up with anything from the contact table.

0 Patrick McQueen over 4 years ago

Hi Jared,
I find it helpful to see email addresses as it's own module with relationships, not as a field in modules.
SELECT * FROM email_addr_bean_rel WHERE bean_module = "Contacts";
This query will give you the relationships between Contacts and email address.
WHERE bean_id = '<contacts.id>' can get you the specific relationship(s).
I hope this helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel