Hi everyone,
We're working on addressing v11 issues in our stored procedures, and I have a question regarding the use of the FT_GET_EADDRESS function. The Preparing Customizations for Tessitura Version 11 document indicates that this function can be used in place of calls to T_EADDRESS to ensure an email address is returned for affiliates, such as A1 and A2 on a household.
However, when I test out this function on an A1 or A2 affiliate to a household where the affiliate has no email address, but the household does, it returns no data. Here is a specific example: Household ID 425453 has two affiliates. A1 = 2959141 and A2 = 2959142. The household has two active email addresses on file.
This statement against the household record returns a single row with an email address, as expected:
select * from FT_GET_EADDRESS (GETDATE(), null, null, null, 425453)
However, using the A1 affiliate - 2959141 - it returns no results.
Did I misunderstand the intended use of this function or do we perhaps have the wrong version of FT_GET_EADDRESS in our v11 test environment?
Thanks,David
Hi Anna,
The problem is there isn't an email on the household. The only emails are on the affiliated accounts.
We will try the 11.0.3 patch as well.
Thanks
Jackie
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Anna Wessely Sent: Thursday, July 05, 2012 4:39 PM To: Guy, Jackie Subject: RE: [Tessitura Technical Forum] Question regarding FT_GET_EADDRESS
Jackie,
You should be getting the household email address in the results. I have not been able to re-create this issue on my system. If I have an email address on the household I am getting the email address in the results. I just did a simple selection where constituent 12 is a household:
select b.address
FromT_CUSTOMER a
CROSS APPLY [dbo].ft_get_eaddress(GETDATE(), null, null, null, a.customer_no) b
where a.customer_no = 12
If using this simple sample code you are not able to get the household email address then I would put in a help ticket on TASK as you should get the household in the results. That being said, there were some changes to this procedure in the 11.0.3 patch so if you have not patched yet you may see slightly different results.
Best,
Anna
From: Jackie Guy <bounce-jacquelineguy8869@tessituranetwork.com> Sent: 7/5/2012 3:33:23 PM
While you are looking at this procedure, we are having the opposite issue. In our environment, the orders are on the household and emails generally live with the affiliated individuals. The email addresses are marked primary, but when we use the household ID with the FT_GET_EADDRESS function no eaddress is returned. It appears the inheritance is flowing down from household to affiliated accountss, but does not roll up from affiliated individuals to the household. Was this the intended behavior? If so, can you make any recommendations? At this point our only thought is to make a custom function.
Jackie Guy
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Sorry, I misunderstood. So, no, the inheritance does not go both ways mainly because it would be difficult to pick one email address for the household from the many primary affiliates. I would say at this point if you find it is happening a lot that you want to address an email to the household using an individual's email address, then I would create a custom function or have a process to replicate the individual's email addresses on the household.
If you're pulling a list and using an output set, could you pull the individuals (looking at households for the ticket/order data) so that you get your individual accounts with email addresses? Then when you have more than one affiliated individual with a primary email address, you would get both returned if their household matched your list criteria.