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 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.taw...@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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha