If you want to specifically generate a list from entering in SQL
formatted queries in TMS you can do this with the Alert Queue feature
new to TMS 2010 R2. In this instance you could create an alert
"Objects without a current location" and put in the below SQL. This
is just an option I want people to be aware of since it is new
functionality.
Thanks
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Smith, Jeffrey
Sent: Friday, June 17, 2011 8:56 AM
To: [log in to unmask]
Subject: Re: no current location recorded
There's also the quick SQL query:
select objects.objectnumber from objects
inner join objcomponents on objects.objectid = objcomponents.objectid
where objcomponents.currentobjlocid = -1
If the SQL tab of TMS Advanced Query could be further developed so that
SA's could enter SQL commands like this, tricker queries would be much
easier! No updates or inserts though, mind you...
Cheers
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Hansen, Stephanie
Sent: Thursday, June 16, 2011 5:56 PM
To: [log in to unmask]
Subject: Re: no current location recorded
Just an fyi to anyone else that was interested in this-I just stumbled
upon a previous post from Jeri Moxley and she used current location
login id<>*. That came up with a more accurate result for me because I
thought everything had a site, but it doesn't.
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Hansen, Stephanie
Sent: Thursday, June 16, 2011 4:26 PM
To: [log in to unmask]
Subject: Re: no current location recorded
Hey, Thanks for the tips
I went into db config manage tables/columns and unchecked the display as
distinct list for the current location site. I was afraid that it would
also remove this inquery assistant (because most users need a distinct
list), but it kept it in the query assistant and just changed it in the
advanced query. Perfect!
Stephanie Hansen
Rights & Reproductions / Database Administrator
Milwaukee Art Museum
700 N. Art Museum Dr. | Milwaukee, WI 53202
Tel. 414.224.3268 | Fax. 414.271.7588 | [log in to unmask]
More at www.mam.org <http://www.mam.org/>
Kids 12 and under are FREE
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Danalakis, Katherine
Sent: Thursday, June 16, 2011 4:23 PM
To: [log in to unmask]
Subject: Re: no current location recorded
We are actually trying to figure out the exact same thing without
success.
Brian, I can't do a search for "not equal to *" because it makes you
choose from a drop-down of current locations.
We are also using TMS2010 R2. I don't remember if it was possible on
9.35.
Would love to hear if anyone else has figured this out.
Thanks!
Katherine
Katherine Danalakis
Collections Manager
The Jewish Museum
1109 5th Avenue at 92nd Street
New York, NY 10128
212.423.3281
[log in to unmask]
www.thejewishmuseum.org/collections
________________________________
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Brian Kraft
Sent: Thursday, June 16, 2011 5:13 PM
To: [log in to unmask]
Subject: Re: no current location recorded
Hi Stephanie,
We recently cleaned these up in TMS.
This worked for us:
Advanced Search - Current Location - Site or Subsite not equal to *
Hope you get the results you are looking for.
Brian
On Thu, Jun 16, 2011 at 4:08 PM, Stephanie Hansen <
[log in to unmask]> wrote:
Hello TMSers,
We're wondering if there's a simple way to look up objects with no
current location recorded. (We're using TMS 2010 R2).
Thanks in advance!
Stephanie Hansen
Milwaukee Art Museum
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.
--
Brian M. Kraft
Head of Registration
Minneapolis Institute of Arts
2400 Third Avenue South
Minneapolis, MN 55404
tel: 612.870.3122
fax: 612. 870.3121
[log in to unmask]
www.artsmia.org <http://www.artsmia.org/>
www.artsconnected.org <http://www.artsconnected.org/>
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.
This communication (including any attachments) is intended for the use
of the
intended recipient(s) only and may contain information that is
confidential,
privileged or legally protected. Any unauthorized use or dissemination
of this
communication is strictly prohibited. If you have received this
communication
in error, please immediately notify the sender by return e-mail message
and
delete all copies of the original communication. Thank you for your
cooperation.
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.
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.