[Koha-bugs] [Bug 27302] New: couldn't view biblio.author on reports

[bugzilla-daemon at bugs.koha-community.org]

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