Re: [IUG] Review file of bibs with no attached checkin records where...

["Jackson, Richard" <rjackson at huntington dot org>]

Yitzchak:

You're right, this topic (or similar ones) does come up fairly often.
The difficulty is that the possibility of multiple attached records can
make a condition both true and false at the same time.  For example, you
might have two checkins attached to a bib, one with location 'abcd' and
another with a different location.  If you're storing bib records in
your list, then both these statements will be true for that bib record:

     CHECKIN  Location  equals  'abcd'

     CHECKIN  Location  does not equal  'abcd'

Here's a method that should work:

1) Make a list of bibs for which:

     BIB Location = 'abcd'
AND  CHECKIN Location does not equal 'abcd'

This list will contain everything you need, but may contain some records
that also have a checkin with location 'abcd'.

2) Searching within the first list, make a second list of bibs for
which:

     CHECKIN Location = 'abcd'

3) Use Global Update to add some temporary, distinctive flag to the bib
records in the second list, such as "599 Exclude: checkin loc=abcd"

4) Make your final list by searching within the first list for bib
records that do not contain the flag you added.

5) Use Global Update to delete the temporary flag from the records in
the second list.

I hope this helps.

Richard V. Jackson
Head of Copy Cataloging / Database Manager 
Huntington Library, Art Collections, and Botanical Gardens 
1151 Oxford Road, San Marino, CA 91108
rjackson at huntington dot org / 626-405-2100 x2384


-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Yitzchak Schaffer
Sent: Tuesday, November 13, 2007 10:03 AM
To: 'IUG INNOPAC List'
Subject: [IUG] Review file of bibs with no attached checkin records
where...

Greetings IUG listers:

This seems like a topic that comes up in variant forms from time to
time,
but I couldn't find it in the archives, so:

We are trying to create a list of bib records with location=abcd, which
do
not have any checkin records with location=abcd.  Does anyone know the
search syntax?

Many thanks,

Yitzchak Schaffer
Systems Librarian
Touro College Libraries
33 West 23rd Street
New York, NY  10010
Tel (212) 463-0400 x230
Fax (212) 627-3197
yitzchas at touro dot edu

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