After searching the forums 7 documentation, I need some help figuring out how to change the output of an extraction to show Phone 1 and Phone 2 from the primary address.
Even when I use a custom output set saying phone 1 and phone 2 I get the standard extraction results of phone 1 = business phone from the other phone numbers (which is usually blank) and phone 2 = phone 1 of the primary address. I'm pretty sure that at some point over the years I heard someone say that you can make an alteration to get this to work differently.
Does anyone know how to do this?
Karen
You have to modify LP_GET_PHONES and specify the phone types you want for each. Something like
Select @day_phone = ' ', @eve_phone = ' ' If @eve_phone = ' ' select @eve_phone = isnull(phone,' ') from t_phone where customer_no = @customer_no and address_no = @address_no and type = 2 If @day_phone = ' ' select @day_phone = isnull(phone,' ') from t_phone where customer_no = @customer_no and address_no = @address_no and type = 1
Thanks Amanda. I'll give it a try.