Thank you Jeri and Christine-that was very, very helpful! ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jeri Moxley Sent: Monday, December 04, 2006 11:09 AM To: [log in to unmask] Subject: Re: Searching Question OH - forgot that credit line wasn't in the default listview. Here's our sql from List Designer for a listview that gives the set of standard checklist fields (we use a mail merge template with the ListView Excel export to create a Word document to pass label copy to publications staff): -Jeri CREATE VIEW dbo.vListViewObjects AS SELECT O.ObjectID AS ID, O.ObjectNumber, O.SortNumber, D.Mnemonic, CL.Classification, OC.Culture, OC.Period, C.DisplayName, C.AlphaSort, O.ObjectName, OT.Title, O.Dated, SUBSTRING(O.Medium, 1, 255) AS Medium, SUBSTRING(O.Dimensions, 1, 255) AS Dimensions, SUBSTRING(O.Description, 1, 255) AS Description, CONVERT(varchar(1000), O.Edition) AS edition, CONVERT(varchar(1000), O.CreditLine) AS creditline FROM dbo.Objects O INNER JOIN dbo.Departments D ON O.DepartmentID = D.DepartmentID INNER JOIN dbo.vListViewClassifications CL ON O.ClassificationID = CL.ClassificationID INNER JOIN dbo.ObjContext OC ON O.ObjectID = OC.ObjectID LEFT OUTER JOIN dbo.ConXrefs CX ON O.ObjectID = CX.ID AND CX.TableID = 108 AND CX.RoleTypeID = 1 AND CX.Displayed = 1 AND CX.DisplayOrder = 1 LEFT OUTER JOIN dbo.Constituents C ON CX.ConstituentID = C.ConstituentID LEFT OUTER JOIN dbo.ObjTitles OT ON O.ObjectID = OT.ObjectID AND OT.Displayed = 1 AND OT.DisplayOrder = 1 ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll Sent: Monday, December 04, 2006 1:40 PM To: [log in to unmask] Subject: Re: Searching Question Hi Grace, I, too, am SQL-challenged, but our specialist in applications and web systems is a whiz at it. I $B!G (Bm attaching a screen dump of what he did for me in the List Designer part of TMS. Programs $B"* (BTMS $B"* (BList Designer. It also has the current location as well as credit line. He modified the Objects Original view, but for some reason, he had to give it a new Database View (hence the vListViewKyle) (His name is Kyle). Hope this helps. Christine Christine Droll | Collections Database Administrator | The Nelson-Atkins Museum of Art | Kansas City, MO tel: 816.751.1333 | fax: 816.561.0499 ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Grace Murakami Sent: Monday, December 04, 2006 12:25 PM To: [log in to unmask] Subject: Re: Searching Question Hi Jeri, Thanks for the suggestions-I am SQL-challenged and would like to learn more about how to use it, including how to phrase searches. In the meantime, I had actually thought of using the list view, but I can $B!G (Bt find Credit Line as an option in the List View Designer. Is there a way to add it? Thanks again! --Grace ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jeri Moxley Sent: Monday, December 04, 2006 10:12 AM To: [log in to unmask] Subject: Re: Searching Question Hi Grace, I don't think you can successfully use Advanced Query to ask for records that have only a specific word and nothing else in Credit Line. You'd need a 'match whole field' search. You could do this in SQL, or I'd search TMS for Credit Line = Purchase* and then sort by Credit Line in the List View to grab the appropriate set into an object package. Best, Jeri ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Grace Murakami Sent: Monday, December 04, 2006 1:11 PM To: [log in to unmask] Subject: Searching Question Hello again, Thank you to all who replied to my question about images in PDF. I was able to use the print-to-file function and the thumbnails now look much better. I was wondering if anyone has had luck in Advanced Query with searching for records that do not contain a particular word or words. I have tried using the $B!H (Bnot equal to $B!I (B criteria but have not had any luck. I am trying to find object records that have the credit line $B!H (BPurchase. $B!I (B and I wanted to exclude records that had any additional words in that field (ie. $B!H (BCollection Grunwald Center for the Graphic Arts. Purchase. $B!I (B Thank you for any suggestions you may have! --Grace Grace Murakami, Associate Registrar Hammer Museum 10899 Wilshire Blvd. Los Angeles, CA 90024 Tel. 310-443-7071; Fax. 310-443-7079 [log in to unmask]