Output set with Last Name NOT Household name

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!

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!