[Koha-devel] SQL reports [error]

[Liz Rea]

This is a pretty brilliant idea, imo. Perfect use for the tool.

Liz Rea
lrea at 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 at 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 at 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/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20120430/cb1594fa/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: email_signature.jpeg
Type: image/jpeg
Size: 4862 bytes
Desc: not available
URL: </pipermail/koha-devel/attachments/20120430/cb1594fa/attachment.jpeg>