Customer Email Marketing Report yielding 0 records
Hello All,
I'm, not sure if comments posted in Users > Shared Resources get distributed to anyone (?) and so I'm asking here.
I found this recent report template that among other things generates a list of those customers that have provided us with email addresses. That's exactly what I need... in fact it could be simpler. Unfortunately this template does not yield any records when run on our system.
I assume from the submission date that this report works with the 1.7.1 database but I'm wondering if we've done something in our implementation of the default email address function such that this report doesn't pick up the email addresses. I previously modified our 1.7 code and recompiled in accordance with the code change in Jira-1520 "When a new customer is created, add an email contact as well as a phone and location contact".
I'm wondering if there is an email tag generated that was called one thing in the code, and another in the SQL query. If so, it doesn't jump out at me. Can someone suggest a SQL query fix for the report or recommend another report template that will provide a email addresses, either as a printed report or for export?
Thanks,
Sam Longiaru
Kamloops, Canada
Re: Customer Email Marketing Report yielding 0 records
Sam - have a look at the last post in http://www.openvpms.org/forum/generating-active-client-period-list - grab that and have a play.
Regards, Tim G