- Article Type: General
- Product: Aleph
- Product Version: 16.02
What is the proper way to identify, via SQL, when serials and monographs are actually received and checked-in to Aleph? For example, I would like to know that "on Wednesday, we received the July issue of Newsweek".
First, you would need to know the record key of the ADM record for Newsweek. To get this, note the bib key and then do util a/3/12, specifying the bib library and key. It will show you the ADM and HOL records linked to this bib record.
Then you would do the following SQL:
SQL> select z30_description, z30_arrival_date, z30_rec_key from z30 where z30_arrival_date like '2007%' and z30_rec_key like '000123456%';
<where 000123456 is the ADM record # you found in the first step>.
In regard to SQL, the Support Knowledge Base and the US PRB database have hundreds of SQL queries. One record with many queries is KB 8192-2744.
The ALEPH-NA archives also has many.
KB 8192-1496 describes how to access the Ex Libris user script repository.
- Article last edited: 10/8/2013