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
On 03/01/14 23:31, Holger Meissner wrote: 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