External Email - Exercise Caution
Hi Anna –
For unique searches like this where there are limits to the Advanced Query capabilities, I often create a new Listview that is able to display the related info I am looking for so I can stay within the TMS application to quickly review
and address my data.
In this case, my new listview would show the total count of related components and then a concatenated list of the component names (maintain the 1:1 correlation). Then I’d sort that list by Count, and add those 2+ to an Object Package,
if necessary. Having a Listview allows for continuous monitoring and security so only certain users have access to it. You can even program columns to compare the data for you so you can quickly spot those that don’t match your data standards.
Hope this helps!
Cornelius Marr
JWSC LLC - Art Catalogues, Technology, and Research
212 South Marion Street, Suite 10 Oak Park, IL 60302
(708) 445-9101
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Christian Martin
Sent: Wednesday, May 18, 2022 3:33 PM
To: [log in to unmask]
Subject: Re: Searching for Objects with Components
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: