Bug 39562

Summary: allow for more criteria in update_patrons_category
Product: Koha Reporter: Hannah Dunne-Howrie <hdunne-howrie>
Component: PatronsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: aude.charillon, gmcharlt, kyle.m.hall
Version: 24.11   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Hannah Dunne-Howrie 2025-04-04 11:06:52 UTC
We want to be able to use this script to expiry all patrons who have not used their account in the last 12 months. At the moment, we cannot filter by all of the below criteria -

lastseen
issuedate
reservedate
'timestamp' (in accountline)

Essentially, if there has been been no measurable activity on the patron's record we want to expiry the patron 12 months from the date of last activity.

This can be done using a koha report but becomes manual which is not ideal as this used to be an automated daily script in our old library system.