http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14504 --- Comment #1 from Barton Chittenden <barton@bywatersolutions.com> --- NAME delete_items.pl - A batch item deletion tool, which generates a query against the items database and deletes the items matching the criteria specified in the command line arguments. SYNOPSIS delete_items.pl [--help|--manual|--version] delete_items.pl [--verbose] [--dry-run] --criteria "*SQL CONDITIONAL EXPRESSION*" ... [--commit] OPTIONS --help Show the brief help information. --manual Read the manual, with examples. --version Show the version number and exit. --verbose Send the "WHERE" clause generated by the collected "--criteria" arguments, as well as items affected to Standard Out. --criteria The "--criteria" option may called multiple times. The following argument must be a syntactically valid SQL statement which is part of the "WHERE" clause querying the items table. These are joined by "AND". --commit No items will be deleted unless the "--commit" flag is present. --dry-run Disables "--commit" flag and enables "--verbose" flag. EXAMPLES The following is an example of this script: delete_items.pl --criteria "items.withdrawn ! 0" --criteria "items.withdrawn_on < $(date --date="13 month ago" --rfc-3339=date)" --commit delete_items.pl --criteria "itemlost >= '1'" --criteria "itemlost <='4'" --criteria "itemlost_on < '2014-04-28'" --commit DESCRIPTION This is a lightweight batch deletion tool for items, suitable for running in a cron job. AUTHOR Barton Chittenden <barton@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.