Hi, I would like to get a report on analytical records created in koha.
The below is the query I tried, but getting a blank output. Iam very new to sql reports. I tried looking in the sql reports library, but could not get any. SELECT biblio.biblionumber, biblio.title, biblio.author, ExtractValue(bi.marcxml,'//datafield[@tag="773"]/subfield[@code="0"]') AS hostrecordnumber FROM biblio LEFT JOIN biblioitems ON (biblio.biblionumber=biblioitems.biblionumber) where ExtractValue(bi.marcxml,'//datafield[@tag="773"]/subfield[@code="0"]') is not null -- Regards T. Suresh Kumar _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
