• 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