[Koha-bugs] [Bug 31787] [DOCS] Add description and examples to membership_expiry.pl about --where option

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

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

Marie-Luce Laflamme <marie-luce.laflamme at inlibro.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |marie-luce.laflamme at inlibro
                   |                            |.com

--- Comment #2 from Marie-Luce Laflamme <marie-luce.laflamme at inlibro.com> ---
I've also had a hard time testing the categorycode argument. However, David’s
description had the answer in the IRC discussion link.

We need to add a "me" before the categorycode, so it should look like this:
   --where="me.categorycode = 'CODE' "

e.g.

to run send email only for one category, try:
./misc/cronjobs/membership_expiry.pl -c -v -n --before 100 --after 100
--where="me.categorycode = 'S'"

to exclude a category, try:
./misc/cronjobs/membership_expiry.pl -c -where="me.categorycode !='YA'"

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