Bug 27347 - Allow automatic item modification by age to match NULL values
Summary: Allow automatic item modification by age to match NULL values
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-05 22:09 UTC by Andrew Fuerste-Henry
Modified: 2023-05-26 14:08 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Andrew Fuerste-Henry 2021-01-05 22:09:13 UTC
Automatic item modification by age isn't able to match on a null value, so we can't set a rule for something like "all items more than 60 days old that don't have any collection code." That'd be handy.
Looks like bug 18752 made it so we could set a blank as our substitution value, but doesn't help on the match value. The issue may be that Koha ends up looking for an empty string rather than for a null.
Comment 1 George Williams (NEKLS) 2021-01-05 22:10:44 UTC
Being able to set a condition to match on a null value would be a very helpful enhancement to this tool.
Comment 2 Ron Houk 2021-01-06 13:38:12 UTC
I think this sounds like a useful enhancement.  I would also like to see more options like "!=" or "IS NOT NULL"  Like in this mockup -> https://pasteboard.co/JIoatdC.gif