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]<mailto:[log in to unmask]>  |  202.633.8554


[cid:image001.png@01D8D720.6DB826A0]

[Inline image 2]<https://www.facebook.com/npg.smithsonian/>  [Inline image 3] <https://twitter.com/NPG>   [Inline image 4] <https://www.instagram.com/smithsoniannpg/>   [Inline image 5] <https://www.youtube.com/user/NatlPortraitGallery>

npg.si.edu<http://npg.si.edu/>

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<http://www.jmberlin.de/dauerausstellung>

**** FÜR KINDER / FOR CHILDREN ****
ANOHA - Die Kinderwelt des Jüdischen Museums Berlin
www.anoha.de<http://www.anoha.de>

To unsubscribe, send an email to [log in to unmask]<mailto:[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.