How does Sugar record email addresses in V5.0.0f and what joins are needed to produce an SQL report...?
As an example of our confusion, we have a contact that shows only one email address (which is correct). But when we run a Zuckerreport it prints a different address.
In the MySQL Contact table the incorrect address is displayed
in the Sugar Contact record the correct addess is displayed
There is another MySQL table called email_addresses and both these addresses appear in this table.
I am assuming that because there is a 1-many relationship between a contact and their email addresses these are held in a table outside of the contact table. Presumably the email_addresses table.
But how are these joined?
Why is there an email1 field in the contact table and how does it get populated?
Thanks in advance for anyones attention.


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks