• Replies 2 replies
  • Subscribers 338 subscribers
  • Views 84 views
  • Users 0 members are here
Related

Extraction Output Phone Issue

Karen Sterkowicz
$organization

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

Parents
  • $organization

    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   

Reply
  • $organization

    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   

Children