Re: [Koha] Regarding the author entered in 700$a tag

Here's what that would look like pre 17.05: select ExtractValue( marcxml, '//datafield[@tag=700]/subfield[@code="a"]' ) as '700$a' from biblioitems; After 17.05: select ExtractValue( metadata, '//datafield[@tag=700]/subfield[@code="a"]' ) as '700$a' from biblio_metadata; Strictly speaking, the

Re: [Koha] Regarding the author entered in 700$a tag

There are examples of how to use that function in the Koha SQL reports library: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Catalog.2FBibliographic_Reports If using version 17.05 you need to be aware that the location of the stored MARC XML data has changed. Refer to the Release No

[Koha] KohaCon18 - Portland Oregon USA - "Together Towards Tomorrow"

Hello All - It has been decided that the next KohaCon will be in Portland, OR USA from September 10th (Monday) to September 12th (Wednesday) in 2018 - followed by a local cultural day and a 3 day hackfest over the weekend. The theme for KohaCon18 will be "Together Towards Tomorrow". A majority

Re: [Koha] Regarding the author entered in 700$a tag

Hi, You can use extract function for this. On Nov 14, 2017 10:02 PM, "Sahadeo Taware" wrote: > Dear Friends > > I want a simple report in which I want Acc. No., Title, Author, Publisher > and Co-Authors > I entered the co-authors in 700$a tag but there is no koha mapping in this > field, How can

[Koha] Regarding the author entered in 700$a tag

Dear Friends I want a simple report in which I want Acc. No., Title, Author, Publisher and Co-Authors I entered the co-authors in 700$a tag but there is no koha mapping in this field, How can I extract value from 700$a tag Can u please send me the sql query for the same - Sahadeo D. Taware Librar

[Koha] Koha General Meeting Reminder - Roles for 18.05

Hello All, Just a reminder that we have a meeting scheduled tomorrow, 15 November 2017, 14:00 UTC This meeting will be held to vote on roles for 18.05 The agenda is here: https://wiki.koha-community.org/wiki/General_IRC_meeting_15_November_2017#Agenda You can see candidates (or add your name) h

[Koha] Statistics on Z39.50

Good morning I wish to know how much Z39 is used in Koha, but I have no idea where to get info from z39.50 usage... any body could help us on this. how to retreive z39.50 server statistics in koha? Kindest regards -- *Hugo Agud - Orex Digital * *www.orex.es *