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 latter isn't *quite* correct, because biblio_metadata may eventually hold non-marcxml metadata, so we should be testing select ExtractValue( metadata, '//datafield[@tag=700]/subfield[@code="a"]' ) as '700$a' from biblio_metadata where format='marcxml'; you may want to future-proof your queries accordingly. On Tue, Nov 14, 2017 at 7:39 PM, Bob Birchall <b...@calyx.net.au> wrote: > There are examples of how to use that function in the Koha SQL reports > library: > https://wiki.koha-community.org/wiki/SQL_Reports_Library#Cat > alog.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 > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
