Bugzilla – Attachment 107292 Details for
Bug 25624
Update patrons category script should allow finding null and not null and wildcards
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 25624: Update documentation
Bug-25624-Update-documentation.patch (text/plain), 3.84 KB, created by
Alex Arnaud
on 2020-07-24 09:01:05 UTC
(
hide
)
Description:
Bug 25624: Update documentation
Filename:
MIME Type:
Creator:
Alex Arnaud
Created:
2020-07-24 09:01:05 UTC
Size:
3.84 KB
patch
obsolete
>From b58ec8cbef27681f9a0d669d4798a077aaa53da6 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Thu, 16 Jul 2020 17:49:12 +0000 >Subject: [PATCH] Bug 25624: Update documentation > >Signed-off-by: Alex Arnaud <alex.arnaud@biblibre.com> >--- > misc/cronjobs/update_patrons_category.pl | 30 ++++++++++++++++++++++++++---- > 1 file changed, 26 insertions(+), 4 deletions(-) > >diff --git a/misc/cronjobs/update_patrons_category.pl b/misc/cronjobs/update_patrons_category.pl >index f38fd92a93..e094044086 100644 >--- a/misc/cronjobs/update_patrons_category.pl >+++ b/misc/cronjobs/update_patrons_category.pl >@@ -55,10 +55,10 @@ Options: > -fu=X --fineunder=X update if fines under X amount > -rb=date --regbefore update if registration date is before given date > -ra=date --regafter update if registration date is after a given date >- -d --dbfield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> >- -dn --notfield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> >- -dl --likefield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> >- -dnl --notlikefield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> >+ -d --field name=value where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value> >+ -dn --notfield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is not equal to given <value> >+ -dl --likefield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is like the given <value> >+ -dnl --notlikefield name=value where <name> is a column in the borrowers table, patrons will be updated if the field is not like the given <value> > -v -verbose verbose mode > -c --confirm commit changes to db, no action will be taken unless this switch is included > -b --branch <branchname> only deal with patrons from this library/branch >@@ -125,6 +125,7 @@ Enter a date in ISO format YYYY-MM-DD and only patrons registered after this dat > =item B<--field column=value | -d column=value> > > Use this flag to specify a column in the borrowers table and update only patrons whose value in that column equals the value supplied (repeatable) >+A value of null will check for a field that is not set. > > e.g. > --field dateexpiry=2016-01-01 >@@ -133,11 +134,32 @@ will update all patrons who expired on that date, useful for schools etc. > =item B<--notfield column=value | -dn column=value> > > Use this flag to specify a column in the borrowers table and update only patrons whose value in that column does not equal the value supplied (repeatable) >+A value of null will check for a field that is not set. > > e.g. > --notfield email=NULL > will update all patrons with no value for email > >+=item B<--likefield column=value | -dl column=value> >+ >+Use this flag to specify a column in the borrowers table and update only patrons whose value in that column is like the value supplied (repeatable) >+use '%' as a wildcard. >+A value of null will check for a field that is not set. >+ >+e.g. >+--likefield categorycode=%CHILD >+will update all patrons with a category ending in CHILD. >+ >+=item B<--notlikefield column=value | -dnl column=value> >+ >+Use this flag to specify a column in the borrowers table and update only patrons whose value in that column is not like the value supplied (repeatable) >+use '%' as a wildcard. >+A value of null will check for a field that is not set. >+ >+e.g. >+--notlikefield categorycode=RESIDENT% >+will update all patrons whose category does not begin with RESIDENT. >+ > =back > > =head1 DESCRIPTION >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 25624
:
105439
|
105605
|
106965
|
107291
|
107292
|
109116
|
109370
|
109421
|
109427
|
109440
|
110747