Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Community Knowledge
    4. Custom Reports: Query of Patrons with Expired Purge Date and No Fines or Fees

    Custom Reports: Query of Patrons with Expired Purge Date and No Fines or Fees

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    Created By: Shelley Schultz
    Created on: 5/15/2019



    [This article was copied from the Voyager Wiki.]

    This query will give all patron records that have an expiration or purge date more than one year.

    SELECT PATRON.INSTITUTION_ID, PATRON.EXPIRE_DATE, PATRON.PURGE_DATE, PATRON.TOTAL_FEES_DUE, PATRON.CURRENT_CHARGES, PATRON.LAST_NAME, PATRON.FIRST_NAME, PATRON.REGISTRATION_DATE, PATRON.MODIFY_DATE
    FROM PATRON
    WHERE (((PATRON.PURGE_DATE)<Now()) AND ((PATRON.TOTAL_FEES_DUE)="0") AND ((PATRON.CURRENT_CHARGES)="0")) OR (((PATRON.EXPIRE_DATE)<Now()-364) AND ((PATRON.TOTAL_FEES_DUE)="0") AND ((PATRON.CURRENT_CHARGES)="0") AND ((PATRON.REGISTRATION_DATE)<>[EXPIRE_DATE]))
    ORDER BY PATRON.INSTITUTION_ID;




    Report
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Custom Reports: Query of MFHD Records Suppressed in OPAC within Specific Date Range
      • Custom Reports: Query Reports All Bib Records That Contain an 856 Field
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    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