FacebookTwitterLinkedIn
Login / Register

Login / Register

IUG FORUM

Stay always connected!
  1. Bruce Eames
  2. Sierra/ Millennium/ Encore
  3. Wednesday, January 31 2018, 11:14 PM
  4.  Subscribe via email
Hi All,

I have a good old-fashioned list question.

I want to find bibs which have attached items with location mbe and tot checkouts = 0 and also have attached items with location mbe and tot checkouts 1+. I tried grouping these to force the system to give me bibs which had attached items matching both tot checkout criteria.

(ITEM LOCATION starts with "mbe " AND ITEM TOT CHKOUT greater than or equal to "1";)
AND
(ITEM LOCATION starts with "mbe" AND ITEM TOT CHKOUT less than "1";)

But no the system seems to be ORing them, giving me many bibs which have only 1 item from the location specified, which may randomly have 0 or 1+ checkouts .

Does anyone have any great advice? Is this a bug?

Thanks so much,

Bruce.

bme@unimelb.edu.au
Comment
There are no comments made yet.
Add Comment
Eeva Stierwalt Accepted Answer
0
Votes
Undo
Hi Bruce! Try this:
Item location starts with mbe
and
(Item TOT CHKOUT greater than or equal to '1'
OR
Item TOT CHKOUT less than '1')

That should work! Let me know! Kind regards and HAPPY NEW YEAR!!!

eeva.stierwalt@lpl.london.on.ca
Comment
There are no comments made yet.
Add Comment
Bruce Eames Accepted Answer
0
Votes
Undo
Thanks Eeva,
Alas this finds many bibs which have only 1 mbe item attached when of course I only want bibs with multiple items.
And I see the IUG Forum site has turned some of my my brackets into emoticons!
I will keep trying list strategies and let you know what works...
Bruce.

bme@unimelb.edu.au
Comment
There are no comments made yet.
Add Comment
Eeva Stierwalt Accepted Answer
0
Votes
Undo
Hi Bruce! Try adding to the beginning of the criteria a line that says:
Bib Location = multi
I hope that does the trick!

eeva.stierwalt@lpl.london.on.ca
Comment
There are no comments made yet.
Add Comment
Linda Fox Accepted Answer
0
Votes
Undo
Hi, Bruce,

I wonder if you are running into a problem because you are creating a review file of bibliographic records using criteria from attached item records. We see this occasionally. What seems to be happening is that when Sierra (or Millenium) finds an attached item record that satisfies the first criterion, it then examines ALL the attached item records to find the second. So, in your case, let's say that your bibliographic record has two attached item records. The first has a location code of mbeii and has never been checked out. The second item has a location code of abcde, and has been checked out 6 times. This record will be pulled into the file because there is an attached item record that meets each of the criteria.

You might try this as a workaround. I think it will get you what you want, although I haven't tested it.

1) Create a review file of all the item records where the ITEM LOCATION starts with "mbe" and ITEM TOT CHKOUT is greater than or equal to "1"
2) Create a review file of all the bibliographic records and run it against the review file created in step 1
3) Create a review file of all the item records where the ITEM LOCATION starts with "mbe" and ITEM TOT CHKOUT is less than "1" and run it against the review file created in step 2. This should give you all of the item records that meet the second set of criteria which are attached to bibliographic records which also have attached item records that meet the first set of criteria.
4) Create a review file of all the bibliographic records and run it against the review file created in step 3.

I hope this works for you.

Linda Fox
Senior Library Information Specialist
UMKC University Libraries
Miller Nichols Library Room 304
800 E 51st Street
Kansas City, MO 64110
https://library.umkc.edu
(816) 235-5290
fax: (816) 333-5584
foxlj@umkc.edu

foxlj@umkc.edu
Comment
There are no comments made yet.
Add Comment
Bruce Eames Accepted Answer
0
Votes
Undo
Hi Eeva and Linda,
Thanks so much for your advice.
I think your suggestion would have worked Linda but in the end I ended up doing an SQL query and then a pivot table in Excel.
In a bib list, grouping item search criteria will not make the system match multiple criteria on one item : it just finds matches across any of the attached items.
Cheers,
Bruce.

bme@unimelb.edu.au
Comment
There are no comments made yet.
Add Comment
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,pdf,ppt,pptx,doc,docx,xls,xlsx,,txt,rtf,jrxml
• Remove Upload Files (Maximum File Size: 2 MB)
You may insert polls into your post. The poll would then appear in the post.
Vote Options
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.