[Koha-bugs] [Bug 25624] Update patrons category script should allow finding null and not null and wildcards

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25624

Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #107291|0                           |1
        is obsolete|                            |
 Attachment #107292|0                           |1
        is obsolete|                            |
 Attachment #109421|0                           |1
        is obsolete|                            |

--- Comment #19 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Created attachment 109427
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=109427&action=edit
Bug 25624: Add --where option to update_patrons_category.pl

The script did not allow to find empty fields or use wildcards

With this new option we will now have the ability to filter patrons by
some of their attributes.

Test plan:
1 - Run the script with no parameters and verify the help explains the
parameters
2 - Try the script with one or more --where parameters, like:
  --where "firstname='koha'"
3 - Test null values
  --where "firstname IS NULL"
4 - Test like values with wildcards
  --where "firstname LIKE '%a%'
5 - Test like with the word null to find fields containing the word rather than
being unset

-- 
You are receiving this mail because:
You are watching all bug changes.