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. Report of patrons with specific global- or local-note value

    Report of patrons with specific global- or local-note value

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution

     

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

     

    Description

    We would like to add a note to the Circulation/ Global Patron Information/Global Blocks & Notes for patrons who have an ID for a service called Safari Books. 

    Is there a report (or SQL) which can be run to export a list of these patrons?

      

    Resolution

    The cir-05 ("Patron list")  report lets you select patrons based on Local Block Code (z305_delinq_n) or Global Block Code (z303_delinq_n), but there is no option to select patrons based on Local Note or Global Note values in this or any other report.

    The following SQL can be used to retrieve the patron ID and name of patrons with an "Additional Note 1" (in the Global Patron Information) with a value of "Safari Books":

    SQL>  select z303_rec_key, z303_name from z303 where z303_note_1 = 'Safari Books';

     


    • Article last edited: 3-Aug-2018
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Report of patron's overdue notices / activity for particular item
      • Report of titles in a collection
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
    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