Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Where does Aleph store original item values which will get restored?

    Where does Aleph store original item values which will get restored?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description:
    2. Resolution:
    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Description:


    We have the problem describe in KB 16384-26785. I’m facing several hundred items in our NewBooks collection (temporary changes) that will have their z30-item-status set to null if we use Restore to put them back into our main collection.

    I installed the latest Service P yesterday so at least new items placed in that collection will be fine, but dread dealing with the ones that are already in there.

    If I knew exactly what happens when an item is changed temporarily, I might be able to make a SQL statement that could fix the ones affected. At the moment, I have no idea where Aleph stores the original values that will get Restored. I did a quick search of the Aleph 20 Collected Oracle Tables document but didn’t see anything.
     

     

    Resolution:

    The pre-Store sublibrary, collection, item status, etc., item information is stored in a Z30 field in the ADM doc record. If you do util f/4 for the ADM# of an item which has been stored, you will see this Z30 field.

    It may be possible to run the p_manage_21 global change in the xxx50 library to add the necessary subfields to this Z30 field.

    [From site:]

    We 'solved' this by creating a procedure our circ desk workers can follow when they encounter an item with its item_status set to null.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Where does (non-existent) z35_bor_status "99" come from?
      • Where does list of bases in the GUI - Find - Advanced Search come from?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved