Skip to main content
OCLC Support

I want to delete patrons using the ILLiad Database Manager, but my query gets no results

  • You put in a query for deleting patrons in the ILLiad Database Manager, but no patrons show up
Applies to
  • ILLiad

If you are trying to delete patrons, there are some features in the Database Manager that will not list a patron and the solution:

  1. If the patron has any transaction history, the patron will not be deletable in the Database Manager.
  2. There is a box for "Only delete patrons if Expiration Date has passed."  If that box is checked, then only patrons who have an expiration date that is passed will show up on the list.
  3. If you decide that you want to delete patrons whose Expiration Date has not passed, then deselect the box for "Only delete patrons if Expiration date has passed."  
  4. Your query might not have a match.  For example, you have the query where the Username equals 'abc,' but there is no patron with the username 'abc.'
  5. If there are patrons that you want to delete, but the patrons have transaction history, then you will have to follow the Breaking the User Link in the ILLiad Database instructions.
  6. If you are self-hosted, you will need to contact your SQL Administrator.
  7. If you are hosted by OCLC, please contact OCLC Support.
Page ID