Bug 39562 - allow for more criteria in update_patrons_category
Summary: allow for more criteria in update_patrons_category
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: 24.11
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-04 11:06 UTC by Hannah Dunne-Howrie
Modified: 2025-04-04 12:07 UTC (History)
3 users (show)

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.