https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31787 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |andrew@bywatersolutions.com --- Comment #9 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- The following all worked for me: perl misc/cronjobs/membership_expiry.pl -v -letter MEMBERSHIP_EXPIRY -c -where="me.categorycode = 's'" perl misc/cronjobs/membership_expiry.pl -v -letter MEMBERSHIP_EXPIRY -c -where="me.categorycode in ('s','pt')" perl misc/cronjobs/membership_expiry.pl -v -letter MEMBERSHIP_EXPIRY -c -where "me.categorycode in ('s','pt')" I haven't needed to escape any quotation marks, though it did error out when I made mistakes and my quotation marks didn't match up correctly. I guess I just forgot to include the "=" after "where" at first, but apparently it doesn't care? All of the above fail if I leave off the "me." before "categorycode." This also works: perl misc/cronjobs/membership_expiry.pl -v -letter MEMBERSHIP_EXPIRY -c -where 'borrowernumber in (select borrowernumber from borrower_attributes where code="show_bcode" and attribute=0)' No clear idea why that doesn't need a "me." It works with or without it. I ended up here because I was doing a search before filing a bug to create a clearer way to check attributes here. -- You are receiving this mail because: You are watching all bug changes.