[Koha] Report question

Hi All - I want to set up a SQL report that can take a variable number of the same value. My SQL looks like: select biblionumber, concat (branchname, ', ', lib) as location, itemcallnumber, if(onloan is null,'Available',onloan) onloan from items,authorised_values,branches where biblionumber in (<

Re: [Koha] Report question

ailto:francois.charbonn...@inlibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> Le 2016-04-21 11:16, Graham, Stephen a écrit : > Hi All - I want to set up a SQL report that can take a variable number of the > same value. My SQL looks like: > > s

[Koha] Updating 856 Field

Hi All - we want to change the 856 field in over 18,000 records. The actual change itself is easy - simply URL encoding the existing URL, and then prefixing it with another value. I am thinking of scripting this job. 1. Identity and retrieve the biblio IDs from a SQL query 2. Itera

[Koha] Holds and emails question

Hi All - we've only just implemented holds, we went live 3 weeks ago. One thing we are grappling with is books which have holds on, going "missing" before they get to the holds shelf. At the moment if a user returns an item via the Selfcheck machines,which is on hold for another user, then an em

Re: [Koha] Koha & Primo link (sub-question: University of Tyler, TX are you around ?)

I know it's not Primo, but we do something similar with Summon. We wrote a custom script which outputs some XML which Summon reads, and then renders the availability. The script can take one, or several Koha BIB IDs. If you look at: http://herts.summon.serialssolutions.com/#!/search?ho=t&l=en-UK

Re: [Koha] Ajax call in self checkout not working in Koha 17.05

Krishna - what does the Ajax call look like? A bit of sample code might help? Stephen -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Krishna K Sent: 06 December 2017 09:01 To: koha@lists.katipo.co.nz Subject: Re: [Koha] Ajax call in self checkout not w