We primarily use the household account email address for emails. However, we know that there are number of records with A1 or A2 has an email address, but the household primary email address is blank. We would like to update the household email address. I am pretty sure that process will be manual.
I have been trying to build a custom view in SQL or a even a list or extraction in Tessitura to locate the records where there is no household email, but either A! and/or A2 has email address. I have not found the solution. I can find the households with no email, but I have unable to find a way to find the A!/A2 with email a dresses.
Any suggestions would be appreciated.
We have a view that labels the customer_no as A1,A2,HH,I etc... You could use that to filter on T_EADDRESS. You could also simple use cust_type in T_CUSTOMER to get just HH and then join to T_EADDRESS for a null condition. Does that help?
The view you created sounds interesting. Would you be willing to share that?
I am thinking if I can find the table where A1 and A2 I could then use those as a filter.
I sent it your way
Troy,
I know this post was a long time ago, however is there any chance you can send this my way as well?
Ashley
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org