[Koha] SQL report 650 a

Holger Meissner Holger.Meissner at hs-gesundheit.de
Sat Jan 4 01:31:21 NZDT 2014

yoonus para wrote:
> Dear all,
> How to create a SQL report using field 650 a with barcode and title,Please help me to create this report.
> Thanks
> Yoonus

Did you find a solution? I thought it might be interesting, but I also can't figure it out.

When I run
SELECT * FROM marc_subfield_structure WHERE tagfield = 650 AND tagsubfield = 'a'

it tells me the "kohafield" is bibliosubject.subject, yet it seems that I don't have a table called bibliosubject. Is that normal?

More information about the Koha mailing list