- Article Type: General
- Product: Aleph
- Product Version: 18.01
I am trying to figure out a service of SQL query to get how many loans we had by serial title in the last year (from july 08 to july 09).
Is there a way to get this data from ALEPH?
SQL> SELECT Z13_REC_KEY AS sys,
Z13_AUTHOR AS author,
Z13_TITLE AS title,
Z13_IMPRINT AS imprint,
COUNT(1) AS hits
WHERE Z35_EVENT_DATE BETWEEN 20080701 AND 20090731
AND TRIM(Z35_EVENT_TYPE) IN ('50','51','52','53')
AND TRIM(Z35_MATERIAL) = 'ISSUE'
AND (Z13_REC_KEY = Z103_LKR_DOC_NUMBER)
AND (Z103_LKR_TYPE = 'ADM')
AND (Z103_LKR_LIBRARY = 'IAD01')
AND (SUBSTR(Z103_REC_KEY,6,9) = Z35_REC_KEY)
GROUP BY Z13_REC_KEY, Z13_AUTHOR, Z13_TITLE, Z13_IMPRINT
ORDER BY hits DESC
- Article last edited: 10/8/2013