How to list patrons with particular patron status.

• Article Type: General
• Product: Aleph
• Product Version: 21

Desired Outcome Goal:
A list of yyy50 patrons with BOR-STATUS of "11" (in a multi-ADM set-up).

Procedure:
Use the following SQL (where xxx50 is your $usr_library):

> s+ yyy50
yyy50@ALEPH21> select z303_name from XXX50.z303, z305 where substr (z305_rec_key,1,12) = z303_rec_key and z305_bor_status = '11' order by z303_name asc;

Category: Circulation (500)

Subject: Patrons

• Article last edited: 10/8/2013