[Koha] Serials enumeration & chronology in a report

How can I pull a list of serials holdings with enumeration & chronology information in a report? Thanks & regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320 [image: https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZy

[Koha] Barcode Issue-Please Help!

We are having issues with our barcodes. They are not generating as we expect them to and we'd like to know if anyone has any input regarding the following issue. Here is my original message: While editing items that are being added to our collection, when we click in the field (p - Pi

Re: [Koha] Holds and one day loans

Hi! If the one-day-loans and the regular loans have a different itemtype you can use the system preference AllowHoldItemTypeSelection. Setting it to Allow, will set hold fulfillment to be limited to the selected itemtype. This should give you most (if not all) of the wanted behavior. See: http

Re: [Koha] LDAP authentication problem

> On Mar 18, 2019, at 9:55 AM, Lichtsteiner Patric (lici) wrote: > > Hi all, > > We are currently evaluating koha for our university. > > Right now, I’m trying to configure ldap authentication. I followed the > following guides: > https://openschoolsolutions.org/koha-ldap-setup/ > https://per

Re: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject

Hi all, Holger, it looks your syntax works. I've modified your report to reflect a few other things. I managed to get the following to work successfully: SELECT * FROM ( SELECT biblioitems.isbn, items.barcode, items.itemcallnumber, biblio.title, biblio.

Re: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject

Hi Craig, does it work like this? SELECT * FROM ( SELECT items.dateaccessioned, items.barcode, items.itemcallnumber, biblio.title, biblio.author, biblioitems.publishercode, ExtractValue(biblio_metadata.metadata,'//datafield[@tag="650"]/

Re: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject

Craig, You need to join biblio_metadata in the FROM clause (I also removed the outer SELECT statement, It's going to slow down your query, and it doesn't do much). SELECT items.dateaccessioned, items.barcode, items.itemcallnumber, biblio.title, biblio.author, biblioitems.p

Re: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject

Hi everyone, Mohammad, Barton, thanks very much for this. Unfortunately, I've already tried this report (I found it on the Koha SQL reports page online) and it returns the following error (even after I replace the "biblioitems.marcxml" statement with "biblio_metadata.metadata"): *The following er

Re: [Koha] String Freeze (Maintenance Branches)

Ack.. of course I meant "now" not "not".. We are now in string freeze... and release is due for the 25th. Apologies for the confusion, *Martin Renvoize* Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.ren

[Koha] Holds and one day loans

Kia ora, dear Community! Here's a tricky one, at least it has proven so to me... Say a library has two kinds of books: - One-day-loan - loans that are due at 23:59 on the day you borrow them and that can not be reserved/put a hold on - Regular loan - can be borrowed for e.g. 28 days and can be r

Re: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject

The data formerly found in biblioitems.xml moved to biblio_metadata.metadata in Koha 17.05. On Tue, Mar 19, 2019, 3:10 AM Mohammad Nashbat wrote: > Sorry, below is the correct one. > > SELECT * > FROM(SELECT > items.dateaccessioned, > items.barcode, > items.itemcallnumber, > bibl

[Koha] String Freeze (Maintenance Branches)

Hi All, Just a quick notification that we're not in string freeze for the maintenance branches, with the series of maintenance releases due on the 18th. Go forth and update your translations, Many thanks, *Martin Renvoize* Development Team Manager *Phone:* +

Re: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject

Sorry, below is the correct one. SELECT * FROM(SELECT items.dateaccessioned, items.barcode, items.itemcallnumber, biblio.title, biblioitems.isbn, biblioitems.publishercode, (SELECT ExtractValue(biblioitems.marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]')) AS S

Re: [Koha] Koha 18.11 - SQL report to select ISBNs by Subject

Hi Craig, We are using the below SQL report, I hope it do the needful for you. SELECT * FROM(SELECT items.dateaccessioned, items.barcode, items.itemcallnumber, biblio.title, biblioitems.isbn, biblioitems.publishercode, (SELECT ExtractValue(biblioitems.marcxml,'//dataf