Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Determining Number of Patrons Added to Database Since a Certain Date

    • Article Type: General
    • Product: Aleph

    Is there an SQL command we can use to determine how many new patrons of each patron type have been added to our database since a certain date or between certain dates?

    We would like to know how many new patrons of each patron type we have registered since opening our new facility last September.

    The following SQL can be used to get you this count:

    > s+ abc50
    SQL> select z305_bor_status, count(*) from z305 where z305_open_date >= '20080901' group by z305_bor_status;

    Additional Information


    • Article last edited: 10/8/2013
    • Was this article helpful?