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

    SQL to get patron IDs of borrowers with blank borrower status

     

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

     

    Description:

    When I issue the following SQL command in the XXX50 database to get a breakdown of the number of borrowers in each of our borrower statuses, 12 of the borrowers seem to not have a borrower status assigned to them:

    SQL> select Z305_BOR_STATUS, count(*) from Z305 group by Z305_BOR_STATUS;

    Is there an SQL command I can use to get the patron IDs of borrowers who currently do not have a borrower status assigned to them?

     

    Resolution:
    SQL> select z305_rec_key from z305 where Z305_BOR_STATUS is null or Z305_BOR_STATUS like ' %';

     

     


    • Article last edited: 12-Mar-2016