RE: All Items Withdrawn

["Aaron Beebe" <ABeebe at thegdl dot org>]

Eric,

	Well that was close.  Assumption 1 is correct 2 however,
Withdrawn is a status code that we use, something I should have
explained sorry.  This allows us to place an Item in a status of
withdrawn then after a given length of time run some programs to
suppress the item, and remove it from the catalog.  What we then have is
a Bib-record with all of the items suppressed.  This is what I need to
know how to find.  Hopefully this is a little clearer.

Aaron Beebe
Database Administrator
Genesee District Library

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Eric Rhee
Sent: Wednesday, January 05, 2005 4:18 PM
To: 'IUG INNOPAC List'
Subject: RE: All Items Withdrawn

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
--
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