RE: All Items Withdrawn

[Eric Rhee <erhee at chulavista dot lib dot ca dot us>]

Hi Aaron - The search strategy I use is based on the assumtion 1] by
'records' you mean bib records and 2] 'all attached items withdrawn' means
the bib no longer has any items attached, or is what I call and 'empty bib
record".  The other caveat is if your catalogers add bibs and you display on
order items you don't want to remove those bibs, thus you want to limit by
date.

In the text-based system: Choose an empty file to work with, select 2
-->create a new file--> B bibliographic list.  The search is ^ [caret, the
symbol over the 6 key] linked record N [does not exist] for i [item records]
A [AND] ^ [linked record] N [does not exist] for o [order records]A [AND] ^
[linked record] N [does not exist for} c [checkin records]. 

This assures you that if there are any linked records the bib will be
excluded from your list. This is obvious for items since that is your goal,
but not so obvious for order and checkin records. 

If you want to limit by date for the reason mentioned above , I use field 10
in my bib records which is 'created date' being the date the record was
created: A [AND] 10 L [less than or equal to] 11-01-2004 or whatever date
you feel fits your situation. This also could apply to a newer item that was
lost and you intend to replace, saving you the cost of another OCLC record
etc. etc. I would test all this by using the limit feature or 's'stopping
the search and examining the results before you let it go through your
entire database. It is a fairly slow search due to all the files the system
checks. HTH.  Eric Rhee,  Chula Vista Public Library

-----Original Message-----
From: Aaron Beebe [mailto:ABeebe at thegdl dot org]
Sent: Wednesday, January 05, 2005 7:02 AM
To: innopac at innopacusers dot org
Subject: All Items Withdrawn


Sorry for this reposting, I know I saw the thread on here somewhere but
I just can seem to find it.  I was wondering about a create list
Strategy to get a list of Records where all of the attached items are
withdrawn.  We are running MilSilver.

 

Thanks,

 

Aaron Beebe

Database Administrator

Genesee District Library



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---
--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC at innopacusers dot org
Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac