We have a report that identifies volumes with no copies attached if that helps - it uses the Call Number/Volume data source and filters by:
Is Deleted (equals f) Owning Library (In list) Copies > Is Deleted (equals f) Copies > Copy ID (is NULL) Terran McCanna, PINES Program Manager ------------------------------ Georgia Public Library Service | University System of Georgia 2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341 (404) 235-7138 | tmcca...@georgialibraries.org http://help.georgialibraries.org | h...@help.georgialibraries.org <https://www.facebook.com/georgialibraries> <https://www.twitter.com/georgialibs> Join our email list <http://georgialibraries.org> for stories of Georgia libraries making an impact in our communities. On Wed, Oct 23, 2019 at 6:26 PM Mary Llewellyn <mllew...@biblio.org> wrote: > I use SQL to identify records like that. My query is something like this: > > select bre.id > from biblio.record_entry bre > where bre.deleted = 'f' > and bre.id not in > (select bre.id > from biblio.record_entry bre, asset.call_number acn > where acn.record = bre.id > and acn.deleted = 'f' > and bre.deleted = 'f') > > My SQL syntax skills are kind of rudimentary. I'm sure someone else can > write something more elegant. This one is looking for biblio.record ids > that are not associated with undeleted call numbers and bibs > > Maybe this example will give insight on tables and parameters to use in a > report. > > Mary > > > On Wed, Oct 23, 2019 at 10:44 AM Marguerite Grant < > margueritegr...@rodgerslibrary.org> wrote: > >> We have been trying to identify active (not deleted) records that have no >> active (not deleted) items. I haven't had any success creating a report. >> >> Is there a canned report to do this and if not, perhaps someone can send >> me some insight as to what tables and parameters I should be using. >> >> Thanks very much for any help you can give me. >> >> Marguerite Grant >> >> --- >> >> Rodgers Memorial Library >> >> Hudson, NH >> > > > -- > Mary Llewellyn > Database Manager > Bibliomation, Inc. > 24 Wooster Ave. > Waterbury, CT 06708 > mllew...@biblio.org >