Re: [Koha] Allow on shelf reserves

Hi Bob, the new third option was added by bug 15534 for 16.05: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15534 The patches added a third option and changed the descriptions to be more precise: Yes (unchanged, we don't care about availability) If all unavailable (new behaviour

Re: [Koha] SQL Help - Daily (on Monthly basis) & Monthly (on Yearly basis) Transactions Counts (Circulation)

On Mon, Mar 6, 2017 at 8:25 AM, Mark Alexander wrote: > > Pretty close! Just some misplaced parens: > > SELECT > monthname(datetime), > SUM( IF(type = 'issue', 1, 0 )) as issues, > SUM( IF(type = 'renew', 1, 0 )) as renewals, > SUM( IF(type = 'return', 1, 0 )) as returns

Re: [Koha] SQL Help - Daily (on Monthly basis) & Monthly (on Yearly basis) Transactions Counts (Circulation)

Excerpts from Barton Chittenden's message of 2017-03-06 08:08:04 -0500: > I'll do the 'month, by year'; the 'day by month' one will follow the same > pattern. > > SELECT > monthname(datetime), > SUM( IF(type = 'issue'), 1, 0 ) as issues, > SUM( IF(type = 'renew'), 1, 0 ) as renewals, >

Re: [Koha] SQL Help - Daily (on Monthly basis) & Monthly (on Yearly basis) Transactions Counts (Circulation)

Statish, I'll do the 'month, by year'; the 'day by month' one will follow the same pattern. SELECT monthname(datetime), SUM( IF(type = 'issue'), 1, 0 ) as issues, SUM( IF(type = 'renew'), 1, 0 ) as renewals, SUM( IF(type = 'return'), 1, 0 ) as returns FROM statistics WHERE

[Koha] Vendor who contribute for LIS community: Koha

Dear All, I on behalf of entire LIS fraternity thanks to Mr. Indranil Das Gupta , a Koha developer from India ( http://www.l2c2.co.in/ ) for his contributions/help for entire Library professionals. He has contributed many patch as well as gifted some features to

[Koha] Barcode error

hello when staff put the item in the koha through catologue it gives the error message , barcode error , i opted to use accession number as barcode so as to avoid duplicate of data in the system but when i search in the database i will found the item with the callnumber , but when i try to sear