• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 45 views
  • Users 0 members are here
Related

Sort Name

Marty Jones
$organization

Anybody know the logic behind creating the value Sort name in t_customer? Tried finding a function that is building it but don't see it. Since that column is only 55 characters, trying to figure out how many from the fname and how many from the lname.

Thanks,

Marty

  • $organization

    Looks like it's all in AP_BUILD_SAL, based on rules from TR_SALUTATION_FORMAT. It does use a "@max_length = 55" for the sort_name.

  • $organization

    Thanks Chris! This works.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Monday, February 04, 2013 3:40 PM
    To: Martin Jones
    Subject: Re: [Tessitura Technical Forum] Sort Name

     

    Looks like it's all in AP_BUILD_SAL, based on rules from TR_SALUTATION_FORMAT. It does use a "@max_length = 55" for the sort_name.

    From: Marty Jones <bounce-martyjones3217@tessituranetwork.com>
    Sent: 2/4/2013 4:03:47 PM

    Anybody know the logic behind creating the value Sort name in t_customer? Tried finding a function that is building it but don't see it. Since that column is only 55 characters, trying to figure out how many from the fname and how many from the lname.

    Thanks,

    Marty




    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!