I'm making a mail list that contains both Household and Individual records. Development want to be able to sort the list alphabetically. But sorting by last name doesn't work because the first letter of household is somebody's first name . For example, the Steven and Liza Hanks Household will sort as "S" and not as "H."
I see that the constituent records have a "Sort Name" field. I tried running the list through and Output Set , but I can't find "Sort Name" as an option in Output Set Builder. Maybe it's right in front of me.
Any suggestions?
Steven Hanks: I see that the constituent records have a "Sort Name" field. I tried running the list through and Output Set , but I can't find "Sort Name" as an option in Output Set Builder. Maybe it's right in front of me. It doesn't appear to be available by default, but you could add it, e.g. open the system table TR_QUERY_ELEMENT, add a new row, give it a name in the description column, choose 'Constituent' for the category, enter "!.sort_name" (without the quotes) as the data select, enter "t_customer" as the data select, and save. From: Steven Hanks <bounce-stevenhanks7046@tessituranetwork.com> Sent: 8/24/2012 1:53:00 PMI'm making a mail list that contains both Household and Individual records. Development want to be able to sort the list alphabetically. But sorting by last name doesn't work because the first letter of household is somebody's first name . For example, the Steven and Liza Hanks Household will sort as "S" and not as "H." I see that the constituent records have a "Sort Name" field. I tried running the list through and Output Set , but I can't find "Sort Name" as an option in Output Set Builder. Maybe it's right in front of me. Any suggestions?--View this message online at http://www.tessituranetwork.com/Community/forums/p/7919/24822.aspx#24822 or reply to this message Steven Hanks Database AdministratorInformation Services The Tech Museum 201 South Market Street San Jose, CA 95113+1 (408) 795-6117 shanks@thetech.orgwww.thetech.org Visit: thetech.orgLike: facebook.com/TheTechMuseum Follow: twitter.com/#!/TheTechMuseum
Steven Hanks:
It doesn't appear to be available by default, but you could add it, e.g. open the system table TR_QUERY_ELEMENT, add a new row, give it a name in the description column, choose 'Constituent' for the category, enter "!.sort_name" (without the quotes) as the data select, enter "t_customer" as the data select, and save.
From: Steven Hanks <bounce-stevenhanks7046@tessituranetwork.com> Sent: 8/24/2012 1:53:00 PM
Visit: thetech.org
Like: facebook.com/TheTechMuseum
Follow: twitter.com/#!/TheTechMuseum