On 03/01/14 23:31, Holger Meissner wrote:
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?
Yes that is normal. 'Subject' is not separately defined in the data
base. Subject data are stored as part of biblioitems.marcxml. You can
report on the data using the 'extract value' command in SQL. There
should be examples in the library:
http://wiki.koha-community.org/wiki/SQL_Reports_Library
Best wishes,
Bob Birchall
Calyx
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
