Bug 27347

Summary: Allow automatic item modification by age to match NULL values
Product: Koha Reporter: Andrew Fuerste-Henry <andrewfh>
Component: ToolsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: george, lisettepalouse+koha, rhouk
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18752
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29941
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

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