TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Content-Type:
multipart/mixed; boundary="_002_9E7CDEDA0873B241915B4C1AFB4643E20452302780exchange_"
Date:
Tue, 14 May 2013 08:15:30 -0500
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
From:
Christine Droll <[log in to unmask]>
Message-ID:
<9E7CDEDA0873B241915B4C1AFB4643E20452302780@exchange>
In-Reply-To:
MIME-Version:
1.0
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Parts/Attachments:
text/plain (2289 bytes) , Capture.JPG (45 kB)
Noel,

Because you want a constituents list, you'll need to run the advanced query in the Constituents module, based on an Object package.

So first create an object package with the objects for which you want the artists names.  Then from the Constitutents module, run the Object Related Constituent Xref against the package name.  (see image)

Christine

Christine Droll
Collections Database Administrator
The Nelson-Atkins Museum of Art
4525 Oak Street
Kansas City, MO  64111-1873
T: 816-751-1333
F: 816-751-0499
[log in to unmask]




-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Noel Valentin
Sent: Tuesday, May 14, 2013 7:59 AM
To: [log in to unmask]
Subject: Searching for Artists in Collection from Constituents module

Hello TMS Users,

Yesterday, I was (naively?) hoping that I could execute a simple Advanced Query search from the Constituents module of all the artists represented in the collection.  Low and behold I couldn't do it.

We enter information on borrowed objects, and their associated constituents, in TMS.  Thus many of the Object-related Constituents with the Role of 'Artist' do not relate to the permanent collection.  I don't want these artist/constituents included in my search.

I tried adding the Object Status field from the Objects module, where 'accessioned object' is one of the values you can select from, into the Constituents or Object-related Constituents query group configured for the Constituents module, but was not allowed to do so.

Anyway, has anyone executed a Constituents module search to retrieve artists represented in the collection, and, if so, how did you do it?

Thanks.

Noel

Noel Valentin
El Museo del Barrio
1230 Fifth Avenue
New York, NY. 10029
www.elmuseo.org

[log in to unmask]
Voice: 212 660 7120
Fax: 212 831 7927
Mobile: 917 601 1065

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.


ATOM RSS1 RSS2