External Email - Exercise Caution

Hi Anna, I don't know how to do it in the TMS search but I was able to use the following SQL Query:

select * from Objects
where ObjectID in (
select ObjectID
from ObjComponents
group by ObjectID
having count(*) > 1
)



Christian Martin
Collections Information Specialist

Fine Arts Museums of San Francisco
de Young \ Legion of Honor


pronouns: he/they


On Wed, May 18, 2022 at 1:24 PM Anna Goss <[log in to unmask]> wrote:

External Email - Exercise Caution

Hello all,
I am trying to find all the object records in TMS at my institution that have additional components (such that the little red star appears by department). We unfortunately have had some inconsistent naming conventions used for components, and having exhausted those I don't know how to find the records with components that don't fit those conventions. Does anyone have any advice on how to conduct such a search in TMS? Is it even possible to run a search to find objects with components (that doesn't just return all the records in the object table)?
Thanks in advance,
Anna

Registrar | Stark Museum of Art & The W.H. Stark House
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.