Question regarding FT_GET_EADDRESS

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