I’m trying to write a report showing contacts email address
In the module tree you can select Email Addresses but no fields show
How can I fix this?
I am using version 7.7.8
Hi
would the query at the end of this blog post be sufficient for your needs?
https://pgorod.github.io/How-Emails-Stored/
You have to change “users” to “contacts” but it should get the job done.
Thanks
I know how email addresses are stored but the report writer is not showing them for People
My suggestion was to use the query instead of the report, but I guess that doesn’t fit your needs.
As far as the possible bug is concerned, normally the next step would be for you to attempt reproducing it in the online demo to see if it is there in the latest version, and to rule out the possibility that this is only happening in your system.
user: will
pass: will
Testing now 
It’s weir works if I login as admin so I’m suspecting it’s an issue with roles
It is a bug
Logged in as will on 7.9.4
Same problem
Only works if you log in as admin
Good news: there an open issue with this, and suggests a workaround:
https://github.com/salesagility/SuiteCRM/issues/3420
Please add your voice there, say you have the same problem, and whether the fix works for you. Thanks
1 Like
Thanks for that
Works like a dream
1 Like
Hello,
I resume this post cause I’m having the same issue. There’s no email address field in the report when I’m trying to make one from contacts module. I tried the fix but it still does not work.
Is there another workaround?
PS: I attach a screenshot of the issue