Subject: | |
From: | |
Reply To: | The Museum System (TMS) Users |
Date: | Mon, 5 Mar 2007 17:05:03 -0000 |
Content-Type: | multipart/alternative |
Parts/Attachments: |
|
|
Hi Lisa
I don't think there is.
However, if you or someone else is able to access the database directly,
the following bit of SQL should work:
select distinct
o.objectnumber
from
objects o, objcomponents oc, objlocations ol
where
o.objectid = oc.objectid
and oc.currentobjlocid = ol.objlocationid
and ol.locationid = -1
Jon
Tate
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Gaunt, Lisa
Sent: 05 March 2007 15:36
To: [log in to unmask]
Subject: searching for records with no current location
Could anyone tell me if there is an easy way to search for
records that have no current location recorded?
Lisa Gaunt
Documentation Manager
Bolton Museums, Art Gallery & Aquarium
Le Mans Crescent
Bolton BL1 1SE
01204 332173
www.boltonmuseums.org.uk <http://www.boltonmuseums.org.uk>
This e-mail and any attached files are confidential and may also
be legally privileged. They are intended solely for the intended
addressee. If you are not the addressee please e-mail it back to the
sender and then immediately, permanently delete it. Do not read, print,
re-transmit, store or act in reliance on it. This e-mail may be
monitored by Bolton MBC in accordance with current regulations.
This footnote also confirms that this e-mail message has been
swept for the presence of computer viruses currently known to the
Council. However, the recipient is responsible for virus-checking before
opening this message and any attachment.
Unless expressly stated to the contrary, any views expressed in
this message are those of the individual sender and may not necessarily
reflect the views of Bolton MBC.
http://www.bolton.gov.uk
|
|
|