Sounds like something we'd be interested in! Jared Case Head of Collection Information, Research, and Access Motion Picture Department George Eastman House 585-271-3361, ext. 334 The Nitrate Picture Show - May 1-3, 2015 at the Dryden Theatre, George Eastman House http://eastmanhouse.org/nitratepictureshow/The_Nitrate_Picture_Show.php On Tue, Dec 16, 2014 at 2:58 PM, Danielle Uchitelle < [log in to unmask]> wrote: > > 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 <http://www.facebook.com/thewarholmuseum> | warhol: > twitter <http://www.twitter.com/thewarholmuseum> > > > > > > > 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. > 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.