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

[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;