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]