RE: Create List of records that have no Bib level Lib Has field

[Jeff Malch <malchj@xxxxxxxxxx>]

Group---

Our serials librarian tells me that the carriage return (blank input) 
is working perfectly.  Thanks for the help everyone! 

---Jeff

Date sent:      	Wed, 16 Jul 2003 17:46:51 -0400
From:           	John Dillon <JDillon@xxxxxxxxxx>
Subject:        	RE: Create List of records that have no Bib level Lib Has field
To:             	"'innopac@xxxxxxxxxx'" <innopac@xxxxxxxxxx>
Send reply to:  	innopac@xxxxxxxxxx

[ Double-click this line for list subscription options ] 

Jeff,

The trick you may be looking for is to say that the H tag field = nothing.
(Just hit <enter> for nothing.  If I remember right, this brings up Bibs
that don't have any occurence of that field.  You could search both Bibs and
Checkins at once by first specifying the Bib h tag = nothing, And... then
use the ? sign to switch to Checkin field options to AND the same
specification.  It would look like this, the second Lib Has representing
from the Checkin:

Find BIBLIOGRAPHIC records that satisfy the following conditions
    BIB LVL = s AND LIB. HAS =  AND LIB. HAS =


John

Date sent:      	Wed, 16 Jul 2003 17:27:27 -0400
From:           	"Gale E. Eckerson" <geckerso@xxxxxxxxxx>
Subject:        	Re: Create List of records that have no Bib level Lib Has field
To:             	innopac@xxxxxxxxxx
Send reply to:  	innopac@xxxxxxxxxx
Priority:       	normal

[ Double-click this line for list subscription options ] 

Hi, Jeff and all:

We have been following the guidelines stated in the INNOPAC 
User Manual. If you wish to find a record which does NOT 
contain a particular variable-length field, you select the field (in 
Jeff's case "h" and then = [followed by nothing]. According to 
III, "h=" will retrieve records that do not contain the "library 
has" field. I am not sure how he can get both the bib records 
without a holdings statement (?) and the checkin records 
without a holdings statement, but I certainly know how to deal 
with the checkin records alone. There, he would just call up 
his range of checkin records and ask for "h=".

Not sure if this helps. We have had some luck with the 
"equals nothing" but not 100%. Sometimes we use "is less 
than [nothing i.e. a carriage return or space]" and that seems 
to work too! Just a note, the create lists function in most 
cases works more precisely and with more options if you get 
at it from Millennium Cataloging. Not sure if Jeff has MilCat.

Gale E. Eckerson
C/W MARS
Paxton, MA 01612

Date sent:      	Wed, 16 Jul 2003 15:29:37 -0700
From:           	Diane Moore <diane.moore@xxxxxxxxxx>
Subject:        	Re: boolean search
To:             	innopac@xxxxxxxxxx
Send reply to:  	innopac@xxxxxxxxxx

[ Double-click this line for list subscription options ] 

Jeff Malch asked:

"the problem is that there is no boolean operator for "give me the
records if the Lib. Has field doesn't exist." (e.g. BIB LEVEL = s AND
LIB. HAS not exist AND ...)

I believe you would use

BIB LEVEL = s

AND

LIB HAS =       (leave this blank, indicating "equal to nothing", which 
picks up records which do not have your lib has field)

I think you want to use "equal to nothing" instead of "not exists".

Diane Moore
Cal State Northridge



-----Original Message-----
From: Jeff Malch [mailto:malchj@xxxxxxxxxx]
Sent: Wednesday, July 16, 2003 5:33 PM
To: innopac@xxxxxxxxxx
Cc: roushb@xxxxxxxxxx
Subject: Create List of records that have no Bib level Lib Has field


Hello---

I'm looking for a boolean search solution in the create list function 
that will get me the following records:

All serial bib records (bib level s) that do not have a holdings 
statement, either in the bib record or the checkin record.  
(history/background) We designate holdings with an 'h' rather than a 
marc tag at this time.

Currently I have been entering this beginning part of the string for 
the search:

BIB LEVEL = s AND LIB. HAS

but the problem is that there is no boolean operator for "give me the 
records if the Lib. Has field doesn't exist." (e.g. BIB LEVEL = s AND 
LIB. HAS not exist AND ........)

I do know that when I'm in the checkin level (? -> C) I can get "/3 
CHECKIN" which will allow me to retrieve a boolean on whether the 
checkin record "e)xists" or "n)ot exists".  Is there something like 
this for the Lib. Has field in either the bib or checkin levels?  If 
not can III turn it on?

I do know that we can print out every serial record's lib. has field 
and see if any record is missing a holdings statement, but I was 
hoping to trim down the list from our entire serials collection to 
just the records with missing information.

Thanks.

-----------------------------------------
Jeff Malch
Library Computer Services Assistant
U.C. Hastings College of the Law Library
200 McAllister Street
San Francisco, CA 94102-4978
(415)565-4767
malchj@xxxxxxxxxx

--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options:
http://innopacusers.org/list/listinfo/innopac
--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options: http://innopacusers.org/list/listinfo/innopac-----------------------------------------
Jeff Malch
Library Computer Services Assistant
U.C. Hastings College of the Law Library
200 McAllister Street
San Francisco, CA 94102-4978
(415)565-4767
malchj@xxxxxxxxxx