Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

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

    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;




    //Feedback