Hi Iris,
Sorry for the late response – hope this might still be helpful. In Crystal, I use the select below to filter on
current exhibitions. Hope it might give you some ideas.
Best,
Sue
CurrentDate<CDate({vgsrpExhibitionsS_RO.EndISODate}) and
CurrentDate>CDate({vgsrpExhibitionsS_RO.BeginISODate})
Susan Garton
Collections Information Officer
Smithsonian
National Portrait Gallery
[log in to unmask] | 202.633.8554
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Blochel-Dittrich, Iris
Sent: Sunday, September 25, 2022 10:28 AM
To: ListServ tmsusers <[log in to unmask]>
Subject: Prioritizing exhibition information
External Email - Exercise Caution
Dear colleagues,
we have listviews, dataviews and reports in the object module of TMS collections where exhibition specific information has to be included. It’s not always possible to go from the exhibition module as registrars and conservators will build
object packages and work from there. As objects can have relations to many exhibitions I am wondering what might be the best way to define a primary exhibition. Has anyone ever worked eg with a combination of exhobjstatus and exhibition date?
Best regards
Iris Blochel-Dittrich
museum documentation
Stiftung Jüdisches Museum Berlin
Lindenstrasse 9-14
10969 - Berlin
Tel. : +49 30 25993-442
Fax. : +49 30 25933-409
**** Die neue Dauerausstellung ****
Jüdische Geschichte und Gegenwart in Deutschland
www.jmberlin.de/dauerausstellung
**** FÜR KINDER / FOR CHILDREN ****
ANOHA – Die Kinderwelt des Jüdischen Museums Berlin
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.