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 (B
Thank you for any
suggestions you may have!
--Grace
Grace Murakami,
Associate Registrar
Tel.
310-443-7071; Fax. 310-443-7079