I second this motion!!! My workaround is to create object packages, one of them being the term I do not want (but making it equal to) and then subtracting that package from the larger selection. It's gotten a lot easier now that Package Explorer has the A - B option. It is a hassle, especially if there are a lot of objects, but I can usually get it to work. Christine Droll Registrar, Database and Collections The Nelson-Atkins Museum of Art 4525 Oak Street Kansas City, MO 64111 T: 816-751-1333 F: 816-751-0499 [log in to unmask] From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Garton, Susan Sent: Thursday, June 1, 2017 7:54 AM To: [log in to unmask] Subject: Re: Searching for Thes terms This has always been a nuisance for us at the Smithsonian National Portrait Gallery, but we get around it using object packages...as long as the number of objects involved isn't too big. I do understand why "not equal to" doesn't work for thes terms: like any other field with multiple values, TMS is considering other terms in the same object that are (or may be) "equal to" the term in in question. I think? Anyway, I do think the "not equal to" functionality in TMS would be very valuable! [cid:image001.png@01D16E4E.942FCC80]<http://npg.si.edu/> Sue Garton Data Administrator and Acting Head of Collections Information & Research Archive Smithsonian National Portrait Gallery [log in to unmask]<mailto:[log in to unmask]> | 202.633.8554 From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jon Thristan Sent: Thursday, June 01, 2017 5:43 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: Searching for Thes terms Hi Rhondda I checked on this issue and it's not possible to exclude Thesaurus Terms using the 'not equal to' operator. Since it's possible to search using 'equals to' operator, it is an obvious assumption to think that searching using 'not equals to' operator would also be possible. I thought the same! This has been a known issue for a while. It's not a priority for addressing in the next version of TMS, but it would be useful to know how valuable this is considered to be, to input into the assessment of development and bug-fix priorities. Best wishes Jon Jon Thristan MBCS | Project Consultant [log in to unmask]<mailto:[log in to unmask]> | +44 20 7993 8402 GallerySystems | www.gallerysystems.com<http://www.gallerysystems.com/> ---- [cilogo_60] Join us in L.A. this December for Collective Imagination 2017 The International TMS Users Conference Workshops: December 4 - 5, 2017 Conference: December 6 - 8, 2017 Get more details here<http://www.gallerysystems.com/ci-2017/>. From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Rhondda Orchard Sent: 29 May 2017 06:49 To: [log in to unmask]<mailto:[log in to unmask]> Subject: Searching for Thes terms Hello TMS users, I am creating an Advanced Query that searchers for a Term from the thesaurus that does not match "book". When I run the query changing the Relation to Equal to it works as expected. Is there a reason my search is incompatible ? Am I missing something ? We're running TMS2010. Thanks Rhondda [cid:image003.jpg@01D2DAAF.CD497100] [cid:image004.jpg@01D2DAAF.CD497100] Rhondda Orchard Managing Registrar Australian National Maritime Museum Darling Harbour Wharf 7, 58 Pirrama Rd, Pyrmont NSW 2009 +61292983736 www.anmm.gov.au<http://www.anmm.gov.au> [Image removed by sender.]<http://www.anmm.gov.au/pompeii> Join: eNewsletter<http://anmm.us3.list-manage2.com/subscribe?u=068dd7e7a243d9d1c1d267220&id=7df72491fc> Download: Digital Signals<http://www.anmm.gov.au/signalsapp> [cid:image006.png@01D2DAAF.CD497100][Image removed by sender. social media logos] ********************************************************************************* This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited and may incur severe penalties. If you have received this transmission in error, please notify us immediately by telephone on 02 9298 3777 and delete all copies of this transmission together with any attachments. To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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]<mailto:[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.