[Koha] Regarding sql report for analytical records created

[Jonathan Druart]

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