Hi Grace,
I, too, am SQL-challenged, but our specialist
in applications and web systems is a whiz at it. I’m attaching a screen dump
of what he did for me in the List Designer part of TMS. Programs→TMS→List
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’t 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 “not
equal to” criteria but have not had any luck.
I am
trying to find
object records
that have the credit line “Purchase.”
and I
wanted to exclude records that had any additional words in that field (ie.
“
Thank you for any suggestions you may
have!
--Grace
Grace Murakami,
Associate Registrar
Tel. 310-443-7071; Fax. 310-443-7079