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.2FBibliogra... 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 Notes for that version. Bob Birchall Calyx On 15/11/17 03:33, vikram zadgaonkar wrote:
Hi, You can use extract function for this.
On Nov 14, 2017 10:02 PM, "Sahadeo Taware" <sahadeo.taware@gmail.com> 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 I extract value from 700$a tag
Can u please send me the sql query for the same - Sahadeo D. Taware Librarian, M.L.I.Sc., NET Thakur College of Science and Commerce Thakur Village, Kandivli(E), Mumbai 400101 Mob. No 9324912816