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')
Position Available: Automation Services Librarian
The Pioneer Library System (PLS) is a cooperative library system located in
Canandaigua, NY and serves 42 small and rural public libraries across Ontario,
Wyoming, Wayne, and Livingston Counties. We are currently looking for a
detailed oriented
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
I'd like to learn about the experiences of academic libraries that are using
Evergreen in a college or university setting. What are the pros and cons of
Evergreen in your environment? Are you using something for managing reserves
collections, and if so what? Do you use Evergreen to share
The link for today's stream is at:
https://zoom.us/j/768782544?pwd=czZMczlRQXlha0lGM2RTaWFaRXhJdz09
The stream will start around 8:30.
Thanks,
-Anna
Anna Goben
Evergreen Indiana Coordinator
Indiana State Library
140 N. Senate Ave.
Indianapolis, IN 46204
Telephone: 317-234-6624
Fax:
