Hello, Syntactically the query is wrong, try replacing 'bi' with 'biblioitems' Regards, Jonathan On Tue, 30 May 2017 at 10:53 Suresh Kumar Tejomurtula <tejoskumar@gmail.com> wrote:

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 Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha