Hello,
Rupert is correct that you need to use the Date Out and Transaction Date to pick up things that were in there. You don't have to use NULL with the Date Out because it stores 12/31/9999 as the date out for works that haven't moved. Both the Transaction Date and Date Out should come from Objects>Object Components>Location History in db config manage query groups. The example advanced query below picks up everything that was in the Herzfeld Study Center in 2011 including the subsites and things that moved in in 2010 and didn't move out until 2013.
Hope this helps!
Inline image 1

Stephanie Hansen 

Associate Registrar/Database Administrator

Milwaukee Art Museum 
700 N. Art Museum Dr.  |  Milwaukee, WI 53202 
Tel. 414.224.3273   |   Fax. 414.271.7588  |   [log in to unmask]




On Tue, Aug 23, 2016 at 3:28 AM, Shepherd, Rupert <[log in to unmask]> wrote:

Dear Christine

 

Well, I’m still learning my way around the system, but I think this sits in:

 

Objects à Object Components à Locations, where you will find Date Out.

 

Failing that, you could of course always circumvent advanced search and go straight to a Crystal Report which has the query criteria embedded within it.

 

Best wishes

 

Rupert

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]SI.EDU] On Behalf Of Christine Droll
Sent: 22 August 2016 14:24
To: [log in to unmask]
Subject: Re: Search Help

 

Thank you for this possible solution, Rupert.

 

In order to set up the Advanced Search, I am trying to find the field for Actual End Date in the Query Groups in the dbconfig, but to no avail. Can you bear with me a little more and point me in this direction?

 

Many thanks,

Christine

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]SI.EDU] On Behalf Of Shepherd, Rupert
Sent: Monday, August 22, 2016 3:54 AM
To: [log in to unmask]
Subject: Re: Search Help

 

I may be being obtuse here, but there’s also the Actual End Date field, over on the right of the Location History card of the Location & Movement form. So I think the logic you’re looking for would be:

 

Date <= [search date] and (Actual End Date > [search date] or Actual End Date is null)

 

(You need the null in case the object moved into that location and is still there.) The underlying field names should be ObjLocations.TransDate and ObjLocations.DateOut.


We’re trying to do something similar at the National Gallery: produce a series of collection statistics, including how many objects were on or off display, for any given date.

 

Best wishes

 

Rupert

 

 

Rupert Shepherd, PhD FSA

Collection Information Manager

[log in to unmask]uk

Tel: +44 (0)20 7747 5921

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]SI.EDU] On Behalf Of Christine Droll
Sent: 19 August 2016 22:43
To: [log in to unmask]
Subject: Re: Search Help

 

I, too, haven’t figured out a way to do this. Using the transaction date (>= and <=) only works if the location has been added or changed during that timeframe. It doesn’t capture the other times. So if I wanted to find out if this object was in the gallery in 2011 using >= 1/1/2011 and <= 12/31/2011, it wouldn’t find it, even though it was there.

 

 

 

Christine

 

Christine Droll

Registrar, Database & Collections

The Nelson-Atkins Museum of Art

4525 Oak Street | Kansas City, MO 64111

p 816.751.1333 | f 816.751.0499

[log in to unmask]

 

 

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]SI.EDU] On Behalf Of Lucille Stiger
Sent: Monday, August 15, 2016 3:05 PM
To: [log in to unmask]
Subject: Search Help

 

Hi Everyone,

 

I've been asked to provide a list of objects that were exhibited in a particular gallery in a given year. The location has multiple sub-sites attached with it, and the objects exhibited there are not necessarily associated with an exhibition because it is one of our permanent collection galleries.

 

Perhaps I have a case of "It's Monday and my Brain Hasn't Kicked In," but I've looked through the Advanced Queries and don't see anything that would apply.

 

We used to print out a Gallery Checklist every time something was added or removed, but we stopped doing this years ago. Perhaps we shouldn't have!

 

Best,

 

Lucille

Lucille Stiger
Registrar
Allen Memorial Art Museum
440.775.8668

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.

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.

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.