That was an important set of data when we converted to TMS, and the thing
that pulls all of those records together is that the location was created
on the date that the conversion was run. In order to find them, I do an
Advanced Query for Current Location with Transaction Date = the date the
conversion was run. You can see when the record was created in the Record
Info area. (We are still on TMS 2012.) Here is a screenshot:

[image: image.png]

I hope this is helpful. --Suzanne

Suzanne Voce Stephens
Senior Associate Registrar
TMS Database Administrator

Birmingham Museum of Art
2000 Rev. Abraham Woods Jr. Blvd.
Birmingham, Alabama 35203

Phone 205.254.2975
Fax 205.323.6093


On Mon, Sep 17, 2018 at 1:12 PM Mathieu, Marie Élaine <
[log in to unmask]> wrote:

> Dear TMS users,
>
> When we migrated our data to TMS, some of our objects had no location and
> in TMS the Home Location field remained empty. We would like to search for
> these records.
>
>
>
>
> [image: cid:image002.png@01D44A8B.A26ABA00]
> I tried many requests with the Advanced Query assistant, but I must do
> something wrong since the result is always incorrect. And it seems we
> cannot search empty records with the Query Assistant.
>
>
> Any ideas? Maybe with a SQL request?
>
> Thank you,
>
> Marie-Élaine
>
>
>
>
>
>
>
>
>
>
>
> [image: 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>
> [image: Google Maps]
> <https://mapsengine.google.com/map/viewer?mid=zIyJ1odA15Zs.kcPuns8EA06k>  [image:
> Facebook] <https://www.facebook.com/mcqorg>  [image: Twitter]
> <https://twitter.com/mcqorg>  [image: Flickr]
> <http://www.flickr.com/photos/museedelacivilisation/>  [image: Youtube]
> <http://www.youtube.com/mcqpromo>
>
>
> <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] 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.