Where does Aleph store original item values which will get restored?
- 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