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 [log in to unmask]<mailto:[log in to unmask]> https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.jwscllc.com%2F&data=05%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C61b0b11a1aac471bd95c08da39afdb18%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637885725133572436%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9tcRBnQ9TT1I9MEwaEhGS9jlXbDaXpBhP5VUbLABGaI%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.jwscllc.com%2F&data=05%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C61b0b11a1aac471bd95c08da39afdb18%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637885725133572436%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9tcRBnQ9TT1I9MEwaEhGS9jlXbDaXpBhP5VUbLABGaI%3D&reserved=0> 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 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%7C61b0b11a1aac471bd95c08da39afdb18%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637885725133572436%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=EzaXz1q2siHNz7lDItB20r7WKNd4Q8Fk42%2BM%2B4pfloU%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%7C61b0b11a1aac471bd95c08da39afdb18%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637885725133572436%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=2Y3Bhe%2FnkFhLTaAjTThe6I%2BGkneD1SlAKO4LfULWLWk%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]<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.