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: koha-bugs@lists.koha-community.org Reporter: nishathahmed@gmail.com QA Contact: testopia@bugs.koha-community.org 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.