• Replies 1 reply
  • Subscribers 359 subscribers
  • Views 118 views
  • Users 0 members are here
Related

Output set with Last Name NOT Household name

Diana Hodgins
$organization

How do I pull a list that will give me a list sorted by the Last Name of A1, not the Household name. I need to alphabetize a list by last name not the household name. What happens now is when sorting alphabetically it's using the first name of Name 1 in the Household. Any help would be GREAT.

I tried not using Household as criteria in my List Manger as well as my output set but the Household name continues to come up as the Last Name.

Diana at Wells Fargo Center for the Arts

 

  • $organization

    Hi Diana

     

    Using the sort_name field in T_CUSTOMER should do the trick. The default format for this field in v11 is lname1/fname1  this means the Households will get the A1 individual and Orgs will be the Org name. For example, Smith/John for individuals and Households and ACME Industries for Orgs

     

    If you are interested, the formatting of this field is defined in TR_SALUTATION_FORMAT. Of course if you change this now it won’t change the format for accounts where it has already been applied.

     

    I quickly did this element up and tried it and it works for me.

     

    Description         Customer_Sortname

    Category              Constituent

    Data_select        !.sort_name

    Data_from          t_customer

    Data_where       empty

    Control_group  [apply one if necessary]

    Single_row         checked

    Primary_group_default                unchecked

     

    Cheers

    Sandra

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Diana Hodgins
    Sent: Tuesday, 25 September 2012 4:27 AM
    To: Sandra Ashby
    Subject: [Tessitura Next Generation Forum] Output set with Last Name NOT Household name

     

    How do I pull a list that will give me a list sorted by the Last Name of A1, not the Household name. I need to alphabetize a list by last name not the household name. What happens now is when sorting alphabetically it's using the first name of Name 1 in the Household. Any help would be GREAT.

    I tried not using Household as criteria in my List Manger as well as my output set but the Household name continues to come up as the Last Name.

    Diana at Wells Fargo Center for the Arts

     




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!