This is a pretty brilliant idea, imo. Perfect use for the tool. Liz Rea lrea@nekls.org On Apr 30, 2012, at 12:41 PM, Eric Bégin wrote:
Paul,
Have you consider having your report generating a list of barcodes and using this list in the Batch Item modification tool to change the accesiondate ?
Regards,
Eric Bégin www.inLibro.com
On 2012-04-30 09:13, Paul wrote:
Good morning all:
I have no problem with the philosophy of the following (bright yellow) pop-up error message: "The following error was encountered: This report contains the SQL keyword UPDATE. Use of this keyword is not allowed in Koha reports due to security and data integrity risks." and would not even consider suggesting a "bug."
However, it would be most helpful to staff for a very specific but repetitive job that we do at year end (batch changing items.accessiondate after Tax Receipts have been issued for donations) to be able to use Koha from a work station, rather than getting me to work directly on the production server (I've already been asked 50 or 60 times, and there's another 400+ to go ...!)
Can anyone point me rapidly to the portion of script that I should have a look at?
For the record, the CLI mysql in question is:
UPDATE items SET dateaccessioned='2011-12-31' WHERE price IS NOT NULL and price != '0.00' AND booksellerid = 'xxx' AND DATE(dateaccessioned) BETWEEN '2011-01-01' AND '2011-12-31';
Obviously for a report, I would use a construct for the last two conditions along the lines of:
AND booksellerid = <<Pick your donor>> AND DATE(dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>>;
Thanks and best regards, Paul
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
