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 (Jm attaching a screen dump of what he did for me in the List Designer part of TMS.  Programs $B"* (JTMS $B"* (JList 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 (Jt 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 (Jnot equal to $B!I (J criteria but have not had any luck.

I am trying to find object records that have the credit line  $B!H (JPurchase. $B!I (J and I wanted to exclude records that had any additional words in that field (ie.  $B!H (JCollection Grunwald Center for the Graphic Arts.  Purchase. $B!I (J

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]