Hi Kate Collen, formally Diggle! I hope you had a fantastic and memorable wedding celebration and honeymoon. I look forward to catching up with you at one of our many committee meetings . . . Best, Laura Laura Coyle Collection Manager NMAAHC 202.633.0249 [log in to unmask] From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Collen, Kate Sent: Thursday, November 04, 2010 1:50 PM To: [log in to unmask] Subject: Re: Boolean searching Hi Amber, To my knowledge, you can't search on "not" within the Query Assistant. TMS reads "not" as an additional search value and will bring up anything in the search field containing both the word "not" plus the word you are searching on. I agree that the Advanced Query can be scary for the average TMS user. What I do is create an advanced query for my users, and then save it under the "Saved Queries" section. This allows them to pull up and run more complicated queries. They simply select the name I've saved it under in the Saved Queries box, and TMS immediately populates the fields above. They hit Execute and it's done. Sometimes I even login as them to create the query so they're able to identify their login name next to the name of the query. One bugaboo I have noticed is that TMS automatically checks the checkbox "Include Virtual Objects" whether you have saved the query with the "Accessioned objects only" box checked or not. Just ask your users to make sure the correct box is checked prior to executing the query. Here's a screenshot below. Good luck! [cid:image001.jpg@01CB7CC9.712AC450] Kate Kate Collen (formerly Diggle) Collections Database Administrator Smithsonian National Postal Museum 202.633.5512 [log in to unmask] www.postalmuseum.si.edu www.arago.si.edu From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Morgan, Amber Sent: Thursday, November 04, 2010 10:39 AM To: [log in to unmask] Subject: Boolean searching Sorry if this is kind of a dumb question, but does anyone know if it's possible to use the operator "NOT" in free text searching? I know you can use Advanced Query for this, but some of our users are intimidated by advanced query and wanted to know if they could use "NOT" in Query Assistant. I tried it out and it doesn't seem to be an option, and I'm not finding it in the manual. the warhol: Amber E. Morgan Associate Registrar 117 Sandusky Street Pittsburgh, PA 15212 T 412.237.8306 F 412.237.8340 E [log in to unmask] W www.warhol.org<http://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 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.