Bug 39595 - Allow membership_expiry.pl to limit based on patron attribute
Summary: Allow membership_expiry.pl to limit based on patron attribute
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Command-line Utilities (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-09 18:33 UTC by Andrew Fuerste-Henry
Modified: 2025-04-09 18:33 UTC (History)
1 user (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 Andrew Fuerste-Henry 2025-04-09 18:33:42 UTC
The membership_expiry cron can take a "WHERE" value to check against the borrowers table in order to limit who gets renewed/notified (like "where categorycode != 'STAFF'").

It'd be helpful to have a way to check a patron attribute here, too. Maybe we could add options to the cron for "-attribute_code" and "-attribute_value" to limit only to patrons who have an attribute that matches the code and value?

This is technically possible with the current WHERE implementation: -where 'me.borrowernumber in (select borrowernumber from borrower_attributes where code="show_bcode" and attribute=1)'

But making is an explicit option would be more clear.