Re: [Koha] sql query to include Tag 650 data in the report
Hi Mahesh, See https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC hope this helps Indranil Das Gupta L2C2 Technologies On Tue, 4 Oct, 2022, 11:09 am Mahesh Angadi, wrote: > Hi, I am using Koha 3.20, > > In report generation, I am able to get details like title, author, year, > publisher, call number, etc, But I am not able to get data related to Tag > 650 - Subject. I couldn't find the relevant field in guided wizard of > report also. > > I am sharing my sql query. Kindly suggest the additions to sql query with > which I can also get data related to Tag 650 - Subject. > > I have stored all Tag 650 data in one column only (its not a repeatable > field, in our case. Eg. one subject name is added for all titles, for eg, > Economics) > =650 \\$aEconomics > > Our Report SQL Query is as follows:- > > SELECT > > > items.barcode,biblio.title,biblio.author,biblioitems.publishercode,biblio.copyrightdate,items.itemcallnumber,biblioitems.isbn > FROM items LEFT JOIN biblioitems on > (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on > (biblioitems.biblionumber=biblio.biblionumber) WHERE > items.itype=<> ORDER BY items.barcode asc > > > > -- > Mr. Mahesh Angadi, > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] sql query to include Tag 650 data in the report
Hi, I am using Koha 3.20, In report generation, I am able to get details like title, author, year, publisher, call number, etc, But I am not able to get data related to Tag 650 - Subject. I couldn't find the relevant field in guided wizard of report also. I am sharing my sql query. Kindly suggest the additions to sql query with which I can also get data related to Tag 650 - Subject. I have stored all Tag 650 data in one column only (its not a repeatable field, in our case. Eg. one subject name is added for all titles, for eg, Economics) =650 \\$aEconomics Our Report SQL Query is as follows:- SELECT items.barcode,biblio.title,biblio.author,biblioitems.publishercode,biblio.copyrightdate,items.itemcallnumber,biblioitems.isbn FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype=<> ORDER BY items.barcode asc -- Mr. Mahesh Angadi, ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 21.11.12 released
Hi dear Koha Community, Koha 21.11.12 is a bugfix/maintenance release. Apart from being a palindrome, it includes 10 enhancements, 37 bugfixes. More information on the improvements : https://koha-community.org/koha-21-11-12-released Much apologize for the delay on this particular release, BibLibre and I will do our best to release the next one on time. Best, -- Arthur Suzuki, ️ Développeur @BibLibre ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-docs] Additional page text editing request - Koha
Hi David, Koha-docs isn't the right mailing list for this query. The right one is koha@lists.katipo.co.nz :-) What you have encountered is https://wiki.koha-community.org/wiki/Koha_as_a_CMS (warning: the page hasn't been updated in quite a while, so the line no. references are unlikely to be accurate) The content which you are looking to edit should be under Administration -> System Preferences -> Local use once there, look for entry where the variable looks like "page_dlibraries" Hope this helps Indranil Das Gupta L2C2 Technologies On Mon, 3 Oct, 2022, 7:02 pm David Demetrashvili, wrote: > Dear Team, > Let me kindly ask you, how can I change additional page text? > http://library.gipa.ge/pages.pl?p=dlibraries > I tried to find the answer but nothing is for that. > Could you help me? > Thank you! > -- > Best Regards, > *David Demetrashvili* > Head of IT Department > > > 9, Ietim Gurji > Tbilisi, 0114, Georgia > T: (995 32) 249 74 75 > M: (995) 551 68 20 20 > E-mail: d.demetrashv...@gipa.ge > www.gipa.ge > ___ > Koha-docs mailing list > koha-d...@lists.koha-community.org > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-docs > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problem upgrading RabbitMQ / Erlang
Hi Mason. Thank you, that was very helpful. Isabel -Mensaje original- De: Mason James Enviado el: sábado, 1 de octubre de 2022 04:48 Para: Isabel Pineda ; Koha Asunto: Re: [Koha] Problem upgrading RabbitMQ / Erlang On 29/09/22 3:03 am, Isabel Pineda wrote: > Hi Mason. > > Just one more question. After removing the PackageCloud repository, the > output of the command 'apt policy rabbitmq-server erlang-base' is now > > > rabbitmq-server: > Installed: 3.10.7-1 > Candidate: 3.10.7-1 > Version table: > *** 3.10.7-1 100 > 100 /var/lib/dpkg/status > 3.9.13-1 500 > 500 http://asi-fs-d.contabo.net/ubuntu jammy/main amd64 Packages > > 500 http://asi-fs-d.contabo.net/ubuntu jammy/main i386 Packages > > >Can the missing 500 entry for rabbitmq-server 3.10.7-1 be a problem? hmm, its probably not a problem > What other repository for rabbitmq-server can I use apart from Package Cloud? it seems Package Cloud does not currently support ubuntu 22.04/jammy https://www.rabbitmq.com/install-debian.html you should use the debian/ubuntu repositories, or a mirror like contabo https://packages.ubuntu.com/jammy/rabbitmq-server ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to SMS Integration in Koha
Hi, maybe this will help to get you started: https://koha-community.org/manual/22.05/en/html/faq.html?#sms-notices-messages Hope this helps, Katrin On 03.10.22 10:41, Taimoor Memon wrote: Hello! Dear Community, We are using koha version 20.05.05, we need support to integrate SMS service in ILs. What are the requirements for this? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] How to SMS Integration in Koha
Hello! Dear Community, We are using koha version 20.05.05, we need support to integrate SMS service in ILs. What are the requirements for this? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha