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:
Valdeva Ives <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Wed, 26 Jul 2006 17:25:34 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (29 lines)
Hi everyone,

We are new to TMS in general and have some query questions.

Does anyone know if there is a way to search for data that isn't there
via TMS (not using SQL queries from the back end)?
Some questions that have been asked are:

1.  How do you search for a list of objects that have no media attached
to them?
2.  How do you find all of the objects that don't have a specific type
of constituent attached?  (eg.  objects with no donor)

I can generate these queries from SQL but it would be nice if the
non-technical staff could do it for themselves.  Is the only option to
use a list view or report?

Thanks in advance for any help!
Dee Dee

--
Valdeva Ives
Application Developer and Support Specialist
Digital Information and Technology
Harvard University Art Museums
32 Quincy Street
Cambridge, MA 02138
617.384.9389

ATOM RSS1 RSS2