• Article Type: General
• Product: Aleph
• Product Version: 17.01

Description:
We've successfully migrated to version 20. I'd left version 17 accessible to the circulation dept for comparison and unfortunately on Friday, August 21, the circulation staff opened version 17 rather than version 20 on one of the workstations and did all the day's circulation activity for Friday on version 17. How can I obtain a list of loans and renewals with patron ids for that day out of the version 17 database?

Resolution:
There were just 25 circ transactions on Friday:

SQL> select z35_rec_key || '-' || Z35_ITEM_SEQUENCE, z35_id, z35_event_type from z35 where z35_event_date = '20090821';

Z35_REC_KEY||'-'||Z35_ITEM_SEQUENCE Z35_ID Z3
-------------------------------------------------- ------------ --
000434747-10 82
000296000-20 11114 50
000296000-50 1027966 61
000380627-10 988992500 61
000380208-10 988992500 61
000434782-10 988992500 61
000437236-10 988992500 61
000380625-10 6663 61
000342074-10 82
000056220-840 82
000428215-10 82
000296000-20 11114 61
000428611-10 11009 50
000089593-10 1031384 50
000038697-10 1031384 50
000244458-10 82
000380250-10 11009 61
000428706-10 16690 50
000433713-10 10736 50
000159420-10 1026527 61
000433713-10 10736 61
000245995-10 27238 50
000342476-10 6199 63
000342476-10 6199 61
000433713-10


Event type

50 is a loan;
61 is a return;
82 is return of an item not on loan;
63 is a renewal

• Article last edited: 10/8/2013