Bug 27302

Summary: couldn't view biblio.author on reports
Product: Koha Reporter: Nishath Ahmed <nishathahmed>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: jonathan.druart, nishathahmed
Version: 20.11   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Koha-report

Description Nishath Ahmed 2020-12-23 07:37:03 UTC
Created attachment 114662 [details]
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
Comment 1 Jonathan Druart 2021-01-05 07:00:09 UTC
This is a support question, please ask the mailing list
https://koha-community.org/support/koha-mailing-lists/