Chad’s is a good interim approach, but it would be useful to have a title sort field in the Objects module, analogous to the Alpha Sort field in Constituents, which is both automatically created and editable.  We’ve added this to the enhancement list for the next TMS release.

 

Danielle

 

---

Danielle Uchitelle | Managing Director

[log in to unmask] | 646.733.2239 x264

GallerySystems | www.gallerysystems.com

 

 

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Monday, December 15, 2014 3:31 PM
To: [log in to unmask]
Subject: Re: Alpha sort for titles starting with "The"?

 

You could use some snazzy SQL to help with that:

CASE WHEN Title LIKE 'The %' THEN SUBSTRING(Title,5,LEN(Title))+', The' ELSE Title END AS TitleSort

Add this as a separate field, and include in list views and report. Is reports, you would use it in the sorting formulas and in list views you would place it after the title, hide it, and set the title to sort by the next field.

Chad Petrovay | Project Manager

[log in to unmask] | 646.733.2239 x252

GallerySystems | www.gallerysystems.com

 

 

On Mon, Dec 15, 2014 at 2:09 PM, Morgan, Amber <[log in to unmask]> wrote:

Just wondering how others are handling data entry for titles that begin with the word “the.”  Our curators dislike how including “The” at the beginning interferes with alpha sort.  But the idea of entering the titles inverted seems absurd to me.  For example, a film called “The Chelsea Girls” will alpha sort under the letter T.  Is there a way to get it to sort under the letter C without changing the title to “Chelsea Girls, The”?  The only thing that comes to mind is creating a separate title type for alpha sort, sort of like the alpha sort field in constituents.  But in order for it to work, we’d have to enter an alpha sort field for everything and build reports and views that display that field rather than the primary title.  I’m sure that would work but we just don’t have time to do that kind of data entry.  Anyone have any clever tricks for this? 

Thanks,
Amber

 

the warhol:
Amber E. Morgan
Collections Manager
117 Sandusky Street
Pittsburgh, PA 15212
T 412.237.8306
F 412.237.8340
E [log in to unmask]
W www.warhol.org

The Andy Warhol Museum
One of the four Carnegie Museums of Pittsburgh

Email newsletter http://members.carnegiemuseums.org/email  
Membership http://members.carnegiemuseums.org/SupportCMP  

warhol: facebook | warhol: twitter

 

The information contained in this message and/or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Any views expressed in this message are those of the individual sender.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.