Skip to main content
ExLibris

Knowledge Assistant

BETA
 
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. Count of items or titles by collection

Count of items or titles by collection

  1. Last updated
  2. Save as PDF
  3. Share
    1. Share
    2. Tweet
    3. Share
  1. Description
  2. Resolution

 

  • Product: Aleph
  • Product Version: 20, 21, 22, 23
  • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

 

Description

How can we get a count of the number of A) items or B) titles for each collection?

Resolution

A) To get a count of the number of items for each collection:
> s+ xxx50
SQL> select z30_sub_library, z30_collection, count(*) from z30 group by z30_sub_library, z30_collection;

 

B) To get a count of collections by bib/hol record: 

1. Build USER-DEF-n fields in the xxx60 tab22 to generate z13u table entries.  For example:
  USER-DEF-1 1 852## b
  USER-DEF-1 1 852## c

 

2.  Run manage-07 for xxx60; 

 

3. Create a script collection_count.sql:
set echo off
set pause off
set term off
set show off
set verify off
set heading off
set feed off
spool collection_count.lst
select z13u_user_defined_1, z13u_user_defined_2, count(*) from z13u group by z13u_user_defined_1, z13u_user_defined_2;
spool off
exit

4.  
> s+ xxx60
SQL>  @collection_count.sql

 


  • Article last edited: 25-Mar-2016
View article in the Exlibris Knowledge Center
  1. Back to top
    • Count of Aleph Digital Metadata records
    • Count of New and Updated Catalog Records - by Cataloger (com-02)" vs "Report of New and Updated Catalog Records - by Cataloger (com-03)"
  • Was this article helpful?

Recommended articles

  1. Article type
    How-To
    Language
    English
    Product
    Aleph
  2. Tags
    1. collection
    2. count
  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