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