- Koha-devel - lists.koha-community.org

Re: [Koha-devel] SQL Query to get the Waiting Holds From reserves table.
by Michael Hafen 28 Jun '19

28 Jun '19

It's a left outer join, which means we will get all the applicable rows from reserves but not necessarily from issues. If there isn't a matching row in issues then we get null values instead. The date_due column should never be null otherwise. So that query should show reserves with no issue. On Wed, Jun 26, 2019, 10:50 PM RAGHAV ARORA < f20171016(a)pilani.bits-pilani.ac.in> wrote: > Thank you for your reply Sir. > > Why are we querying for issues that have Null date_due? Should we not > query for the reserves corresponding to which no issues exist. > > When will the date_due be null? > > Regards, > *Raghav Arora* > Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering > Contact : (+91) 9897597761 > Personal Email <raghavarora999(a)yahoo.in> | University Email > <f20171016(a)pilani.bits-pilani.ac.in> > LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub > <https://github.com/RAraghavarora/> > > ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ > *Birla Institute of Technology and Science, Pilani* > Pilani campus, > Rajasthan-333031 > > > On Wed, Jun 26, 2019 at 10:44 PM Michael Hafen <michael.hafen(a)washk12.org> > wrote: > >> Here's me trying the query with more joins instead of sub-selects, though >> I can't guarantee it's exactly what you want. >> >> SELECT borrowers.surname, borrowers.email, borrowers.cardnumber, >> it1.barcode, biblio.title, reserves.reservedate >> FROM reserves >> LEFT JOIN borrowers USING (borrowernumber) >> LEFT JOIN biblio USING (biblionumber) >> LEFT JOIN items AS it1 USING (itemnumber) >> LEFT JOIN issues AS iss1 USING (itemnumber) >> LEFT JOIN items AS it2 ON (reserves.biblionumber = it2.biblionumber) >> LEFT JOIN issues AS iss2 ON(it2.itemnumber = iss2.itemnumber) >> WHERE iss1.date_due IS NULL AND iss2.date_due IS NULL >> >> >> On Wed, Jun 26, 2019 at 12:45 AM RAGHAV ARORA < >> f20171016(a)pilani.bits-pilani.ac.in> wrote: >> >>> Hello all, >>> >>> Could someone please help me in creating the SQL query to get all the >>> holds in the library for which the book is available,in the library (i.e, >>> no issue exists for that book) >>> >>> The reserves table contains some rows for which itemnumber is Null, and >>> the waitingdate is Null for every row even if no issue exists for the item. >>> >>> I came up with the following sql query, but I am not sure if I am right, >>> can someone please verify my query, or rectify it with the correct query: >>> >>> ```SELECT >>> borrowers.surname, borrowers.email, borrowers.cardnumber, >>> items.barcode, biblio.title, reserves.reservedate >>> FROM reserves >>> LEFT JOIN borrowers USING (borrowernumber) >>> LEFT JOIN items USING (itemnumber) >>> LEFT JOIN biblio ON (reserves.biblionumber = biblio.biblionumber) >>> WHERE >>> (reserves.itemnumber IS NOT NULL >>> AND NOT EXISTS(SELECT issue_id FROM issues WHERE >>> items.itemnumber = issues.itemnumber) >>> ) >>> OR >>> (reserves.itemnumber IS NULL >>> AND EXISTS( >>> SELECT itemnumber FROM items i2 WHERE >>> items.biblionumber=reserves.biblionumber >>> AND NOT EXISTS( >>> SELECT issue_id FROM issues WHERE >>> issues.itemnumber=i2.itemnumber >>> ) >>> ) >>> ) >>> ``` >>> >>> Thanks in advance >>> Regards >>> *Raghav Arora* >>> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics >>> Engineering >>> Contact : (+91) 9897597761 >>> Personal Email <raghavarora999(a)yahoo.in> | University Email >>> <f20171016(a)pilani.bits-pilani.ac.in> >>> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub >>> <https://github.com/RAraghavarora/> >>> >>> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ >>> *Birla Institute of Technology and Science, Pilani* >>> Pilani campus, >>> Rajasthan-333031 >>> _______________________________________________ >>> Koha-devel mailing list >>> Koha-devel(a)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/ >> >> >> >> -- >> Michael Hafen >> Washington County School District Technology Department >> Systems Analyst >> >>

2 1

SQL Query to get the Waiting Holds From reserves table.
by RAGHAV ARORA 26 Jun '19

26 Jun '19

Hello all, Could someone please help me in creating the SQL query to get all the holds in the library for which the book is available,in the library (i.e, no issue exists for that book) The reserves table contains some rows for which itemnumber is Null, and the waitingdate is Null for every row even if no issue exists for the item. I came up with the following sql query, but I am not sure if I am right, can someone please verify my query, or rectify it with the correct query: ```SELECT borrowers.surname, borrowers.email, borrowers.cardnumber, items.barcode, biblio.title, reserves.reservedate FROM reserves LEFT JOIN borrowers USING (borrowernumber) LEFT JOIN items USING (itemnumber) LEFT JOIN biblio ON (reserves.biblionumber = biblio.biblionumber) WHERE (reserves.itemnumber IS NOT NULL AND NOT EXISTS(SELECT issue_id FROM issues WHERE items.itemnumber = issues.itemnumber) ) OR (reserves.itemnumber IS NULL AND EXISTS( SELECT itemnumber FROM items i2 WHERE items.biblionumber=reserves.biblionumber AND NOT EXISTS( SELECT issue_id FROM issues WHERE issues.itemnumber=i2.itemnumber ) ) ) ``` Thanks in advance Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

2 1

Development meeting reminder
by Renvoize, Martin 26 Jun '19

26 Jun '19

Hi all, Just a quick friendly reminder from your latest RM that we have a developer meeting scheduled for tomorrow: 26 June 2019, 19:00 UTC <https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I…> . The agenda <https://wiki.koha-community.org/wiki/Development_IRC_meeting_26_June_2019#A…> is looking full and I hope it will prompt lots of constructive discussion and move a few important things forward. Looking forward to seeing many of you there.

1 0

Doubt in Koha Database Schema
by RAGHAV ARORA 24 Jun '19

24 Jun '19

Hello everyone, I am currently working on a project on Reports Management and Decision Support System for my institute library that uses Koha as it's ILS. I have a doubt in understanding what is the difference between the fields 'accountlines.amount' and 'accountlines.amountoutstanding'? Could someone help me out with this? Thanks in advance. Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

2 6

Integration Koha/Alma/Primo/Summon
by Leonor Fernandez Alfaro 20 Jun '19

20 Jun '19

Dear colleagues, we are writting from University of Cadiz Library. Our library belongs to the Andalusia Consortium and the ILS used by all its libraries is Alma/Primo VE (ExLibris). We are trying to integrate our Koha catalog in the union catalogue. Do you know any similar experience of an integration Koha/Alma/Primo/Summon? At the same way, do you know any similar experience for a consortium loan with these systems (Koha/Alma/Primo/Summon)? We are very interesting in knowing a similar case. Thank you very much. Kind regards, UCA Leonor Fernández Alfaro Técnico de Gestión de Recursos de Información Sección de Normalización y Proceso Técnico Servicio Central de Biblioteca Universidad de Cádiz C/Dr. Marañón, 3 Cádiz.11002 Tel 956015273 - Ext. 1307 leonor.fernandez(a)uca.es [ mailto:leonor.fernandez@uca.es ] Aviso de Confidencialidad "Este mensaje, y cualquier fichero anexo al mismo, contienen información de carácter confidencial dirigida exclusivamente a su(s) destinatario(s) y, en su caso, sometida a secreto profesional. Queda prohibida su difusión, copia o distribución a terceros sin la previa autorización escrita. Si Vd. ha recibido este mensaje por error, se ruega lo comunique inmediatamente por esta misma vía y proceda a su eliminación". Confidentiality Warning "The information in this e-mail, and in any attachments, is confidential and, if any, protected by a professional privilege, and intended solely for the attention and use of the named addressee(s). You are hereby notified that any dissemination, copy or distribution of this information is prohibited without the prior written consent. If you have received this communication in error, please notify the sender by reply e-mail and delete it".

1 0

Updatedatabase and use module
by Fridolin SOMERS 20 Jun '19

20 Jun '19

Hi, Since bug 21073 in master, I get an error when upgrading from 18.11 : ... Upgrade to 18.12.00.066 done (Bug 8995 - Add new preferences for OpenURLResolvers) Upgrade to 18.12.00.067 done (Bug 8000 - Add new preferences for SendAllEmailsTo) Upgrade to 18.12.00.068 done (Bug 7088: Cannot renew items on hold even with override) DBD::mysql::st execute failed: Table 'koha.plugin_methods' doesn't exist [for Statement "SELECT `me`.`plugin_class` FROM `plugin_methods` `me` GROUP BY `me`.`plugin_class`"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834. DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha.plugin_methods' doesn't exist at /home/koha/src/Koha/Plugins.pm line 89 Whasn't it forbiden to use DBIx in updatedatabase ? Best regards, -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

2 2

New Koha staff theme plugin
by Fridolin SOMERS 19 Jun '19

19 Jun '19

Hi I'm proud to give you a new Koha staff theme plugin : https://github.com/biblibre/koha-plugin-theme-intranet-lsd You should read the README ;) Have fun XD -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

2 1

Koha barcode - ID Processing
by Jeremy Smith 18 Jun '19

18 Jun '19

Hello, I wonder if you can point use in the right direction to modify the Koha system we’ve just installed? We’ve set up a basic system to use with bar codes and bar code readers for both items and patrons. The problem is that our ID card barcodes add two leading 0s to staff IDs (7 digits vs 9 digits for students) and also the last number is not part of the ID number but the card issue number. Somehow we want to intercept the string to remove any leading zeros and also delete the last digit before it gets used as the patron number by Koha. Could you give us a pointer as to where I should be looking (i.e. any documentation or which module to look at) and what string I should be processing? Many thanks, Jeremy

1 0

Call for News: June 2019 Newsletter
by kohanews 14 Jun '19

14 Jun '19

I'm collecting news for the June newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Arabic records indexing
by MHE IT admin 14 Jun '19

14 Jun '19

Hi, We have finished entering all our library records to our Koha System (18.05.05.000) and now we have an issue with indexing our Arabic records. We can not search in Arabic to find records. Is there anyone out there who has done this and would like to share their experience with us, please? http://library.koyauniversity.org Respectfully

3 2