Thank
you Jeri and Christine—that was very, very helpful!
From:
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:
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 |
tel: 816.751.1333 |
fax: 816.561.0499
From:
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:
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:
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
(
Thank you for any suggestions you may
have!
--Grace
Tel. 310-443-7071; Fax. 310-443-7079