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