TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Szlezak Katharina (K1)" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 22 Jul 2011 08:41:28 +0200
Content-Type:
text/plain
Parts/Attachments:
text/plain (88 lines)
Many thanks,

Best,
Katharina Szlezak


MMag. Katharina Szlezak

TMS-Administratorin
Provenienzforschung
Landhausgalerie Ausstellungsbrücke

Abteilung Kunst und Kultur
Amt der NÖ Landesregierung
Landhausplatz 1
A-3109 St. Pölten
T 0043-2742-9005-15916
F 0043-2742-9005-13029
E [log in to unmask]


-----Ursprüngliche Nachricht-----
Von: The Museum System (TMS) Users [mailto:[log in to unmask]] Im Auftrag von Angela Steinmetz
Gesendet: Freitag, 15. Juli 2011 15:23
An: [log in to unmask]
Betreff: Re: Searching for Objects with no location entered

I have a saved Advanced search that finds all records with site location not equal to any of our existing site locations.  

Angela Steinmetz | Head Registrar | Smart Museum of Art | University of Chicago | 773.702.0175 office

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Szlezak Katharina (K1)
Sent: Friday, July 15, 2011 4:43 AM
To: [log in to unmask]
Subject: Searching for Objects with no location entered

Hello,

I hope someone can help with that: To move all objects in our database which have no location entered yet to their actual location, I tried to run a query by LocationID = -1, but the Advanced Query Assistant told that it cannot run such a query. Does anyone know how to filter all objects where it says something like "no location entered" in the location display field in the standard data entry (all objects where upon creation no location has been entered)?

Thanks a lot for your help!

Cheers,
Katharina Szlezak


MMag. Katharina Szlezak

TMS-Administratorin
Provenienzforschung
Landhausgalerie Ausstellungsbrücke

Abteilung Kunst und Kultur
Amt der NÖ Landesregierung
Landhausplatz 1
A-3109 St. Pölten
T 0043-2742-9005-15916
F 0043-2742-9005-13029
E [log in to unmask]

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.

ATOM RSS1 RSS2