Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Update patron expiry date for selected patrons

    Update patron expiry date for selected patrons

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    We need a way to update the expiry date for a subset of our local patron records. Although I haven't been told the scope of the problem yet, the majority of patron records requiring adjustment have z303-title = 2010, z303-home-library = acfst, and z305-expiry-date = 04/30/07. I'm guessing we'll have to do an SQL find/replace operation to make this change. I need help correctly constructing the retrieval query and replacement operation.

    This is for patrons with ALEPH patron status=09 only.

    Resolution:
    All of the type 09 z305's are in the fcl00 $usr_library; none in xxx50. So the update I have suggest below is for fcl00, not xxx50.

    Make sure that these are what you want:

    >s+ fcl00;

    fcl00@ALEPH0> select count(*) from z305 where z305_bor_status = '09' and substr(z305_rec_key,1,12) in (select z303_rec_key from z303 where z303_home_library = 'ACFST' and z303_title = '2010');

    To look at the patrons before changing them, instead of doing "select count(*) from z305 ...", do "select z305_rec_key from z305 ...". This will give you a list of patron record keys you can look at.

    2. Run p_file_03 to back up the FCL00 Z305 table.

    3. Use this SQL to do the update:

    >s+ fcl00;

    fcl00@ALEPH0> update z305 set z305_expiry_date = '20070430' where z305_bor_status = '09' and substr(z305_rec_key,1,12) in (select z303_rec_key from z303 where z303_home_library = 'ACFST' and z303_title = '2010');


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Update option for p_manage_32 and other settings
      • Update Patron Records (cir-77) does not update all patrons
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved