IUG FORUM

Stay always connected!
  1. Alison Pruntel
  2. Sierra/ Millennium/ Encore
  3. Monday, 13 February 2017
  4.  Subscribe via email
Hi all,

I am trying to get a list of items that have an incorrect I type – mainly, they are still marked as new and thus aren’t renewable. I noticed some older items not being renewable and they had an itype as “new hardbacks,”(I type 14 in our case) thus the loan rule assigned would not allow renewal.

I am getting mixed up as to what date I should be using to limit my query. I don’t care when the bib was created/cataloged, instead when the item record was attached.

I am using ITEM I TYPE equal to "14" AND ITEM CREATED less than "01-01-2016" AND ITEM STATUS equal to "-" and am getting more than I expected.

When I start looking at the records, I see they’ve been updated since 1/1/16, but that could be for anything.

Am I doing this wrong/looking at this wrong, or do we truly have a lot of items that never got their itype switched back to a “not new” type, i.e., Hardback Books vs. NEW Hardback Books?

The more I read the thread(s) about cat date vs. create date (http://innovativeusers.org/list/archives/2015/msg00349.html), the more confused I became, not sure if they were just referring to bib records.

Thanks,

Alison Pruntel
Electronic Resources Librarian
Fauquier County Public Library
11 Winchester St.
Warrenton, VA 20186
540.422.8515
http://fauquierlibrary.org

alison.pruntel@fauquiercounty.gov
Comment
There are no comments made yet.
Accepted Answer Pending Moderation
0
Votes
Undo
Rec'd feedback on the Sierra listserv regarding this and was able to come up with the list of items I needed...

http://listserv.iii.com/read/messages?id=478746

Store record as item type
item I type = <group your "new" itypes in an OR statement>
AND
item created less than <date - 6 mos or whatever)
AND
item status = "available"*
*Just too many when I included missing, etc. as the items were not returned and thus staff would not have even thought to have changed the I type. Will tackle those some other time.

alison.pruntel@fauquiercounty.gov
Comment
There are no comments made yet.
  1. more than a month ago
  2. Sierra/ Millennium/ Encore
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!