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.


Alison Pruntel
Electronic Resources Librarian
Fauquier County Public Library
11 Winchester St.
Warrenton, VA 20186

There are no comments made yet.
Accepted Answer Pending Moderation
Rec'd feedback on the Sierra listserv regarding this and was able to come up with the list of items I needed...


Store record as item type
item I type = <group your "new" itypes in an OR statement>
item created less than <date - 6 mos or whatever)
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.

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!