Hi Marie-Élaine;
Try adding File Date from Media XRefs: Media: Display Media Renditions: Media Files to your Objects MediaXrefs query group; at first glance, this worked for me.
[cid:image013.jpg@01D480F1.C252FFC0]
Brad Hubley
Entomology Collection Manager
Natural History - Entomology
Royal Ontario Museum
100 Queen's Park
TORONTO ON M5S 2C6
CANADA
Phone: 1-416-586-5674
Email: [log in to unmask]<mailto:[log in to unmask]>
www.rom.on.ca
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Mathieu, Marie-Élaine
Sent: November 20, 2018 3:48 PM
To: [log in to unmask]
Subject: Advanced Query - Media File Date in Object Query
Dear TMS users,
I'm trying to set up a search in the Advanced Query of the Objects Module, but I can't find how to do it.
I am looking for all the files of the Objects Module which have a Media with a "File Date" (from the Media Module) from a specific year (example: 2018).
[cid:image003.jpg@01D480F1.3CE066C0]
I can perform this search from the Media Module Advanced Query. But, for example, for 2018 we might have 10 000 medias, which are linked to 3 000 files in the Object Modules. I want to have access to these 3 000 files.
But I can't drop the "File Date" field in the Object Advanced Research Mode.
[cid:image004.jpg@01D480F1.3CE066C0]
Any ideas?
Thank you,
Marie-Élaine
[Musées de la civilisation]<https://www.mcq.org/fr/?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=logo>
Marie-Élaine Mathieu - T. 418 643-2158, poste 825
Bibliotechnicienne
Direction des collections
MUSÉE DE LA CIVILISATION
9, rue de la Vieille-Université, Québec (QC) G1R 5K1 Canada
mcq<https://www.mcq.org/fr/?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte>.<https://www.mcq.org/fr/?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte>org<https://www.mcq.org/fr/?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> [Google Maps] <https://mapsengine.google.com/map/viewer?mid=zIyJ1odA15Zs.kcPuns8EA06k> [Facebook] <https://www.facebook.com/mcqorg> [Twitter] <https://twitter.com/mcqorg> [Flickr] <http://www.flickr.com/photos/museedelacivilisation/> [Youtube] <http://www.youtube.com/mcqpromo>
[cid:image012.png@01D480F1.3CE066C0]<https://www.mcq.org/fr/exposition?id=483407&utm_medium=courriel&utm_source=mcq&utm_campaign=IciLondres>
Avis : Ce message est confidentiel et ne s'adresse qu'aux destinataires. Si vous le recevez par erreur, veuillez le supprimer et nous en aviser.
Politique de confidentialité<https://www.mcq.org/fr/politique-de-confidentialite?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> | Se<https://www.mcq.org/fr/emarketing/desabonnement?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> <https://www.mcq.org/fr/emarketing/desabonnement?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> désabonner<https://www.mcq.org/fr/emarketing/desabonnement?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> | Inscription à l'INFO-MUSÉE<https://www.mcq.org/fr/info-musee>
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.
ON NOW
Spiders: Fear & Fascination<https://www.rom.on.ca/spiders>
COMING SOON
1 December | Wildlife Photographer of the Year<http://www.rom.on.ca/wpy>
15 December | Zuul: Life of an Armoured Dinosaur<http://www.rom.on.ca/zuul>
________________________________
À L'AFFICHE
Les araignées : Peur et fascination<https://www.rom.on.ca/fr/araignees>
À VENIR
1 décembre | Wildlife Photographer of the Year<http://www.rom.on.ca/fr/photographe-naturaliste>
15 décembre | Zuul: Life of an Armoured Dinosaur<http://www.rom.on.ca/fr/zuul>
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.