Thanks :) I was trying the RenditionNumber field which is probably why it wasn't working since it does an inner join. On 7/26/2006 6:21 PM, Jeri Moxley wrote: >Hi Dee Dee, > >These searches are possible through the interface, though you may need >to add a field or two to the query configuration. For both of these, >you'll rely on the "Not Equal to" feature in Advanced Query. > >1. Objects with no Media attached: >Because it's the one field I've found that seems to work reliably for >this search, I most commonly use an Objects module advanced query search >of: >LoginID (MediaXrefs) <not equal to> * >The asterisk acts as a wildcard - so, in effect, the query is "Media >Xref LoginID not equal to anything". Note that, in my experience, the >Rendition Number field doesn't return results with this query - I don't >know why. > >2. Objects with no donor: >This one's trickier. If you search for "Role not equal to Donor", you >may very well get some records with Donors in your results because the >search returns any record for which it is true that there is a >constituent who is not a Donor (for example, we have a few records with >both a 'Donor' and a 'Contributor' (contributed funds) under >acquisition-related constituents). >So - the trick is to first search for all records with Role = Donor and >make an object package of those records. Then, go to advanced query and >search for all objects where "Object Package Name is not equal to XXX >(the name of your saved package of objects with donors)". From that >point, you can narrow the search further. Of course, object packages are >not dynamic, so you have to update the object package each time you run >the query. > >Good luck! > >Best, >Jeri > >-------------- >Jeri L. Rojas-Moxley >TMS Specialist >Solomon R. Guggenheim Museum >212-423-3509 >[log in to unmask] > > >-----Original Message----- >From: The Museum System (TMS) Users [mailto:[log in to unmask]] >On Behalf Of Valdeva Ives >Sent: Wednesday, July 26, 2006 5:26 PM >To: [log in to unmask] >Subject: Searching question > >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 > > -- Valdeva Ives Application Developer and Support Specialist Digital Information and Technology Harvard University Art Museums 32 Quincy Street Cambridge, MA 02138 617.384.9389