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?
We are having the same issue – in our system we have “Program Listing Sort Name.” But it could have been a custom output set criteria. Sorry if that wasn’t much help.
Marie
--
Marie Kocher | Development Assistant
Kansas City Ballet
Todd Bolender Center for Dance and Creativity
500 W. Pershing Road, Kansas City, MO 64108
816-931-2232 x 1382 | 816-931-1172 (fax)
Buy tickets and enroll for classes: www.kcballet.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Steven Hanks Sent: Friday, August 24, 2012 2:01 PM To: Marie Kocher Subject: [Tessitura Development Forum] Alpha sorting Household and Individual
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!
Unknown said: 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.
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:
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