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
