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]
|