https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27302
Bug ID: 27302
Summary: couldn't view biblio.author on reports
Change sponsored?: ---
Product: Koha
Version: 20.11
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Reports
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Created attachment 114662
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=114662&action=edit
Koha-report
hi There,
I just want to take report of item bar code and author of book. I can get
barcode and failed to fetch author by executing following SQL
SELECT items.barcode, biblio.author FROM items LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on
(biblioitems.biblionumber=biblio.biblionumber) GROUP BY
items.barcode,biblio.author.
I get empty column on author when I execute this SQL statement. I entered my
catalogue entry on fast add framework with statement of responsibility as
author.
But still no luck. You can refer attachments of output. Correct me if I am
wrong or raise as bug.
Thanks!
Nishath
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
