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
415 750 7604<tel:+14157507604>
[log in to unmask]<mailto:[log in to unmask]>
https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.famsf.org%2F&data=05%7C01%7Ctmsusers%40si-listserv.si.edu%7Cf1a7234bf674421b530908da390db3eb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637885028262795907%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=a5ingEOVqYlWirO%2FmSkW%2F51SvtSWjq%2BCRhU0w9PoHYs%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.famsf.org%2F&data=05%7C01%7Ctmsusers%40si-listserv.si.edu%7Cf1a7234bf674421b530908da390db3eb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637885028262795907%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=wHFPwzzYBHu7BFeLyIrkzg9SF7EBmpEfEIZSYxTN608%3D&reserved=0>
pronouns: he/they
On Wed, May 18, 2022 at 1:24 PM Anna Goss <[log in to unmask]<mailto:[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]<mailto:[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.