Hi Satish, On Fri, Apr 1, 2016 at 12:55 PM, SATISH <lis4satish@gmail.com> wrote:
Thank you Suzon, but I have a range or list of specific barcodes identified to be kept in reference, ex: 1, 253, 588 etc, it is random. In this case, in SQL, should I write.
UPDATE items SET notforloan =1, location = 'REF' WHERE barcode = '1', '253' <snipped>
You are approaching the issue from a more difficult and IMHO a *bad* angle, especially since you are not adept at SQL and you are trying to directly edit the database, which should be avoided as far as possible. What you *should* be using in this case is follow http://manual.koha-community.org/3.22/en/batchmodifyitems.html I'm assuming you are using the latest Koha i.e. 3.22 series. cheers -Indranil -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 IRC : indradg on irc://irc.freenode.net Twitter : indradg Facebook : https://www.facebook.com/l2c2technologies/ -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org